Microsoft Access Database Project: Implementation of Database System

This Microsoft Access database project showcases the design and implementation of a relational database system. It includes an ER diagram that is converted to 3NF, relational schema, and database tables for various entities such as Retail Centre, Employee, Customer, Items, Transportation, and Receipt. The project also features forms for data entry, SQL queries for data retrieval, and reports for data analysis, including numeric reports on customer orders and item details. The database incorporates functional dependencies to ensure data integrity and relationships between tables are properly defined using primary and foreign keys. The project concludes with a bibliography referencing relevant academic sources on database systems and management. Desklib is the perfect place to find this and other solved assignments.

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

4
MICRSOFT ACCESS DATABASE
Receipt
Table Data
Customer
Retail Centre

5
MICRSOFT ACCESS DATABASE
Employee
Items
Receipt

6
MICRSOFT ACCESS DATABASE
Transportation

7
MICRSOFT ACCESS DATABASE
Forms
Queries
Select
Join

8
MICRSOFT ACCESS DATABASE
Numeric
Report
Customer Orders

9
MICRSOFT ACCESS DATABASE
Item Details
Receipt

10
MICRSOFT ACCESS DATABASE

11
MICRSOFT ACCESS DATABASE
Bibliography
Lewis, K.A., Tzilivakis, J., Warner, D.J. and Green, A., 2016. An international database for
pesticide risk assessments and management. Human and Ecological Risk Assessment: An
International Journal, 22(4), pp.1050-1064.
Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management.
Cengage Learning.
Vasireddy, S., Allman, C., Farrant, J., Ammori, M., Khan, N. and Bromilow, L., 2016.
THU0488 New Zoledronate Database Significantly Improves Pre-Assessments and Waiting
Times To Repeat Infusions–Results from A Quality Improvement Project.
Kralj, D. and Hren, N., 2018, January. Framework project of database development: Record
keeping of protective equipment. In 7. Međunarodni stručno-znanstveni skup" Zaštita na
radu i zaštita zdravlja"/7th International Professional and Scientific Conference"
Occupational safety and health".