Question: Create a database called Store with the following tables: Employees table: 3-5 people working in the virtual store, each person is represented by a table
Create a database called Store with the following tables:
- Employees table: 3-5 people working in the virtual store, each person is represented by a table row. The table should include employee ID, last and first name, title, phone number.
- Products" table that contains information about at least 10 products sold by the store. Each record in the table should include: (1) a "ProductID," (2) the name of the product, (3) the retail price of a unit of the product, (4) the number of units of the product in stock, and (5) the product picture image. Assume that the only unique identifier of a product is its "ProductID."
- an "Orders" table that includes information about at least 8 orders of products. It should include: (1) an "OrderID," (2) a "ProductID," (3) the wholesale price of a unit of the product ordered, (4) the number of units of the product ordered, (5) the date that the product was ordered, (6) CustomerID, (7) Employee responsible for that order.
- Customers table: 5-10 people buying in the virtual store, each person is represented by a table row. The table should include customer ID, last and first name, address, phone number, credit card ID (CCID).
- A Credit Card table containing the following: credit card ID (CCID), credit card type (Visa, Master Card, etc), the owner first and last names, amount of credit available, balance amount.
- A Transaction table with the following: transaction ID (TrID), amount of money spent, the date of the transaction, credit card it is attached to.
- The following conditions should be met:
- Each employee can process many orders, but each order can be processed by only one employee.
- Each order can have many products, and each product can belong to many orders.
- Each customer can have many orders, but each order belongs to only one customer.
- Each customer can have many credit cards, but each card belongs to only one customer.
- Each credit card can have many transactions done on it, but every transaction is linked to only one credit card.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
