Question: Based on the following DBDL , what is an attribute, but not a key, of the Inspection table? OWNER ( OwnerID , Name, Address, City,
Based on the following DBDL what is an attribute, but not a key, of the Inspection table?
OWNEROwnerID Name, Address, City, State, Zip, Phone, Email
RESTAURANTRestaurantID RestaurantName, Address, City, State, Zip, Phone, DateOpened, OwnerID
OwnerID foreign key to OWNER
INSPECTOREmployeelD FirstName, LastName, DateHired, OfficePhone, MobilePhone
INSPECTIONInspectionID DateTimeStarted, RestaurantID, EmployeeID
RestaurantID foreign key to RESTAURANT
EmployeelD foreign key to INSPECTOR
DateTimeStarted
EmployeelD
InspectionID
RestaurantID
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
