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