The idea of this project is to practice the design, implementation, and manipulation of an application database system from scratch. Students will be able to learn DB design methodology for relational DB and create a DB which can store data efficiently, retrieve information effectively, and free from data anomalies. The DB development process will consist of the following steps:

$1.$ Collect and describe the requirements details of your selected application.

$2.$ Draw the appropriate ER$/$EER representation of your application.

$3.$ Design the relational schema of your application based on your ER$/$EER representation. All constraints $($Keys$,$ Integrity, Referential, $...)$ should be clearly stated.

$4.$ Select a DBMS System $($Oracle$,$ Mysql$,$ SQL Server, online SQL interpreters...$)$ to create your relations schemas and populate them with at least $10$ tuples for each relation.

$5.$ Design different SQL queries $($at least $10$ covering the different features of SQL$).$ Run these queries on the selected DBMS and present the results. Your queries should involve most of the relations your designed and include complex queries. They should consider Multiple tables join; Use sub$-$queries; Group data using GROUP BY; Sort query results using ORDER BY; IN or NOT IN; LIKE; Aggregate functions or calculated fields.

$6.$ Contribution sheet: attach a sheet that shows your meetings and contribution of each member $($weekly meetings are recommended$).$

In what follows there are some ideas you may consider for your application. You can present your own idea to your course instructor to get approved before start working on it$.$

$$ Bahrain $2023$ formula $1$ management system

$$ Charity management system.

$$ Football competition management Systems $($Different ideas may be considered for the topic...$)$

$$ Tennis tournament management system

$$ EWA Management System

Project group should include $3-4$ students from the same section. Groups detailed and the selected idea should be sent to your instructor no later than November $26$th$,2$pm$.$ The deadline of the project is due to December $21$th$,6$pm$.$ You are expected to prepare a short report $(15$ to $20$ pages maximum$)$ including details of the steps introduced above. Groups caught copying each other$$s reports or copying past semesters$$ projects or downloading ready projects$/$reports will be rejected and receive negative marks.

Criteria of the evaluation will be:

$$ The selected idea

$$ The design of the application database

$$ The relational schema

$$ Database Creation$/$SQL Queries$/$Results

$$ Questions$/$answers $($Discussion$)$