Description
Perform the logical design for the ERD provided as key to project 1
For each table,
- all attributes are listed first, in alphabetical order
- Then the PK (primary key). If a PK consists of several attributes, list them.
- Then the foreign keys. If a foreign key consists of several attributes, it is one FK.
Make sure that you indicate the table being referenced by each FK, and the reason there is a FK (relationship—which one, or hierarchy).
Remember that all attributes of a table must have different names. A foreign key is not required to have the same name as the PK it references.
2. (1/10) Merge the tables Reg_MEMBER and VIP into table MEMBER, minimizing the loss of information. Show only the tables that are modified. Indicate which information is lost.
This project does not make use of SQL
The final output should look like attach #
Explanation & Answer
Attached.
1. Entity to table
Room
P.K
Customer
Room_number
int
Size
int
P.K
Speciality
P.K
speciality_name
custID
int
name
int
birthdate
date
gender
string
string
Loan
Painting
P.K
Painting_name
string
Estimated_value
int
Acquired_year
int
Completed_year
int
P.K
Museum_name
string
P.K
Painting_name
int
Return_date
date
Associate_Muse...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Glass Castle
by Jeannette Walls
Uncle Tom's Cabin
by Harriet Beecher Stowe
Heart of Darkness
by Joseph Conrad
Frankenstein
by Mary Shelley
The Metamorphosis
by Franz Kafka
The Remains Of The Day
by Kazuo Ishiguro
The Mayor of Casterbridge
by Thomas Hardy
The Lord of the Flies
by William Golding
Big Magic
by Elizabeth Gilbert