Karnataka State Open University (KSOU) 2010-1st Sem B.Sc Information Technology Database Management Systems -- Question Paper
I Semester B.Sc. (I.T.) Examination, June/July 2010 DATA BASE MANAGEMENT SYSTEMS
Max. Marks: 75
Time : 3 Hours
PART - A
Answer all the questions
(10x2+5x1=25)
1. Explain strategic information.
2. What is meant by data processing ?
3. Write any two advantages of Electronic Data Processing.
4. What is difference between physical and logical file organisation ?
5. Explain conceptual schema.
6. Write any two advantages of DBMS.
7. Define validating attributes.
8. What do you mean by operationally challenged workstations ?
9. Write any four rules of functional dependencies.
10. Define Encapsulating logic.
11. Explain the following terms.
a) Operational information
b) Normalisation
c) File organisation
d) Relational algebra
e) Dynamic SQL.
(5x10=50)
1. What is Data Model ? Explain the different types of Data Models n details.
2. Explain Entity Relationship (E-R) Diagram in detail.
3. Explain the major components of DBMS.
4. Briefly explain the basics of Relational Algebra with an examples.
5. Explain a multiway tree of order M.
6. Explain the properties of Relational Tables.
7. Write a note on Boyce-Codd Normal form.
8. Explain Codd rules with the help of suitable example.
Attachment: |
Earning: Approval pending. |