BoardGuess.com

CS-O6 : Database Management System-June,2006

BACHELOR IN COMPUTER APPLICATIONS

Term-End Examination

June, 2006

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

databases.(5)

2. (a) Consider an employee file with the details given (8)

below : -

Record E#    Name     Occup.   Degree    Sex     Location     Salary

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

(i) Make a multi list representation of this employee file.

(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

dependency.(8)

(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)

  « MCSL-25 Lab Course - 2008 ICSE Question Papers - 1996 »  

  Posted on Friday, November 28th, 2008 at 12:39 PM under   2006 | RSS 2.0 Feed



Start Discussion!
*
* (Will not be published)
* (First time user can put any password, and use same password onwards)
*
Start a new topic: (If you have any question related to this post/category then you can start a new topic and people can participate by answering your question in a separate thread)
Title/Question: (55 Chars. Maximum)
Comment/Detailed description:* (No HTML / URL Allowed)

Characters left

Verification code:*



(If you cannot see the verification code, then refresh here)




CBSE Board, UP Board, IGNOU, JNU, MBA MCA, BBA and other educational boards of India

Disclaimer: For documents and information available on BoardGuess.com, we do not warrant or assume any legal liability or responsibility for the accuracy, completeness, or usefulness of any information. Papers, Results, Syllabus, Logo and other educational contents are owned by Indian Education Board and BoardGuess does not hold any copyright on it. The format of materials, being displayed on this website, comes under the copyright act. BoardGuess.com, All Rights Reserved ©