Project 1 Database ImplementationDue 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
Taif University Fall 2021
College of Computer & Information Technology
Project 1
Database Implementation
Due Date: Thursday 19/1/2023
Grade: 10 points
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.
Dr. Mashael Alsulami
Order an Essay Now & Get These Features For Free:
Turnitin Report
Formatting
Title Page
Citation
Outline
