Answer
All Questions
Part
A – (10*2=20 marks)
1.Write the
characteristics that distinguish database approach with a file based approach?
2.Define functional
dependency?
3.State the need
for Query optimization?
4.What is the
difference between static and dynamic
SQL?
5.DefineDDL,
DML,DCL,TCL?
6.Why 4th
normal form is more desirable than BCNF?
7.What is the
purpose of DBMS?
8.Distinguish
referential integrity and domain integrity?
9.Define single
valued and multi valued attributes?
10.What is the use
of group by clause?
Part B (5*13=65)
11.(a)(i)Explain
Query processing with neat sketch?(6)
(ii) With a neat diagram, explain
the structure of a DBMS.?(7)
OR
(b)Consider the employee database , employee(empname,street,city)
works(empname,companyname,salary) company(companyname,city) manages(empname,management)
.work out all relational algebra
operations.(13)
12.(a) Write short
notes on the following: DML,DDL,TCL and
DCL with examples and syntax.(13)
OR
(b)Discuss in detail the operators
SELECT, PROJECT, UNION with suitable examples.(13)
13.(a) Explain
static and dynamic SQL in detail.(13)
OR
(b) Construct an
E-R diagram for a car-insurance company whose customers own one or more cars
each. Each car has associated with it zero to any number of recorded accidents.
State any assumptions you make.Use specialization concept.(13)
14(a) Explain the
basic concepts and constraints in E-R model with proper example. (13)
OR
(b) Give brief
notes on Query evaluations cost &
Selection operation(13)
15(a) Explain 1NF,
2NF, 3NF and BCNF with suitable example.(13)
OR
(b)Consider the
database given by the following schemes. Customer (Cust_No, Sales_ Person_No
,City) Sales_ Person(Sales_ Person_No ,Sales_ Person_Name,
Common_Prec,Year_of_Hire) Give an expression in SQL for each of the following
queries: Display the list of all customers by Cust_No with the city in which
each is located. Select Cust No, city from Customer List the names of the sales
persons who have accounts in Delhi. Select Sales_Person_Name from
Sales_Person_Namewhere( select * from customer where city = delhi) (13)
Part C (1*15=15)
16.(a) Construct an
ER model for Hospital management that includes a medical college .
OR
(b) Construct an ER
model for Employee payroll system?
0 Comments