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:

  1. 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.
  2. 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."
  3. 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.
  4. 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).
  5. 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.
  6. A Transaction table with the following: transaction ID (TrID), amount of money spent, the date of the transaction, credit card it is attached to.
  7. The following conditions should be met:
    1. Each employee can process many orders, but each order can be processed by only one employee.
    2. Each order can have many products, and each product can belong to many orders.
    3. Each customer can have many orders, but each order belongs to only one customer.
    4. Each customer can have many credit cards, but each card belongs to only one customer.
    5. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!