create a cheese company data model excel spreadsheet
- User
create a cheese company data model excel spreadsheet
- Assistant
As an AI language model, I am unable to create an excel spreadsheet. However, I can provide you with the data model for a cheese company.
Cheese Company Data Model
Customer
- CustomerID (Primary Key)
- FirstName
- LastName
- Phone
- Address
Product
- ProductID (Primary Key)
- Name
- Description
- Price
- Stock
Order
- OrderID (Primary Key)
- CustomerID (Foreign Key)
- OrderDate
- TotalPrice
OrderDetails
- OrderDetailsID (Primary Key)
- OrderID (Foreign Key)
- ProductID (Foreign Key)
- Quantity
- PricePerUnit
Supplier
- SupplierID (Primary Key)
- Name
- Phone
- Address
ProductSupplier
- PSID (Primary Key)
- ProductID (Foreign Key)
- SupplierID (Foreign Key)
- PricePerUnit
The cheese company data model includes four tables: Customer, Product, Order, and Supplier. The Customer table stores information about the company's customers, including their names, contact details, and addresses. The Product table stores information about the available products, such as the name, description, price, and stock.
The Order table tracks all orders made by the customers, including the order ID, customer ID, order date, and total price. In addition, the OrderDetails table stores information about the products included in each order, such as the product ID, quantity, and price per unit.
Lastly, the Supplier table stores information about the company's suppliers, including their names, contact details, and addresses. The ProductSupplier table links the products to their corresponding suppliers, including the product ID, supplier ID, and price per unit.