GARDEN GLORY PROJECT QUESTIONS Book: Database Concepts (7 th Edition) eISBN: 013

Question

GARDEN GLORY PROJECT QUESTIONS

Book: Database Concepts (7th Edition) eISBN: 0133777847

Chapter # 5 Page 330

Convert the data model you constructed for Garden Glory in Part B at the end of Chapter 4 (or an equivalent data model that your instructor provides for you to use) into a relational database design for Garden Glory. Document your database design as follows.

Specify tables, primary keys, and foreign keys, Using Figures 5-26 and 5-28 as guides, specify column properties.

Part B from Chapter 4:

Explanation / Answer

Tables:

Owner(Owner_Id, Owner_name,email,Owner_type)

Primary key: Owner_Id

Employee(E_ID, FirstName, LastName, ExpLevel, phone)

Primary key: E_ID

Services(Prop_id,Owner_Id,E_ID,Date_Of_Service, Workin_hours)

Primary key: It is a composite primary key (Combination of Prop_id,Owner_Id, E_ID)

Property(Prop_id, Prop_name, Street, City, Zipcode)

Primary key: Prop_id

Related Questions

Navigate

• Browse (All)
• Browse G
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.