Total Marks = 36
MCQs = 16 (01 Mark each)
One long question = 05 Marks
03 long questions = 03 Marks
03 Long questions = 02 Marks

Describe with example function of Union Operation in relational algebra (05 Marks)

Describe with example Refrential integrity constraints (03 Marks)

Describe functional dependency (03 Marks)

Give atleast 02 benefits of Normalization (02 Marks)

What is Data Definition Language (DDL) ? (02 Marks)

What is data type? (02 Marks)

Total Quest = 23

Max MCQ are from functional dependencies & current quiz

Questions
benifits of normalization=10

uses of ERD=5

difference b/w reation & table=3

candidate keys properties=2

_______________________________


what is relationship? 3

what is relationship set? 3

difference between relation schema and relation 5

define one to many relationship 5

what is Insertion Anomaly? 2