PetStore Normalization

Sale(SaleID, Date, CustomerID, EmployeeID)

SaleAnimal(SaleID, AnimalID, SalePrice)

SaleMerchandise(SaleID, ItemID, SalePrice, Quantity)

Customer(CustomerID, Name, Address, City, State, Zip)

Employee(EmployeeID, Name)

Animal(AnimalID, Name, Category, Breed, DateOfBirth,

Gender, Registration, Color, ListPrice)

Merchandise(ItemID, Description, Category, ListPrice)

AnimalOrder(OrderID, OrderDate, ReceiveDate, SupplierID, EmpID, ShipCost)

AnimalOrderItem(OrderID, AnimalID, Cost)

Supplier(SupplierID, Name, Contact, Phone, Address, City, State, Zip)

Employee(EmployeeID, Name, Phone, DateHired)

Animal(AnimalID, Name, Category, Breed, Gender, Registration, Cost)

MerchandiseOrder(PONumber, OrderDate, ReceiveDate, SID, EmpID, ShipCost)

MerchandiseOrderItem(PONumber, ItemID, Quantity, Cost)

Supplier(SupplierID, Name, Contact, Phone, Address, City, State, Zip)

Employee(EmployeeID, Name, Phone)

Merchandise(ItemID, Description, Category, QuantityOnHand)

前一張投影片

下一張投影片

回到第一張投影片

檢視圖形版本