Firefox https://newerp.kluniversity.in/index.php?r=examsection%2Fexamqpiniti...
B.Tech - Even Sem : Semester in Exam-I
Academic Year:2023-2024
22AD2102R - DATABASE MANAGEMENT SYSTEMS
Set No: 2
Time: Max.Marks: 50
CO COI
S.NO Answer All Questions Choice Options Marks CO
BTL BTL
1. Answer the following questions 12Marks CO1 3 2
1.A. List out the duties of DBA? 2Marks CO1 3 2
1.B. What is Database? 2Marks CO1 3 2
Differentiate between Single Valued Attribute and Multi-Values Attributes in
1.C. 2Marks CO1 3 2
database design?
1.D. Provide an example of a scenario where a alter table would be useful in SQL? 2Marks CO2 3 2
1.E. Can we update the Data in a relational table by using SQL View? 2Marks CO2 3 2
1.F. Describe about significance of trigger in Data Manipulations on a Table? 2Marks CO2 3 2
2. Answer the following questions 16Marks CO2 3 3
Extract the tables from the following ER Model
2.A. 4Marks CO1 3 2
2.B. Explain about different levels of Data Independence of DBMS? 4Marks CO1 3 2
By using the two relations EMP(EMPNO,ENAME,SAL,DNO) and
DEPT(DNO,DNAME), express the following operation using SQL A)Find
the details of Employees, who are getting maximum salary in their
departments
2.C. 4Marks CO2 3 3
2.D. Describe sub queries with an example? 4Marks CO2 3 2
choice
3. Answer the following questions 11Marks CO1 3 2
Q-4
1 of 3 7/10/2025, 4:15 PM
Firefox https://newerp.kluniversity.in/index.php?r=examsection%2Fexamqpiniti...
Apply the principles of Entity-Relationship (ER) modeling to design a
conceptual schema for a university database system. Clearly define entities,
attributes, and relationships, and explain how cardinality and participation
constraints are represented in the ER diagram. Use the following description
for designing the ER diagram. The Analysis Model for a Hospital
Management System encompasses four key entities: Doctors, Patients,
Medical Records, and Inventory. Doctors are associated with patients through
a "treats" relationship, indicating their involvement in patient care. Medical
3.A. 5Marks CO1 3 2
Records link Doctors and Patients, capturing the history of diagnoses and
treatments. The Inventory entity reflects the hospital's resources, establishing
relationships with both Doctors and Patients to track medical supplies and
equipment usage. Additionally, the Patients entity maintains a connection
with Medical Records to record health information. This model forms a
comprehensive framework, illustrating the interdependence of healthcare
professionals, patients, medical data, and inventory management within a
hospital setting.
Evaluate the Extended Entity-Relationship (EER) model and its significance
in addressing complex data modeling requirements. Provide examples of
situations where EER features, such as specialization, generalization, and
aggregation, would be beneficial. Use the following scenarios to illustrate, i.
3.B. 6Marks CO1 3 2
Employees are divided into Teaching staff, Non-Teaching staff. ii. Vehicles of
kind Two-Wheeler, Four Wheelers. iii. Student’s studies subjects like
Professional Courses, Social Courses and Management Courses iv. A Student
belongs to a Department.
4. Answer the following questions 11Marks CO1 3 2
Explain the three-tier architecture of a Data in Database Management
4.A. 5Marks CO1 3 2
System?
4.B. Explain the differences between String and Week entities in ER Model? 6Marks CO1 3 2
choice
5. Answer the following questions 11Marks CO2 3 3
Q-6
List out the Employee Name and Manager Name for all employees by using
following relation EMP(EMPNO,ENAME,MGRNO). Hint: MGRNO is
reference key reference to EMP
5.A. 5Marks CO2 3 3
5.B. Describe about Join Operation in SQL. Illustrate with an example? 6Marks CO2 3 2
6. Answer the following questions 11Marks CO2 3 3
6.A. Compose a query that retrieves the names of suppliers (SNAME) and the 6Marks CO2 3 3
corresponding project names (PNAME) for suppliers located in
'LONDON’(CITY) and the quantity (QTY) of parts supplied to each project.
2 of 3 7/10/2025, 4:15 PM
Firefox https://newerp.kluniversity.in/index.php?r=examsection%2Fexamqpiniti...
Write a Trigger to check insert validation for Table SP(SNO,PNO,QTY).
Condition Supplier Number must be one of ‘S1’, ‘S2’, ‘S3’?
6.B. 5Marks CO2 3 3
[object HTMLDivElement]
3 of 3 7/10/2025, 4:15 PM
