OWNED PROPERTY must exist in OWNER Owner to Owned Property: There is a one-to-many relationship between the owner and the owned property. Although one owner may possess several properties, only one owner is allowed to own any one property. Accordingly, OWNER has a maximum cardinality of many (each owner can own numerous properties), and OWNED PROPERTY has a minimum cardinality of one (each property must have an owner). PROPERTY SERVICE must exist in OWNED PROPERTY PROPERTY_SERVICE must exist in 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 employee be there in order for the services to be completed. The relationship from PROPERTY SERVICE to EMPLOYEE is one-mandatory. This is because one property service is completed by one employee (by nature of Property ServiceID), and it is mandatory because a property service must have an employee in order to be completed. 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, CostPerHour); 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 Own OPERTY ServiceID in GG SER
OWNED PROPERTY must exist in OWNER Owner to Owned Property: There is a one-to-many relationship between the owner and the owned property. Although one owner may possess several properties, only one owner is allowed to own any one property. Accordingly, OWNER has a maximum cardinality of many (each owner can own numerous properties), and OWNED PROPERTY has a minimum cardinality of one (each property must have an owner). PROPERTY SERVICE must exist in OWNED PROPERTY PROPERTY_SERVICE must exist in 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 employee be there in order for the services to be completed. The relationship from PROPERTY SERVICE to EMPLOYEE is one-mandatory. This is because one property service is completed by one employee (by nature of Property ServiceID), and it is mandatory because a property service must have an employee in order to be completed. 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, CostPerHour); 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 Own OPERTY ServiceID in GG SER
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
Related questions
Question
What are the answers for these blank two:
1. Property_service must exist in Owned_Property
2. Property_service must exist in Service
?
Transcribed Image Text:OWNED PROPERTY must exist in OWNER
Owner to Owned Property: There is a one-to-many relationship between the owner and the
owned property. Although one owner may possess several properties, only one owner is allowed
to own any one property. Accordingly, OWNER has a maximum cardinality of many (each
owner can own numerous properties), and OWNED PROPERTY has a minimum cardinality of
one (each property must have an owner).
PROPERTY SERVICE must exist in OWNED PROPERTY
PROPERTY_SERVICE must exist in 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
employee be there in order for the services to be completed.
The relationship from PROPERTY SERVICE to EMPLOYEE is one-mandatory. This is because
one property service is completed by one employee (by nature of Property ServiceID), and it is
mandatory because a property service must have an employee in order to be completed.
Transcribed Image Text: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, CostPerHour);
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 Own
OPERTY ServiceID in GG SER
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON