The understanding of database analysis and design are necessary to develop a database management system. Based on what you learned thus far, choose a real-world example to illustrate the effectiveness of database systems in the business world?

In order to do that, you are asked 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 goal to enhance how the average person views and interacts with their data.

This course project is intended to give students an opportunity to exercise and participate in all phases of the development of a database application. The development of the application will require students to use ER modeling techniques, relational modeling techniques.

Project can be done in groups of up to 3 individuals. Groups'members will be assigned the same mark for each part of the project. You are required to develop a database that can be used to provide the frontend and the backend support intended for a business of your choice.

Your database application should include the following parts for the suggested business:

1- The students have to write the scenario, where contains full details required for EDR, user requirements and business rules.

2- Requirements and Conceptual Model: Design the ER schema for your database. Show all constraints & state all assumptions. Your ER diagram may be hand-drawn, but it must be clear and readable.