Report: Database Design and Implementation for IPS System
VerifiedAdded on 2022/10/19
|12
|526
|39
Report
AI Summary
This report details the database design and development of the International Parcel Service (IPS) system. It begins with an introduction and presents an ER diagram illustrating the database structure, followed by the implementation of tables in third normal form. The report includes table structures for Customer, Item, Retail Centre, Employee, Receipt, and Transportation, along with functional dependencies analysis. The database is implemented using MS Access, and the report showcases an item form and several SQL queries designed to retrieve specific data. A sample report generated from a query is also included. The report concludes with a summary of the IPS system's database design and implementation, along with references to relevant resources on database normalization.