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, 03.07.2019 14:10
Line joining liquid phase with liquid and solid phase mixture is known as: a) liquidus b) solidus c) tie line d) none of the mentioned
Answers: 2
question
Engineering, 04.07.2019 18:10
Different types of steels contain different elements that alter the characteristics of the steel. for each of the following elements, explain what the element does when alloyed with steel.
Answers: 2
question
Engineering, 04.07.2019 18:10
Courses that are developed by subject matter experts, internal or extemal to the college or university. these programs are marketed by the school (clo2) marks a)-vocational schools b)-vendor training c)-colleges & universities d)-continuing education programs
Answers: 2
question
Engineering, 04.07.2019 19:20
Apiping systems consists of 6 m of 6-std type k and 12 m of 4-std type k, both drawn copper tubing. the system conveys ethylene glycol at a rate of 0.013 m3/s. the pressure drop across the system is to be calculated. there are two 90° elbows in the 6-in pipe, a reduction from the 6-in pipe to the 4-in pipe and four 90° elbows in the 4-in pipe. all fittings are soldered (same as flanged) and regular. the inlet and outlet of the system are at the same height.
Answers: 1
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, 18.08.2020 05:01
question
Social Studies, 18.08.2020 05:01
Questions on the website: 13722363