You are maintaining a small library for you and your friends to share so everyone can...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are maintaining a small library for you and your friends to share so everyone can add books, and check in and out books for their own use. This small library has grown lately, and you would like to create a small database to manage it better. After careful consideration, you think that the database should store the following data (which is not presented in any particular order or structure). You may have additional data not specifically listed below. Book author(s) - there may be more than one per book Book title ISBN (International Standard Book Number) 13-digit number - unique book identifier Publisher The year when the book was published Number of pages Friend who donated the book to the library Original price paid for the book (by the friend) Where the book was bought When the book was bought Book category (fiction, non-fiction, reference) Book genre (horror, romance, adventure, etc.) Book's subject matter (what the book is about; dogs, technology, cars, etc.) Friend who borrowed the book When the book was checked out When the book was checked in For how long a book was borrowed by one of your friends Complete the following steps: 1. Build a list of business needs, rules and assumptions based upon the scenario and information provided. Include AT LEAST 10 items. 2. Create a relational schema (introduced in Chapter 4) for each entity following the rules of normalization. Show your progression through each normal form from 1st through 3rd, including an explanation of how you have met each normal form. 3. Create an ER Diagram. Define the relationships between the entities, including optionality and cardinality. Use Crow's Foot notation. Refer to Figure 4.35 in Chapter 4 for an example of what your diagram should look like. 4. For organizational purposes, create a data dictionary table (refer to Table 3.6 in Chapter 3). 5. Determine at least 5 indexes you will create and provide a justification. You are maintaining a small library for you and your friends to share so everyone can add books, and check in and out books for their own use. This small library has grown lately, and you would like to create a small database to manage it better. After careful consideration, you think that the database should store the following data (which is not presented in any particular order or structure). You may have additional data not specifically listed below. Book author(s) - there may be more than one per book Book title ISBN (International Standard Book Number) 13-digit number - unique book identifier Publisher The year when the book was published Number of pages Friend who donated the book to the library Original price paid for the book (by the friend) Where the book was bought When the book was bought Book category (fiction, non-fiction, reference) Book genre (horror, romance, adventure, etc.) Book's subject matter (what the book is about; dogs, technology, cars, etc.) Friend who borrowed the book When the book was checked out When the book was checked in For how long a book was borrowed by one of your friends Complete the following steps: 1. Build a list of business needs, rules and assumptions based upon the scenario and information provided. Include AT LEAST 10 items. 2. Create a relational schema (introduced in Chapter 4) for each entity following the rules of normalization. Show your progression through each normal form from 1st through 3rd, including an explanation of how you have met each normal form. 3. Create an ER Diagram. Define the relationships between the entities, including optionality and cardinality. Use Crow's Foot notation. Refer to Figure 4.35 in Chapter 4 for an example of what your diagram should look like. 4. For organizational purposes, create a data dictionary table (refer to Table 3.6 in Chapter 3). 5. Determine at least 5 indexes you will create and provide a justification.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these databases questions
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
do the following,..... Write program that reads a person's first and last names, separated by a space. Then the program outputs last name, comma, first name. Create program that takes in user input...
-
If r = (t, t 2 , t 3 ), find r(t) and r(t).
-
Three point locations on the surface of a drilled hole have been measured by a CMM in the x-y axes. The three coordinates are: (16.42, 17.17), (20.20, 11.85), and (24.08, 16.54), where the units are...
-
Adams Company reports the following balance sheet accounts as of December 31. Salaries payable Buildings $ 7,200 Retained earnings Prepaid rent Merchandise inventory Accounts payable Prepaid...
-
A laminar boundary layer velocity profile is approximated by \(u / U=2(y / \delta)-2(y / \delta)^{3}+(y / \delta)^{4}\) for \(y \leq \delta\), and \(u=U\) for \(y>\delta\). (a) Show that this profile...
-
San Jose Services was formed on May 1, 2012. The following transactions took place during the first month. Transactions on May 1: 1. Jarron Gilbert invested $40,000 cash in the company, as its sole...
-
Crane Zone Corporation experienced the following variances: materials price $270 U, materials quantity $1,290 F, labor price $610 F, labor quantity $380 F, and total overhead $910 U. Sales revenue...
-
Donnie, Inc. ("DI") requires multiple departments and areas in order to make a single product. On August 1, DI had 10,000 units in beginning inventory that were 80% complete with respect to materials...
-
Explain the general evolution in accounting methods that have occurred from manual to digital processes over the last 40 to 50 years. Discuss the pros and cons of past and current accounting methods....
-
Compare and contrast Ideation Theory and Communication for Persuasion Theory.Highlight the key elements, strengths, and limitations of each theory, and provide an example of how each theory has been...
-
Based on this PDF "RBC Canadian Equity Fund", help me find 10 reasons why this would be a good fund to invest in and why. Here is the link to the PDF:...
-
Karey bought a small shopping mall 10 years ago for a total price of $2 million. Karey chose to use straight-line depreciation and deducted $423,000 before the mall was sold for $2.5 million on...
-
Briefly explain one internal hedging technique that financial institution may use to manage interest rate risk. Why might it be impossible to eliminate the risk completely? Define each of the...
-
Share an example of an instance where you or a leader you followed took a calculated risk. bring in leadership theory as it relates to your example. explain why you or your leader decided to take the...
-
In the circuit shown in Figure 4, a battery supplies a constant voltage of 40 V, the inductance is 2 H, the resistance is 10, and l(0) = 0. (a) Find l(t). (b) Find the current after 0.1s.
-
What risk factors should a team consider when deciding whether to build and fund a new venue? How are the risk factors different if a municipality is funding the construction?
-
Among NCAA mens basketball teams, which team would you expect to have the highest value? Why? How do you think conference affiliation affects value among these teams?
-
What must players and agents understand about risk? How should an agent structure a players contract if it contains deferred compensation?
Study smarter with the SolutionInn App