Create a sample database design for a library and draw one database model for it. The...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a sample database design for a library and draw one database model for it. The library wants to keep track of books (regular books/electronic/audio); book authors; book genres; book location (area/shelves); customer information; books that the customers borrowed, when they are due, employee that checked them out; employee information; and employee working schedules. 1. [3] Design the database that makes sense for the problem and select fields that make the most sense. A complete screenshot of your final design model is required. 2. [10] Determine the tables, columns, primary keys, nullabilities and show relationships between tables (one -one/one-many/many-many). 3. [5] Normalize your design into 3rd Normal Form. Please use MS Visio or any similar database design tool. 4. [2] Explain your design, including relationship between tables. Create a sample database design for a library and draw one database model for it. The library wants to keep track of books (regular books/electronic/audio); book authors; book genres; book location (area/shelves); customer information; books that the customers borrowed, when they are due, employee that checked them out; employee information; and employee working schedules. 1. [3] Design the database that makes sense for the problem and select fields that make the most sense. A complete screenshot of your final design model is required. 2. [10] Determine the tables, columns, primary keys, nullabilities and show relationships between tables (one -one/one-many/many-many). 3. [5] Normalize your design into 3rd Normal Form. Please use MS Visio or any similar database design tool. 4. [2] Explain your design, including relationship between tables.
Expert Answer:
Answer rating: 100% (QA)
1 Here is a excessivelevel design evaluate of the library database Tables Books which includes norma... View the full answer
Related Book For
Fundamentals Of Database Systems
ISBN: 9780133970777
7th Edition
Authors: Ramez Elmasri, Shamkant Navathe
Posted Date:
Students also viewed these programming questions
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
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...
-
The current Occupational Safety and Health Administration (OSHA) ceiling limit for H 2 S is up to 20 ppm for general industry. If the H 2 S meter reads 35 mg/m 3 , is this level above or below the...
-
Using the transactions in CP5-1, complete the following table by indicating the sign of the effect (+ for increase, - for decrease, NE for no effect, and CD for cannot determine) of each transaction....
-
Choose the best answer. The distance traveled by a home run ball in a major league baseball stadium is about how far? (a) 120 hm (b)120 km (c)120 m
-
Abbott Industries is a well-known supplier of pharmaceuticals worldwide. Founded by Dr. Wallace Abbott, the company was incorporated in 1900 after he had been developing and making pharmaceuticals...
-
The controller of Santa Fe Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to...
-
8. Suppose f(x) = x 2. Use the forward difference method with h = 0.1 to approximate f'(1).
-
Consider a stagnant, conical pipe containing "species A" with the concentration profile CA(z) = 5-0.05z2 (mol/cm3). At z = 0, the radius of the pipe 1 cm and at z = 1 cm. the radius of the pipe is 3...
-
Bernadette Rosen, a longtime client of yours, is an architect and the president of the local Rotary chapter. To keep up to date with the latest developments in her profession, she attends continuing...
-
Investment companies attempt to explain to investors the nature of the risk the investor incurs when buying shares in their mutual funds. For example, go to https://personal.vanguard.com/us/funds/...
-
Eighth Wonder & Co is engaged in cosmetics business. The trial balance and additional information as on 31st March 2017 are given below. You are required to prepare the profit and loss account for...
-
Mr. Smart Lal commenced his trading business in the name of Exotica Trading Company on 1st April 2017 with a capital of 1,000,000 and a loan from the State Bank of India amounting to 500,000. At...
-
Show a pipeline execution diagram for the third iteration of this loop, from the cycle in which we fetch the first instruction of that iteration up to (but not including) the cycle in which we can...
-
Part 1 As EEC's corporate business financial analyst, you will need to have a clear understanding of the different types of costs (variable, fixed, and mixed) that the company carries. Complete the...
-
Write a paper about how diet relates to breast cancer in women study design to use: case control study purpose & rationale the purpose of this final project is to utilize the methods and...
-
In SQL, specify the following queries on the database in Figure 5.5 using the concept of nested queries and other concepts described in this chapter. a. Retrieve the names of all employees who work...
-
What are the different types of SQL injection attacks?
-
Repeat Exercise 10.7, but write a function in SQL/PSM. Exercise 10.7 Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. Write a program segment to read a students name...
-
Select the statement that best describes organizational versus organized crime: 1. Organizational and organized crime are essentially the sameboth center on crimes committed by organizations. 2. Some...
-
Three people check into a hotel. They pay $30 to the manager and go to their room. The manager suddenly remembers that the room rate is $25 and gives $5 to the bellboy to return to the people. On the...
-
A scientist has two bucketsone holds 4 gallons and the other holds 5 gallonsas well as an unlimited water supply. By using nothing but the buckets and water, how can you accurately measure 3 gallons...
Study smarter with the SolutionInn App