Exam Details
| Subject | dbms (data base management systems) | |
| Paper | ||
| Exam / Course | pg diploma in information technology (pgdit) | |
| Department | ||
| Organization | acharya nagarjuna university-distance education | |
| Position | ||
| Exam Date | May, 2017 | |
| City, State | new delhi, new delhi |
Question Paper
Total No. of Questions 10] [Total No. of Pages 01
P.G. Diploma DEGREE EXAMINATION, MAY 2017
INFORMATION TECHNOLOGY
DBMS (Data Base Management Systems)
Time 3 Hours Maximum Marks: 70
Answer any FIVE questions
All questions carry equal marks
Q1) Draw and explain the three level architecture of the database system.
Q2) Describe various types of attributes present in the E-R model.
Q3) Explain network database management system with suitable example.
Q4) What are the types of data integrity constraints? Explain primary key and foreign
key constraint with suitable example.
Q5) Describe the advantages of relational database management system over file
management system.
Q6) Draw a Entity Relation diagram for the Hospital Management System. Consider
the different types of Patients with respect to Disease and In-Patient and Out-
Patient Department in the design. Consider the availability of all well qualified
Doctors. Consider various types of tests and operations to be conducted. Explain
the mapping cardinality used. Assume suitable attributes. Use generalization and
Specialization.
Q7) What is normalization? Explain the need for normalization. Discuss various
types of normal forms.
Q8) Discuss various anomalies in the process of database design.
Q9) What is Relational Algebra? Enlist and explain the fundamental operation of
relational algebra with suitable example.
Q10) Describe different DDL and DML commands with syntax.
P.G. Diploma DEGREE EXAMINATION, MAY 2017
INFORMATION TECHNOLOGY
DBMS (Data Base Management Systems)
Time 3 Hours Maximum Marks: 70
Answer any FIVE questions
All questions carry equal marks
Q1) Draw and explain the three level architecture of the database system.
Q2) Describe various types of attributes present in the E-R model.
Q3) Explain network database management system with suitable example.
Q4) What are the types of data integrity constraints? Explain primary key and foreign
key constraint with suitable example.
Q5) Describe the advantages of relational database management system over file
management system.
Q6) Draw a Entity Relation diagram for the Hospital Management System. Consider
the different types of Patients with respect to Disease and In-Patient and Out-
Patient Department in the design. Consider the availability of all well qualified
Doctors. Consider various types of tests and operations to be conducted. Explain
the mapping cardinality used. Assume suitable attributes. Use generalization and
Specialization.
Q7) What is normalization? Explain the need for normalization. Discuss various
types of normal forms.
Q8) Discuss various anomalies in the process of database design.
Q9) What is Relational Algebra? Enlist and explain the fundamental operation of
relational algebra with suitable example.
Q10) Describe different DDL and DML commands with syntax.