Osmania University (OU) 2010 B.Sc Computer Science DATABASE MANAGEMENT SYSTEM(C3)- First Term - Question Paper

SHADAN DEGREE COLLEGE FOR BOYS
(Affiliated to Osmania University)
Khairatabad, Hyderabad
1st Term exam
B.Sc. three Year
DATABASE MANAGEMENT SYSTEM(C3)

Time: three Hours Max. Marks: 100

SECTION-A

Note: ans any 5 ques. (4*5=20)

1. describe what is data, database, database system.
2. discuss the components of database system.
3. elaborate advantages of data base system.
4. discuss various kinds of database systems.
5. describe relational kinds of database systems.
6. describe Primary key and foreign key.
7. describe generalization and specialization with example.

SECTION-B

ans any 5 of the subsequent (5*10=80)

1. describe DBMS. elaborate the components of DBMS.
OR
2. What is normalization. discuss all the normal forms.

3. List and briefly define every of the 6 steps in database development life cycle.
OR
4. Write different operators in SQL and discuss all datatypes.

5. define all degrees of abstraction.
OR
6. describe every of the subsequent terms in your own words.
1) Model
2) Object set
3) Functional relationship

7. discuss the relationships with in the relation databse.
OR
8. describe an attribute. discuss various kinds of attributes.

9. define all the relational algebra operators.
OR
10. Write the SQL commands.

Earning:   Approval pending.