Logical Programming Design for the ERD Project Table

User Generated

ubaqn3019

Programming

Description

Perform the logical design for the ERD provided as key to project 1

For each table,

  1. all attributes are listed first, in alphabetical order
  2. Then the PK (primary key). If a PK consists of several attributes, list them.
  3. 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 #

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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...


Anonymous
Super useful! Studypool never disappoints.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags