Scribd
Upload
3 views2 pages

DBMS IAT-II Expected Questions Guide

The document outlines expected questions for an IAT-II examination in a Database Management Systems (DBMS) course, covering key concepts such as decomposition, functional dependency, and the entity-relationship model. It includes both Part-A questions, which focus on definitions and explanations, and Part-B questions that require more elaborate discussions and examples. Topics also include normalization forms, mapping between ER and relational models, and specific attributes in the ER model.

Uploaded by

rarchana.engineering
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views2 pages

DBMS IAT-II Expected Questions Guide

The document outlines expected questions for an IAT-II examination in a Database Management Systems (DBMS) course, covering key concepts such as decomposition, functional dependency, and the entity-relationship model. It includes both Part-A questions, which focus on definitions and explanations, and Part-B questions that require more elaborate discussions and examples. Topics also include normalization forms, mapping between ER and relational models, and specific attributes in the ER model.

Uploaded by

rarchana.engineering
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

DEPARTMENT OF COMPUTER SCIENCE AND ENGINEERING

Subject Name:DBMS Sub


Code :CS3492

IAT-II EXPECTED QUESTION

Part-A
1. List the desirable properties of decomposition. (K2)

2. Define functional dependency (K1)

3. what is lossless decomposition? Give examples. (K1)

4 . Define join dependency. (K1)

5. Explain entity relationship model. (K2)

6. Define normal forms. Explain the types. (K1, K2)

7. List the desirable properties of decomposition. (K2)

8. State the types of attributes in E-R model.(k2)

[Link] four significant differences between a file-processing system and a


DBMS. (K2)
10. What is an derived attribute? Give example. (K1)
11. What is weak entity? Give example (K1)
12. Give example for one to one and one-to-many relationship. (K2)
[Link] are the different types of Data Models? (K2)
[Link] is primary key constraint? (K1)
[Link] trivial functional dependency.(k1)
[Link] is ER Diagram.(k1)
Part- B
1. Discuss the correspondence between the ER model construct and the
relational model constructs. Show how each ER model construct can be
mapped to the relational model. Discuss the option for mapping EER
model construct. (k2)
2. Elaborate on first normal form, second normal form and third normal form with examples. (k2)

3. i)Illustrate functional dependency with an example.(k2)

(ii) Discuss about dependency preservation.(k2)


4.i) Explain briefly about the various types of Attributes.(k2)
ii)Explain about ER model. (k2)
5..Explain various normal forms in database management systems which
are required for fulfilling normalization requirements of an organization.
(k2)
6. Explain the principles of Loss less join decomposition and Join
dependencie
s.(k2)

7. Consider the following relation: STUDENT (ROLLNUMBER, NAME, DOB,


GENDER, BRANCH_CODE, BRANCH_NAME) The primary key of the
relation is ROLLNUMBER. The following functional dependencies hold:
ROLLNUMBER → NAME, DOB, GENDER, BRANCH_CODE BRANCH CODE
→ BRANCH_NAME Is relation STUDENT normalized? If yes, justify the
relation is normalized. If no, state reasons and normalize the same.
(k4)

You might also like