Acct 2950 Ch 2 In-Class Quizziz

OrderNumber in the TakeOrder table

• Primary key

• Foreign key

• Neither

EmployeeID in the TakeOrder table

• Primary key

• Foreign key

• Neither

CustomerID in the Customers table

• Primary key

• Foreign key

• Neither

EmployeeID in the Employees table

• Primary key

• Foreign key

• Neither

Date in the TakeOrder table

• Primary key

• Foreign key

• Neither

ZipCode in the Employees table

• Primary key

• Foreign key

• Neither

Restaurant table: Primary key

• RestaurantNumber

• RestaurantName

• State

• Zip

• None

Restaurant table: Foreign key(s)

• OrderNumber

• RestaurantName

• RestaurantNumber

• CustomerID

• City

Order table: Primary key

• OrderNumber

• RestaurantNumber

• OrderDate

• CustomerID

• None

Order table: Foreign key(s)

• OrderNumber

• RestaurantNumber

• OrderDate

• CustomerID

• None