Database Fundamentals for Engineers

Project$/$Assignment

Create the ER Diagrams and their Relational Database implementation including sample data for a taxi management system which includes

Taxi, Driver, Journey, Passenger and Payment entities.

The required items are:

$1$ E$-$R Diagram showing all entities and their relationships, indicate how each relationship will be implemented

$2-$ Primary keys with proper names

$3$ Any Foreign keys

$4$ At least one check constraint

$5$ All the MySQL scripts to build the database including sample data

You will be graded as follows:

Interview with questions and answers to show how you made your design choices and how you can make on$-$the$-$spot changes.

Submission deadline is Wednesday $22$nd May at $2359$ and interviews begin asap afterwards in office hours.

You must work in teams of $3-4$ students.