Fundamentals of Database|Quick homework help

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 MySQLTaif 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

SOLUTION

A database is a collection of data that is organized in a specific way. Database systems are designed to manage and manipulate this data. The fundamentals of database systems include concepts such as data modeling, data integrity, data manipulation, and data querying.

Data modeling is the process of creating a conceptual representation of the data in a database. It involves defining the structure of the data, including the relationships between different data elements.

Data integrity refers to the accuracy and consistency of the data in a database. It includes concepts such as validation of data input, constraints on data, and rules for data manipulation.