OWNED PROPERTY PK PropertyID PropertyName PropertyType Street City State Zip FK OwnerID # OWNER REPAIRS PK OwnerID OwnerName OwnerEmailAddress Owner Type PK RepairlD FK EquipmentID RepairDate Invoice PROPERTY_SERVICE PropertyServiceID FK PropertyID ServiceID ServiceDate FK EmployeeID HoursWorked GG_SERVICE PK ServicelD ServiceDescription CostPerHour FK EquipmentID EQUIPMENT PK EquipmentID EquipmentType Manufactorer Cost EMPLOYEE PK EmployeelD LastName FirstName CellPhone ExpierenceLevel FK TrainingLevel TRAINING PurchaseDate PK TrainingID FK EquipmentID FK EmployeelD CourseDescription Duration DateOfTraining Instructor Venue TrainingLevel 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
OWNED PROPERTY PK PropertyID PropertyName PropertyType Street City State Zip FK OwnerID # OWNER REPAIRS PK OwnerID OwnerName OwnerEmailAddress Owner Type PK RepairlD FK EquipmentID RepairDate Invoice PROPERTY_SERVICE PropertyServiceID FK PropertyID ServiceID ServiceDate FK EmployeeID HoursWorked GG_SERVICE PK ServicelD ServiceDescription CostPerHour FK EquipmentID EQUIPMENT PK EquipmentID EquipmentType Manufactorer Cost EMPLOYEE PK EmployeelD LastName FirstName CellPhone ExpierenceLevel FK TrainingLevel TRAINING PurchaseDate PK TrainingID FK EquipmentID FK EmployeelD CourseDescription Duration DateOfTraining Instructor Venue TrainingLevel 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
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
Related questions
Question
What is the relationship below (eg. many optional, many mandatory…etc) give a detailed explanation:
1. Training to Equipment
2. Equipment to Training
Transcribed Image Text:OWNED PROPERTY
PK PropertyID
PropertyName
PropertyType
Street
City
State
Zip
FK OwnerID
#
OWNER
REPAIRS
PK OwnerID
OwnerName
OwnerEmailAddress
Owner Type
PK RepairlD
FK EquipmentID
RepairDate
Invoice
PROPERTY_SERVICE
PropertyServiceID
FK PropertyID
ServiceID
ServiceDate
FK EmployeeID
HoursWorked
GG_SERVICE
PK ServicelD
ServiceDescription
CostPerHour
FK EquipmentID
EQUIPMENT
PK EquipmentID
EquipmentType
Manufactorer
Cost
EMPLOYEE
PK EmployeelD
LastName
FirstName
CellPhone
ExpierenceLevel
FK TrainingLevel
TRAINING
PurchaseDate
PK TrainingID
FK EquipmentID
FK EmployeelD
CourseDescription
Duration
DateOfTraining
Instructor
Venue
TrainingLevel
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
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