This Database require to provide this following information.

1. Employee information (e.g., employee name, address, phone number, hiring date, salary, etc.).
2. Information about the books and CDs in the bookstore (e.g., title, author, price, etc.).
3. Sales of CDs and books, searchable by date
4. Current inventory status of books and CDs

The following items will be assessed in particular:

1. Attributes in each table are marked clearly.
2. Primary key and foreign keys of the tables are identified.
3. Using an ER diagram to demonstrate relationship among the tables.

Employee

Employee id	Employee Name	address	phone number	hiring date	salary

Inventory

title	author	selling price	cost price	cost as percent of price	product id	Current Inventory	monthly purchase

Sales

Trans id	Product id	date	customer id	units sold	Cashier	P.O Number	Trans code