Database Management System

Database Management System

Pg. 01

Question Three

Deadline: Day 26/3/2020 @ 23:59
Introduction to Database

IT 244

https://www.seu.edu.sa/sites/ar/SitePages/images/logo.png

College of Computing and Informatics

Question One
1 Mark

Learning Outcome(s):2

Create entity-relationship model, relational model, and write SQL queries

Using your own words, in relational algebra, what is the difference between the select and project operations? Also, give an example differentiating the two operations.

Question Two
1 Mark

Learning Outcome(s): 2

Create entity-relationship model, relational model, and write SQL queries

Based on the giving relation below called STUDENT, what are the outputs of the giving operations?

a. (STUDENT)

b. (STUDENT)

ID

Name

Age

Address

111

Fahad

18

RUH

222

Mohammad

20

JED

333

Khaled

22

ABH

Question Three
3 Marks

Learning Outcome(s):2

Create entity-relationship model, relational model, and write SQL queries

Consider the following relation R:

Student-ID

Student-firstname

Student-lastname

Student-Telephone

Course Title

Fee

Qualification

Grade

Answer the following questions:

a. Write all functional dependences F.

b. Normalize R into 1NF, 2NF, 3NF with explanation.

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."

"Order a Custom Paper on Similar Assignment! No Plagiarism! Enjoy 20% Discount"