let’s start our test, let’s build a library system

Now that we have a database system installed and configured, let’s pick a practical application and see if we can build it in each of the environments. The one that comes to mind is a library card catalog system that allows students to check out and check in books. With this system we will create a table that contains information about books and create a table that contains basic information about students. I am picking this example for two reasons. First, it is a simple problem that we should be able to build. Second, my kids school needs a library system and building it helps the school as well as helps me learn. The origional design will be simple. Once we get this design done we will look at more advanced features like protecting columns in a table with encryption, partitioning the data so that we can drop last semesters transactions, backing up the data securely, and restricting table access to prevent dropping or deleting entries from a repository. We might also want to integrate this database with a business process engine to generate reports and late fee reminders.

It is important to keep an eye on our exercise. I am trying to build a foundation of knowledge in database design, administration, and deployment to help learn the Oracle database products and its surrounding packages. I am going to build this exact solution on multiple operating systems and multiple databases as would be done at a corporation. The intention is to be a learning exercise. At each step I will generate a summary of the cost of this solution and effort required to build the “product”. I will try to build this using Oracle Unbreakable Linux, Oracle Database Express Edition, and SQL Developer to provide a zero cost solution to anyone who wants to take this and run with it.

One commercial/non-profit web site that I will use for this exercise is www.librarything.com. This site allows me to create a virtual card catalog of my book collection and export the list as an Excel or CVS file. From this I will import the data into a database table and use it as the list of books that are in our library.

next step, design a data definition for our project. This needs to include table definition, entity relation diagrams, and use cases for our library. I would like to create this solution as a web interface to allow books to be added to the library, students to be added to the school, and books to be checked in and out from the library.

Post Views: 1,399

397 thoughts on “let’s start our test, let’s build a library system”

  80. I as well as my pals were looking through the nice suggestions from your site then then developed a terrible feeling I never thanked the website owner for them. Those boys are already consequently excited to study all of them and now have quite simply been making the most of those things. Many thanks for indeed being so thoughtful and for picking variety of important topics millions of individuals are really wanting to know about. Our own sincere regret for not saying thanks to sooner.

    Reply

  81. Thank you a lot for giving everyone an extraordinarily wonderful opportunity to read from this web site. It can be so beneficial and also stuffed with a lot of fun for me and my office co-workers to search the blog really three times a week to learn the newest guides you will have. And indeed, I’m so always pleased considering the mind-boggling techniques served by you. Certain 3 points on this page are really the very best we’ve had.

    Reply

  98. I enjoy you because of all your valuable labor on this site. My niece take interest in getting into investigations and it’s easy to understand why. A number of us hear all of the compelling form you produce simple guides via this website and as well invigorate participation from people on this theme then our own girl is really studying so much. Take advantage of the rest of the new year. Your performing a terrific job.

    Reply

  99. I am just writing to make you be aware of what a cool discovery my cousin’s princess had going through your web site. She discovered so many issues, most notably what it’s like to possess an amazing teaching style to have other individuals quite simply know a number of very confusing subject matter. You really exceeded my desires. Many thanks for imparting these necessary, healthy, explanatory and fun tips about the topic to Janet.

    Reply

  100. I am glad for writing to let you know what a really good experience my girl experienced visiting your web site. She noticed too many pieces, which include what it is like to possess a marvelous teaching mindset to make most people with no trouble know just exactly certain complicated issues. You truly did more than our own desires. Thanks for giving the useful, dependable, edifying as well as cool tips on this topic to Tanya.

    Reply

  101. I intended to compose you that bit of remark to give many thanks again regarding the pleasing guidelines you have featured on this page. It’s so unbelievably open-handed with you to offer unreservedly just what a few individuals could have sold as an e book to earn some bucks for their own end, mostly now that you might have done it in case you decided. The good ideas also worked to become a easy way to know that other people online have similar keenness just like mine to learn way more with reference to this problem. I am certain there are numerous more pleasant occasions up front for individuals who scan through your site.

    Reply

  114. I have to express some thanks to you just for bailing me out of this situation. As a result of surfing around through the search engines and finding ways which are not helpful, I believed my entire life was gone. Living without the presence of strategies to the difficulties you’ve sorted out all through your entire website is a crucial case, as well as those that might have adversely damaged my entire career if I had not discovered your website. The training and kindness in taking care of all areas was vital. I don’t know what I would have done if I hadn’t come upon such a subject like this. It’s possible to at this point look ahead to my future. Thanks a lot so much for the impressive and results-oriented guide. I will not be reluctant to endorse your blog to any person who ought to have direction about this issue.

    Reply

  115. Needed to put you a little observation to finally say thank you as before for these extraordinary concepts you’ve shared here. It’s so open-handed of people like you to present easily all that a number of us could possibly have offered for an ebook in order to make some profit for their own end, chiefly now that you could possibly have done it in case you desired. The solutions in addition acted like a fantastic way to be sure that other individuals have the same passion similar to my very own to find out more on the topic of this condition. I am sure there are several more fun situations in the future for individuals who looked at your blog post.

    Reply

  116. I happen to be writing to make you be aware of what a cool discovery my girl undergone viewing your web page. She came to find a wide variety of things, including how it is like to have a great giving heart to get the others really easily grasp selected very confusing subject areas. You really surpassed my expectations. Many thanks for providing such helpful, dependable, revealing not to mention cool guidance on this topic to Emily.

    Reply

  125. I intended to send you this tiny observation to finally give many thanks yet again with the spectacular solutions you have documented here. It was quite shockingly open-handed of you to supply openly what exactly most people might have made available for an ebook to earn some bucks for themselves, primarily now that you might well have done it in case you decided. Those advice likewise acted to be the easy way to fully grasp that other people online have similar eagerness just like my own to see many more on the subject of this problem. I’m sure there are thousands of more pleasant sessions up front for those who take a look at your blog.

    Reply

  126. I have to convey my gratitude for your kindness for individuals that absolutely need help on this particular study. Your personal commitment to passing the solution throughout appeared to be particularly helpful and have surely made ladies just like me to realize their aims. Your helpful facts signifies much to me and a whole lot more to my office colleagues. Many thanks; from each one of us.

    Reply

  133. I wanted to write a comment in order to express gratitude to you for all the marvelous guides you are showing at this website. My time intensive internet research has at the end of the day been honored with brilliant knowledge to write about with my neighbours. I would say that most of us readers actually are quite lucky to exist in a wonderful place with so many brilliant professionals with valuable tricks. I feel rather happy to have seen your entire web pages and look forward to so many more cool minutes reading here. Thanks a lot again for a lot of things.

    Reply

  134. Needed to put you this very little observation to finally say thanks over again considering the incredible information you’ve shared in this case. It’s so shockingly generous with people like you to deliver openly precisely what a number of us might have offered as an electronic book in order to make some money for themselves, chiefly since you could have done it if you wanted. These good ideas in addition acted to become great way to know that most people have the identical dreams like my very own to understand much more with regards to this condition. I believe there are millions of more pleasurable periods in the future for folks who looked at your blog post.

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *