Database management System
|
Pg. 01 |
|
Question Three |
|
|
|
|
Assignment 2
Deadline: Day 26/3/2020 @ 23:59
[Total Marks for this Assignment are 5]
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.