redcat-denormalized

Database Diagram for Redcat Shoes (introductory)

Customer Customer.CustomerID Customer.FirstName Customer.LastName Customer.StreetAddress Customer.City Customer.State Customer.PostalCode Customer.Country Customer.Phone Sale Sale.SaleID Sale.SaleDate Sale.CustomerID Sale.ProductID Sale.ItemSize Sale.Quantity Sale.SalePrice Product Product.ProductID Product.ProductName Product.ManufacturerID Product.Category Product.Color Product.Price Product.Description Product. Product. Product. Product. Product. Product. Product. Product.Ñ Manufacturer Manufacturer.ManufacturerID Manufacturer.ManufacturerName Manufacturer.Address Manufacturer.City Manufacturer.State Manufacturer.PostalCode Manufacturer.Phone Customer JOIN Sale ON Customer.CustomerID = Sale.CustomerID Sale JOIN Product ON Sale.ProductID = Product.ProductID Product JOIN Manufacturer ON Product.ManufacturerID = Manufacturer.ManufacturerID