MICRSOFT ACCESS DATABASE Microsoft Access Database.

Running head: MICRSOFT ACCESS DATABASE
Microsoft Access Database
Name of the Student:
Name of the University:
Author Note

1
MICRSOFT ACCESS DATABASE
ER Diagram
ERD to 3NF relationship
Functional Dependency
CentreID -> Type, Address
EmployeeID -> EmployeeName, CentreID
CustomerId -> CustomerName
ItemNumber -> Weight, Dimensions, insuranceAmount, Destintion, DeliveryDate,
CustomerID
ScheduleNumber -> ItemNumber, TransportationMode, DeliveryRoute

2
MICRSOFT ACCESS DATABASE
RecieptID -> ItemNumber, EmployeeID, ReceivedDate
Relational Schema
Centre (CentreID (pk), Type, Address)
Employee (EmployeeID (pk), EmployeeName, CentreID (fk))
Customer (CustomerId (pk), CustomerName)
Items (ItemNumber (pk), Weight, Dimensions, insuranceAmount, Destintion, DeliveryDate,
CustomerID (fk))
Tarnsportation (ScheduleNumber (pk), ItemNumber (fk), TransportationMode,
DeliveryRoute)
Reciept (RecieptID (pk), ItemNumber (fk), EmployeeID (fk), ReceivedDate)
Database tables
Retail Centre
Employee

3
MICRSOFT ACCESS DATABASE
Customer
Items
Transportation