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.

The post Database Management System appeared first on edubrained.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"