DIAGRAM

Functional Dependencies

User Table

Customer Table

Employee Table

Order Table

UserID, DateOrdered, and ItemID were used as primary key because they can uniquely identify each order.

Shipping Hub

Item

Game

Movie

Rating

UserID and ItemID were chosen as primary key because they can uniquely identify each Rating

Reservation

UserID and ItemID were used as the primary key Because they uniquely identify each Reservation.

  1. 3.Changes From Previous

    No changes were made from the previous model