Group Assignment 1

Tables (10)

Booth (B)

  • BoothID (Key) — Primary key — NOT NULL
  • EventID (Key2) — Foreign key → Event.EventID — NOT NULL
  • Section (Field)
  • Field4

Brand (BR)

  • BrandID (Key) — Primary key — NOT NULL
  • SourecID (Key2) — Foreign key → Source.SourecID — NOT NULL
  • BrandName (Field)

Calender (C)

  • DateTime (Key) — Primary key — NOT NULL
  • Year (Field)
  • Month (Field2)
  • Day (Field3)
  • DayofWeek (Field4)
  • Date (Field5)
  • Field6
  • Field7

Employee (EE)

  • EmployeeID (Key) — Primary key — NOT NULL
  • FirstName (Field)
  • LastName (Field2)
  • Address (Field3)
  • Phone (Field4)
  • Field5
  • Field6

Event (E)

  • EventID (Key) — Primary key — NOT NULL
  • VenueID (Key2) — Foreign key → Venue.VenueID — NOT NULL
  • EventName (Field)
  • Description (Field2)
  • EventType (Field3)
  • StartDate (Field4)
  • EndDate (Field5)
  • VenueID (Field6)

Product (P)

  • ProductID (Key) — Primary key — NOT NULL
  • BrandID (Key2) — Foreign key → Brand.BrandID — NOT NULL
  • SourecID (Key22) — Foreign key → Brand.SourecID — NOT NULL
  • ProductName (Field)
  • WholesaleCost (Field4)
  • MinimumPrice (Field5)

Shift (S)

  • EmployeeID (Key) — Primary key — NOT NULL
  • BoothID (Key2) — Primary key — NOT NULL
  • Date (Key3) — Primary key — NOT NULL
  • Date (Field)
  • EventID (Field2)
  • Field3
  • Field4
  • Field5
  • Field6

Source (CopyOfBR)

  • SourecID (Key) — Primary key — NOT NULL
  • Name (Field)
  • Location (Field2)

Transaction(Sales) (T)

  • TransID (Key) — Primary key — NOT NULL
  • BoothID (Key5) — Foreign key → Booth.BoothID — NOT NULL
  • ProductID (Key2) — Foreign key → Product.ProductID — NOT NULL
  • DateTime (Key3) — Foreign key → Calender.DateTime — NOT NULL
  • EmployeeID (Key4) — Foreign key → Employee.EmployeeID — NOT NULL
  • EventID (Key22) — Foreign key → Booth.EventID — NOT NULL
  • BrandID (Key23) — Foreign key → Product.BrandID — NOT NULL
  • SourecID (Key222) — Foreign key → Product.SourecID — NOT NULL
  • StartingPrice (Field4)
  • FinalPrice (Field5)
  • Quantity (Field6)
  • DateTime (Field7)
  • Field

Venue (V)

  • VenueID (Key) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6