Project Tasks You are required to accomplish the following tasks: 1. Normalize the Database to the third
Question:
Project Tasks
You are required to accomplish the following tasks:
1. Normalize the Database to the third normal form.
2. Draw the EER Diagram and the Cluster Diagram.
3. Implement the Relational Database Using MySQL. Include relationships and at least four records for each table.
4. Create a function that checks if a book exists and returns the answer. Create a second function that can be used to check the type of book and return the answer.
5. Create a procedure that can be used to borrow a book. It should check if the book exists and if it can be borrowed before borrowing the book by calling the relevant functions.
6. Implement an Object Oriented Database for the Books entity that can be able to get and display the details of a book.
7. Implement the books and borrowing entities using Oracle NoSQL. You should be able to insert a new book, display the book and display the book titles of books borrowed by a specified user.
The Georgia Tech Library (GTL) has approximately 16,000 members, 100,000 titles, and 250,000 volumes (an- average of 2.5-copies-perbeok). About 10 percent of the volumes are out on loan at any one time. The librarians ensure that the books that members want to borrow are available when the members want to borrow them. Also, the librarians must know how many copies of each book are in the library or out on loan at any given time. A catalog of books is available online that lists books by author, title, and subject area. For each title in the library, a book description is kept in the catalog that ranges from one sentence to several pages. The reference librarians want to be able to access this description when members request information about a book. Library staff includes chief librarian, departmental associate librarians, reference librarians, check-out staff, and library assistants. Books can be checked out for 21 days. Members are allowed to have only five books out at a time. Members usually return books within three to four weeks. Most members know that they have one week of grace before a notice is sent to them, so they try to return books before the grace period ends. About 5 percent of the members have to be sent reminders to return books. Most overdue books are returned within a month of the due date. Approximately 5 percent of the overdue books are either kept or never returned. The most active members of the library are defined as those who borrow books at least ten times during the year. The top 1 percent of membership does 15 percent of the borrowing, and the top 10 percent of the membership does 40 percent of the borrowing. About 20 percent of the members are totally inactive in that they are members who never borrow. To become a member of the library, applicants fill out a form including their SSN, campus and home mailing addresses, and phone numbers. The librarians issue a numbered, machine-readable card with the member's photo on it. This card is good for four years. A month before a card expires, a notice is sent to a member for renewal. Professors at the institute are considered automatic members. When a new faculty member joins the institute, his or her information is pulled from the employee records and a library card is mailed to his or her campus address. Professors are allowed to check out books for three-month intervals and have a two-week grace period. Renewal notices to professors are sent to their campus address. The library does not lend some books; such as reference books, rare books, and maps. The librarians must differentiate between books that can be lent and those that cannot be lent. In addition, the librarians have a list of some books they are interested in acquiring but cannot obtain, such as rare or out-of-print books and books that were lost or destroyed but have not been replaced. The librarians must have a system that keeps track of books that cannot be lent as well as books that they are interested in acquiring. Some books may have the same title; therefore, the title cannot be used as a means of identification. Every book is identified by its International Standard Book Number (ISBN), a unique international code assigned to all books. Two books with the same title can have different ISBNS if they are in different languages or have different bindings (hardcover or softcover). Editions of the same book have different ISBNS. The proposed database system must be designed to keep track of the members, the books, the catalog, and the borrowing activity. Draw an EER diagram of the library database. The Georgia Tech Library (GTL) has approximately 16,000 members, 100,000 titles, and 250,000 volumes (an- average of 2.5-copies-perbeok). About 10 percent of the volumes are out on loan at any one time. The librarians ensure that the books that members want to borrow are available when the members want to borrow them. Also, the librarians must know how many copies of each book are in the library or out on loan at any given time. A catalog of books is available online that lists books by author, title, and subject area. For each title in the library, a book description is kept in the catalog that ranges from one sentence to several pages. The reference librarians want to be able to access this description when members request information about a book. Library staff includes chief librarian, departmental associate librarians, reference librarians, check-out staff, and library assistants. Books can be checked out for 21 days. Members are allowed to have only five books out at a time. Members usually return books within three to four weeks. Most members know that they have one week of grace before a notice is sent to them, so they try to return books before the grace period ends. About 5 percent of the members have to be sent reminders to return books. Most overdue books are returned within a month of the due date. Approximately 5 percent of the overdue books are either kept or never returned. The most active members of the library are defined as those who borrow books at least ten times during the year. The top 1 percent of membership does 15 percent of the borrowing, and the top 10 percent of the membership does 40 percent of the borrowing. About 20 percent of the members are totally inactive in that they are members who never borrow. To become a member of the library, applicants fill out a form including their SSN, campus and home mailing addresses, and phone numbers. The librarians issue a numbered, machine-readable card with the member's photo on it. This card is good for four years. A month before a card expires, a notice is sent to a member for renewal. Professors at the institute are considered automatic members. When a new faculty member joins the institute, his or her information is pulled from the employee records and a library card is mailed to his or her campus address. Professors are allowed to check out books for three-month intervals and have a two-week grace period. Renewal notices to professors are sent to their campus address. The library does not lend some books; such as reference books, rare books, and maps. The librarians must differentiate between books that can be lent and those that cannot be lent. In addition, the librarians have a list of some books they are interested in acquiring but cannot obtain, such as rare or out-of-print books and books that were lost or destroyed but have not been replaced. The librarians must have a system that keeps track of books that cannot be lent as well as books that they are interested in acquiring. Some books may have the same title; therefore, the title cannot be used as a means of identification. Every book is identified by its International Standard Book Number (ISBN), a unique international code assigned to all books. Two books with the same title can have different ISBNS if they are in different languages or have different bindings (hardcover or softcover). Editions of the same book have different ISBNS. The proposed database system must be designed to keep track of the members, the books, the catalog, and the borrowing activity. Draw an EER diagram of the library database.
Expert Answer:
Complete required solution 3rd Normal Form Definition A database is in third normal form if it satis... View the full answer
Probability and Statistics for Engineers and Scientists
ISBN: 978-0495107576
3rd edition
Authors: Anthony Hayter
Students also viewed these accounting questions
-
Georgia Tech wants to survey its students about whether they think Bobby Dodd Stadium should be renovated. Because female undergraduates, male undergraduates, female graduate students, and male...
-
Question 1. This question is based on a journal article that appeared in the New England Journal of Medicine: Gawande AA et al., "Risk factors for retained instruments and sponges after surgery."...
-
|7-x| Identify the value the given function is NOT continuous. y=- 7-x
-
Find the point-slope form of the line pass- ing through the given points. Use the first point as (x 1 , y 1 ). (-3,4), (2,5)
-
A new refrigerant R-410a is a mixture of R-32 and R-125 in a 1:1 mass ratio. What are the overall molecular weight, the gas constant and the ratio of specific heats for such a mixture?
-
The Victory Plus Mutual Fund of growth stocks has had the following average monthly price for the past 10 months: Month ........ Fund Price 1 ........... 62.7 2 ........... 63.9 3 ........... 68.0 4...
-
Reconsider Problem 56. Determine which oven should be purchased based on an incremental annual worth analysis. Data from problem 56 Octavia Bakery is planning to purchase one of two ovens. The...
-
A beginning accounting student tried to complete a work sheet for Joyce Lee's Tax Service. The following adjusting entries were to have been analyzed and entered onto the work sheet. The work sheet...
-
XYZ Inc., a well-known manufacturer of inflatable boats is considering a new project, a thickened inflatable boat. Thickened boat is of higher quality and double the price of the normal inflatable...
-
Readers Digest has asked you to analyze an investment proposal that it has received. This proposal relates to Readers Digest producing a CD-ROM version that will contain the text of all of the...
-
9.5 CORPORATE VALUATION You expect a company to generate $30 million in free cash flow next year, and you expect the FCF to grow at a constant rate of 5% per year indefinitely. The company has no...
-
A rugby player passes the ball 8.25 m across the field, where it is caught at the same height as it left his hand. At what angle was the ball thrown if its initial speed was 12.0 m/s, assuming that...
-
Part-B Case-scenario questions: Answer the following questions in each case Sarah works as a cook at the La Bellissima restaurant of The Continent Hotel. Today, two guests arrived and ordered two...
-
A right triangle has a hypotenuse of length 4.30 m, and one of its angles is 26.0. What are the lengths of the following sides? (a) the side opposite the 26.0 angle m (b) the side adjacent to the...
-
Apply appropriate data analytics techniques(Izzy) Perform the necessary analyses to answer the second key question: Does the nanosatellite data predict stock returns around earnings announcements...
-
This is for Java: I believe my code is working fine for what I need it to display but can someone help me display the code differently? Right now it looks like this: 1st thread: Random Character: q...
-
When an organization realizes that it might need to create a corporate policy that can be made visible to critics, the organization is most likely going through the organizational learning stage of...
-
PC Contractors, Inc., was an excavating business in Kansas City, Missouri. Union Bank made loans to PC, subject to a perfected security interest in its equipment and other assets, including...
-
Ninety identical electrical circuits are monitored at an extreme temperature to see how long they last before failing. The 50th failure occurs after 263 minutes. If the failure times are modeled with...
-
A randomized block design has four factor levels with sample averages 1 = 11.43. 2 = 12.03, 3 = 14.88, and 4 = 11.76. There are 9 blocks and SSBI = 53.28.1 Also. SSE = 14.12. Compute the ANOVA table....
-
In a scanning process, the number of misrecorded pieces information has a Poisson distribution with parameter = 9.2. (a) What is the probability that there are between 6 and misrecorded pieces of...
-
When an organization decides to replace a legacy system, it usually chooses a contemporary database system over a relational file-based system. But each type of system has its own advantages and...
-
Complete the following sentences: system is also called a distributed data and application client/server system or
-
The textbook states that "data is a resource that must be controlled and managed." Explain this statement, and indicate whether you agree of not, and why.
Study smarter with the SolutionInn App