Welcome to the Future Foods website

Entities and Attributes

Entities

• Customer
• Employee
• Order
• Product
• Restaurant

Attributes

Customer
• UserID (key)
• Name (composite)
  • First Name
  • Last Name
• Email
• Address (composite)
• Street
• City
• Province
• Postal Code
• Phone Number

Employee
• EmployeeID (key)
• Name (composite)
  • First Name
  • Last Name
• Age (derived)
• Date of Birth
• Email
• Phone Number
• Address (composite)
• Street
• City
• Province
• Postal Code
• Phone Number

Order
• OrderID(key)
• Time of Order
• Date of Order
• Price

Product
• ProductID (key)
• Product Name
• Description

Restaurant
• Restaurant ID (key)
• Restaurant Name
• Email
• Phone Number
• Address (composite)
• Street
• City
• Province
• Postal Code