Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
text 4 Times... 1 12 + B I U A © 2 3 + 4 5 t = ▾ PROPERTY SERVICE must exist in SERVICE GG SERVICE to PROPERTY SERVICE: This relationship indicates that every Property Service should match a service listed in the company's GG SERVICE table. A single service can link to numerous property services, yet each property service is dedicated to a single service type, the relationship's cardinality is one-to-many. The GG SERVICE table presumably catalogs the various services Garden Glory offers, and each entry in the Property Service must be tied to one of these service types, establishing a one-to-many relationship between Property Service and Service. PROPERTY SERVICE to GG SERVICE: PROPERTY SERVICE must exist in EMPLOYEE

text 4 Times... 1 12 + B I U A © 2 3 + 4 5 t = ▾ PROPERTY SERVICE must exist in SERVICE GG SERVICE to PROPERTY SERVICE: This relationship indicates that every Property Service should match a service listed in the company's GG SERVICE table. A single service can link to numerous property services, yet each property service is dedicated to a single service type, the relationship's cardinality is one-to-many. The GG SERVICE table presumably catalogs the various services Garden Glory offers, and each entry in the Property Service must be tied to one of these service types, establishing a one-to-many relationship between Property Service and Service. PROPERTY SERVICE to GG SERVICE: PROPERTY SERVICE must exist in EMPLOYEE

A Guide to SQL
A Guide to SQL
9th Edition
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Philip J. Pratt
Chapter2: Database Design Fundamentals
Section: Chapter Questions
Problem 11RQ
See similar textbooks
icon
Related questions
Question
What is the cardinality of Property_Service to GG_Service:
text Times... 1 I 1 12 + BIUA 2 3 O + 4 5 PROPERTY_SERVICE must exist in SERVICE GG SERVICE to PROPERTY SERVICE: This relationship indicates that every Property Service should match a service listed in the company's GG SERVICE table. A single service can link to numerous property services, yet each property service is dedicated to a single service type, the relationship's cardinality is one-to-many. The GG SERVICE table presumably catalogs the various services Garden Glory offers, and each entry in the Property Service must be tied to one of these service types, establishing a one-to-many relationship between Property Service and Service. PROPERTY SERVICE to GG SERVICE: PROPERTY SERVICE must exist in EMPLOYEE The relationship from EMPLOYEE to PROPERTY_SERVICE is many-mandatory. This is because the same employee can perform multiple property services, and it is mandatory that the
Transcribed Image Text:text Times... 1 I 1 12 + BIUA 2 3 O + 4 5 PROPERTY_SERVICE must exist in SERVICE GG SERVICE to PROPERTY SERVICE: This relationship indicates that every Property Service should match a service listed in the company's GG SERVICE table. A single service can link to numerous property services, yet each property service is dedicated to a single service type, the relationship's cardinality is one-to-many. The GG SERVICE table presumably catalogs the various services Garden Glory offers, and each entry in the Property Service must be tied to one of these service types, establishing a one-to-many relationship between Property Service and Service. PROPERTY SERVICE to GG SERVICE: PROPERTY SERVICE must exist in EMPLOYEE The relationship from EMPLOYEE to PROPERTY_SERVICE is many-mandatory. This is because the same employee can perform multiple property services, and it is mandatory that the
QUESTIONS Assume that Garden Glory designs a database with the following tables: OWNER (OwnerID, OwnerName, OwnerEmailAddress, Owner Type) OWNED PROPERTY (PropertyID, PropertyName, Property Type, Street, City, State, Zip, OwnerID) GG SERVICE (ServiceID, ServiceDescription, Cost PerHour); EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel) PROPERTY SERVICE (PropertyServiceID, PropertyID, ServiceID, ServiceDate, EmployeeID, Hours Worked) The referential integrity constraints are: OwnerID in OWNED PROPERTY must exist in OwnerID in OWNER PropertyID in PROPERTY SERVICE must exist in PropertyID in OWNED_ PROPERTY ServiceID in PROPERTY_SERVICE must exist in ServiceID in GG_SERVICE EmployeeID in PROPERTY_SERVICE must exist in EmployeeID in EMPLOYEE Assume that OwnerID in OWNER, PropertyID in PROPERTY, ServiceID in GG_SER- VICE, EmployeeID in EMPLOYEE, and PropertyServiceID in PROPERTY_SERVICE are surrogate keys with values as follows: OwnerID Start at 1 Increment by 1 PropertyID Start at 1 Increment by 1 ServiceID Start at 1 Increment by 1 EmployeeID Start at 1 Increment by 1 PropertyServiceID Start at 1 Increment by 1
Transcribed Image Text:QUESTIONS Assume that Garden Glory designs a database with the following tables: OWNER (OwnerID, OwnerName, OwnerEmailAddress, Owner Type) OWNED PROPERTY (PropertyID, PropertyName, Property Type, Street, City, State, Zip, OwnerID) GG SERVICE (ServiceID, ServiceDescription, Cost PerHour); EMPLOYEE (EmployeeID, LastName, FirstName, CellPhone, ExperienceLevel) PROPERTY SERVICE (PropertyServiceID, PropertyID, ServiceID, ServiceDate, EmployeeID, Hours Worked) The referential integrity constraints are: OwnerID in OWNED PROPERTY must exist in OwnerID in OWNER PropertyID in PROPERTY SERVICE must exist in PropertyID in OWNED_ PROPERTY ServiceID in PROPERTY_SERVICE must exist in ServiceID in GG_SERVICE EmployeeID in PROPERTY_SERVICE must exist in EmployeeID in EMPLOYEE Assume that OwnerID in OWNER, PropertyID in PROPERTY, ServiceID in GG_SER- VICE, EmployeeID in EMPLOYEE, and PropertyServiceID in PROPERTY_SERVICE are surrogate keys with values as follows: OwnerID Start at 1 Increment by 1 PropertyID Start at 1 Increment by 1 ServiceID Start at 1 Increment by 1 EmployeeID Start at 1 Increment by 1 PropertyServiceID Start at 1 Increment by 1
Expert Solution
steps

Step by step

Solved in 4 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Knowledge Booster
SQL Query
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
A Guide to SQL
A Guide to SQL
Computer Science
ISBN:
9781111527273
Author:
Philip J. Pratt
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Oracle 12c: SQL
Oracle 12c: SQL
Computer Science
ISBN:
9781305251038
Author:
Joan Casteel
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
SEE MORE TEXTBOOKS