Database Management System
Pg. 01
Question Three
Deadline: Day 26/3/2020 @ 23:59
Introduction to Database
IT 244
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."