LOYOLA COLLEGE (AUTONOMOUS), CHENNAI – 600 034 B.Sc. DEGREE EXAMINATION – STATISTICS

AB 12

FIFTH SEMESTER – NOV 2006

ST 5403 – DATABASE MANAGEMENT SYSTEMS

 

 

Date & Time : 06-11-2006/9.00-12.00   Dept. No.                                                     Max. : 100 Marks

 

 

SECTION A 

Answer  ALL the questions.                                                                                 (10×2=20)

 

1. What is a database? Explain with an illustration.
2. Write any four major sectors in which Database concepts applied very much.
3. Define Data Manipulation Language.
4. What is meant by Entity-Relationship Model? Explain by an example
5. Define Physical Data Independence in DBMS and give an example
6. What is cross-tabulation? Give an example
7. What is meant by Indexing a file? State its advantages over sorting.
8. Write the importance of  SELECT   command?
9. Define a function and state its uses
10. Explain drop SQL command

 

 

SECTION B

Answer any FIVE questions.                                                                               (5×8=40)

11. Explain Numeric, Memo and Date type fields in database records with examples.
12. Write a FOXPRO program to find Minimum and Maximum of N numbers
13. Illustrate the difference between Function and a Procedure
14. Use the tables given below to answer the following questions :

a] Write an SQL statement to find the name of the customer with customer-id 192-

83-7465

 

b] Write an SQL statement to find the balances of all accounts held by the customer

with customer-id 192-83-7465

 

 

 

 

 

15. Explain different Levels of Abstraction

 

16. Explain a] Project operation b] Cartesian-Product operation with example

 

17. Explain the implementation Sum and Count aggregate functions in Select SQL statement with example

 

18. Illustrate and explain a] Primary Key b] Foreign Key

SECTION C             

Answer any TWO questions.                                                                              (2×20= 40)

19. a] Discuss in detail about any four types of DBMS

b]  Write any five major components of  a DBMS? Explain each of them in detail.

20. Explain the following control structures in FOXPRO with examples.

a] SCAN             b]  IF ELSE IF…      d] DO CASE    e] DO WHILE

21. a] The database file MARKS.dbf database file contains the fields ID, SUB1, SUB2, SUB3,SUB4 and SUB5 . Write a FOXPRO program which prepares a report to display the Grade as ‘FIRST’ if average is greater than 60 ,  Grade as ‘SECOND’ if average  is >50 and <=60 , Grade as ‘THIRD’ if average is >40 and <=50 and otherwise  Grade as ‘FAIL’. Also extend the code to find the topper in the class and more consistent scorer with regard to appropriate statistical measures.

[b] What is a Cursor? Explain Dynamic cursor by an illustration.

 

 

22.a] Discuss the important benefits of  stored  Procedures in SQL

 

b] Write short notes about each of the following:

 

[i] Data-Mining  c] Data Warehouse  d] OLAP

 

 

 

Go To Main page

Go To Main page