Homework Help is Here – Start Your Trial Now!
Business
Management
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

Understanding Business
Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
See similar textbooks
icon
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
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: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
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 2 steps

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
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…
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)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON
SEE MORE TEXTBOOKS