Database (subject)

choose a real-world example to illustrate the effectiveness of database systems in the business world. In order to do that, you are required to design and implement a database system for any business of your choice. By developing this database system, you should be able to achieve better business processes and operations with the goal to enhance how the average user views and interacts with the data.

Deliverables:

1. Data requirements of a real-world system that saves a substantial amount of data (At least 4 entities). Describe the system in one paragraph. Identify all possible attributes of each entity and also mention properties of attributes (unique, derived, etc). Identify system-related constraints.

2. ER Model of the selected system based on the identified requirements. Mention all possible relationships between entities.