Entity Relationship Diagram docx

Running head: DATABASE MANAGEMENT
Database Management
Name of the Student:
Name of the University:
Author Note

1
DATABASE MANAGEMENT
Part A: Entity Relationship Diagram
The main entities and attributes identified in the system are:
Department (DeptID, DeptName)
Products (ProductNumber, ProductTitle, UnitPrice)
Stores (StoreID, Name, Address, FaxNumber)
Employees (EmployeeID, LastName, FirstName StoreID, DeptID)
Patrons (CustomerID, LastName, FirstName, PhoneNumber, Address)
Orders (OrderNumber, OrderDate, NumberOfProducts, CustomerID, EmployeeID)
ProductsOrdered (ID, ProductNumber, OrderNumber, QunatityOrdered)

2
DATABASE MANAGEMENT
Part B: Normalization
The normalized schema for the database has been provided below:
Department (DeptID (pk), DeptName)
Products (ProductNumber (pk), ProductTitle, UnitPrice)
Stores (StoreID (pk), Name, Address, FaxNumber)
Employees (EmployeeID (pk), LastName, FirstName StoreID (fk), DeptID (fk))
Patrons (CustomerID (pk), LastName, FirstName, PhoneNumber, Address)
Orders (OrderNumber (pk), OrderDate, NumberOfProducts, CustomerID (fk), EmployeeID (fk))
ProductsOrdered (ID (pk), ProductNumber (fk), OrderNumber (fk), QunatityOrdered)

3
DATABASE MANAGEMENT
Part C: Relational schema and MySQL database
Department
Attribute Datatype Size Key
DeptID Int Primary
DeptName Varchar 30
Products
Attribute Datatype Size Key
ProductNumber Int Primary
ProductTitle Varchar 30
UnitPrice Int
Stores