subject
Engineering, 15.11.2019 02:31 Petlover6975

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. use ms visio or any similar database design tool. 4. 12] explain your design, including relationship between tables.

ansver
Answers: 3

Another question on Engineering

question
Engineering, 04.07.2019 18:10
Refrigerant 134a enters an insulated compressor operating at steady state as saturated vapor at -26°c with a volumetric flow rate of 0.18 m3/s. refrigerant exits at 9 bar, 70°c. changes in kinetic and potential energy from inlet to exit can be ignored. determine the volumetric flow rate at the exit, in m3/s, and the compressor power, in kw.
Answers: 1
question
Engineering, 04.07.2019 18:10
Draw the engineering stress-strain curve for (a) bcc; (b) fcc metals and mark important points.
Answers: 1
question
Engineering, 04.07.2019 18:10
Slip occurs via two partial dislocations because of (a) the shorter path of the partial dislocation lines; (b) the lower energy state through partial dislocations; (c) the charge balance.
Answers: 1
question
Engineering, 04.07.2019 18:10
Which of the following components of a pid controlled accumulates the error over time and responds to system error after the error has been accumulated? a)- proportional b)- derivative c)- integral d)- on/off.
Answers: 2
You know the right answer?
Create a sample database design for a library and draw one database model for it. the library wants...
Questions
question
Mathematics, 30.11.2020 06:00
question
Chemistry, 30.11.2020 06:00