LOYOLA COLLEGE (AUTONOMOUS), CHENNAI – 600 034 B.Sc. DEGREE EXAMINATION – STATISTICS
|
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)
- What is a database? Explain with an illustration.
- Write any four major sectors in which Database concepts applied very much.
- Define Data Manipulation Language.
- What is meant by Entity-Relationship Model? Explain by an example
- Define Physical Data Independence in DBMS and give an example
- What is cross-tabulation? Give an example
- What is meant by Indexing a file? State its advantages over sorting.
- Write the importance of SELECT command?
- Define a function and state its uses
- Explain drop SQL command
SECTION B
Answer any FIVE questions. (5×8=40)
- Explain Numeric, Memo and Date type fields in database records with examples.
- Write a FOXPRO program to find Minimum and Maximum of N numbers
- Illustrate the difference between Function and a Procedure
- 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
- Explain different Levels of Abstraction
- Explain a] Project operation b] Cartesian-Product operation with example
- Explain the implementation Sum and Count aggregate functions in Select SQL statement with example
- Illustrate and explain a] Primary Key b] Foreign Key
SECTION C
Answer any TWO questions. (2×20= 40)
- 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.
- Explain the following control structures in FOXPRO with examples.
a] SCAN b] IF ELSE IF… d] DO CASE e] DO WHILE
- 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
Latest Govt Job & Exam Updates: