Project 1
Database Implementation
Due Date: Thursday 28/1/2023
Objective:
The main goal of this project is to give the students a first hands experience on using DBMS to create and manipulate a small database. By completing this project, students should be able to create database systems, write SQL queries, interact with a particular DBMS and manipulate the created database.
Description: Students are free to choose one of the suggested environments that are given by the instructor or come up with their own. Also, they may work as group of 3 as maximum or individually. Also, they are free to choose the DBMS they feel comfortable with.
Submission.
In order to get a full credit in this assignment, students need to submit the following:
– ER diagram.
– The database schema.
– The creation file (.sql)
– Five queries as minimum with their results (note: All the queries should have at least one row as a result)
– Sample of the tested data. (Note: At least 5 rows in each relation)
Suggested environments:
a. Car Rent organization.
b. Airport.
c. English language Institute.
d. Amazon. e. Library.
f. Restaurant.
Note: We study FUNDAMENTALS OF Database Systems, SIXTH EDITION, Ramez Elmasri & Shamkant B. Navathe and MySQL