BCA/B.B.A. (Sem. II) EXAMINATION, 2018
202 DATABASE MANAGEMENT SYSTEM
(2013 PATTERN)
Time Three Hours Maximum Marks 80
N.B. All questions are compulsory.
(ii Draw neat diagrams wherever necessary.
1. Answer the following (any four)
State and explain the advantages of DBMS.
What are logical and physical files
Explain the views of Database Management System.
Explain the different DBMS and RDBMS used in the Industry.
Explain Primary key and Foreign key with example.
2. Answer the following (any four)
Explain the various DML commands with examples.
Explain the syntax of ALTER Table.
Explain union and difference in Relational algebra with suitable
example.
What is Normalization Explain 1NF with suitable example.
Explain sparse index.
P.T.O.
[5363]-202 2
3. Attempt the following
Consider the following entities and their relationship
Game gname, no-of-player, coachname)
Player pname)
Game and player are related with many-to-many relationship
Create RDB in 3NF and solve the following queries using SQL
(any five)
Delete a row from Game table for game "Cricket"
Display all players who play game "Table Tennis"
List all games played by Rajesh
Add column Age in the player table
Count total no. of players whose coach is "Kiran"
Count max no. of players in a game.
4. Write short notes on (any four)
Explain Insert Anomalies with example.
Aggregation and Generalization.
Order by and Group by.
Entity, attribute, superkey, tuple.
Sequential file organization.
[5363]-202 3 P.T.O.
5. Attempt the following
Consider the below
INVOICE
Hilltop Animal Hospital Date Jan. 14 2018
Invoice No. 97
Mr. Richard Cook
490 This Street
England
PET Procedure Amount
Rover Rabbies Vaccination 400=00
Morris Rabbies Vaccination 700=00
Total 1100=00
Tax 110=00
Amount Owing 1210=00
Normalize the above case upto 3 NF.
Consider the database and write relational algebraic expression
Patient Master (PatientNo. PatientName, Sex, Address City,
Allergy, Chief Complaints)
Display all patients whose Allergy is "Nimesulide"
(ii Display all male patients from city Calcutta.
(iii Update all patients whose sex is "M" with "Male".
List all patients whose chief complaint is "fever".