CS-O6 : DATABASE MANAGEMENT SYSTEM
Time :3 hours Maximum Marks : 75
Note : Question no. 1 is compulsory' Attempt any three questions from the rest.
l. (a) With the help of a suitable example, explain a hierarchical database model. (7)
(b) What are the advantages of index-sequential file organisation ? With the help of an example explain
the structure of index sequential file. (5)
(c) Why are remote procedure calls used ? Why is a set of DDE maintained at application level ?(5)
(d) Design an ER diagram for any of IGNOU's study centres. Clearly indicate the entities, attributes,
relationships and the key constraints.(8)
(e) With the help of two examples for each, explain the use of multimedia databases and knowledge
2. (a) Consider an employee file with the details given (8)
below : -
Record E# Name Occup. Degree Sex Location Salary(i) Make a multi list representation of this employee file.
A 800 Milind Prog. M.E. M Delhi 10,000
B 510 Adwet Analyst B.E. M Mumbai 15,000
c 200 Devendra Analyst B.E. M Delhi 72,OO0
D 300 Mukesh Prog. M.E. M Chennai 9,000
(ii) Write a query to retrieve the record of
Salary > 12,000, Degree = M.E.,
Location = Delhi, Occupation = Analyst,
Sex = M.
(b) What are the main features of client-server model ? Explain the stages involved in the development of an application using this model. (7)
3. (a) Why is the administration of a database system required ? What are the various functions associated
with database administration ?(5)
(b) Define a data manipulation language. Write a syntax for the following and give an example for each :(10)
(i) Select statement
(ii) Update statement
(iii) Delete statement
(iv) Insert statement
4. (a) With the help of an example relation and the dependency diagram, explain the concept of functional
(b) Explain the following tools with respect to client-server environment : (7)
(i) Dynamic data exchange
(ii) Object linking and embedding
Also mention the usage of these with an example for each.
5. (a) Consider the schema given below :
Branch-scheme (Branch-name, asset, Branch-city)
Customer-scheme (Customer name, street,customer-city)
Deposit-scheme (Branch-name, account-number,customer-name, balance)
Borrow-scheme (Branch-name. loan-number,customer-name, amount)
Client-scheme (Customer-name, banker-name)
Write the SQL statements for the following : (8)
(i) Find all customers who have a balance of over Rs. 1000.
(ii) Write the query to find the clients of banker Patel, and the city they live in.
(iii) Write a statement to find all the customers who have a loan amount of more than Rs. 1200.
(iv) Write a statement to find all the customers whose name starts with "R" and who have a balance of more than Rs. 10,000.
(b) With the help of an example, explain the properties of a Balanced sort tree.(7)