Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Design a new database, with different tables, where all the tablesfulfill BCNF without losing any information. A table called CUSTOMER, which contains data about the
Design a new database, with different tables, where all the tablesfulfill BCNF without losing any information. A table called CUSTOMER, which contains data about the persons who can borrow books. It has the attributes CustomerNr (a unique number identifying a person, assigned by the library), PersonNr (which is a unique number identifying a person, assigned by the Swedish state), Name, Address, Tel, and NrBooks (the number of books that this person has borrowed at the moment).CustomerNr is the primary key. PersonNr is an alternative key
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started