Karnataka State Open University (KSOU) 2009 Post Graduate Diploma I Semester - PGDCRDM - Database Management System - Question Paper
CD OS
I Semester P.G. Diploma in Clinical Research and Data Management
Examination, July 2OO9 DATABASE MANAGEMENT SYSTEM
Max. Marks : 80
Time : 3 Hours
SECTION - A
All questions compulsory.
(1Ox1=1O)
1. Define the term Data Model.
2. What is a Tuple ? Give an example.
3. What is cardinality of a relation ?
4. What is a relationship ?
5. Explain COUNT built in function with example.
6. What is third normal form also called as ? What is the difference between them ?
7. What is the loss of integrity ?
8. What is a cipher text ?
9. What is Clustering ?
10. Name the DML statements of SQL.
SECTION - B
Answer any S questions out of 8.
(SxS=2S)
1. Explain the advantages of database systems.
2. Explain Indexing for retrieval of records with example.
3. Describe the integrity rules in detail.
4. What are the advantages of database processing ?
5. Explain the function I of database management systems, i.e. Data Storage, Retrieval and Update with example.
6. Explain the built-in functions SUM, AVG, MAX, MIN and explain Order by clause with examples.
7. Explain with an example the second normal form.
8. Describe the characteristics of Data warehouse.
SECTION - C
Answer any 3 questions out of 6 questions. (3x10=30)
1. Describe the relational Algebra Operators :
SELECT, PRODUCT, INTERSECT, DIFFERENCE.
2. Explain the function 4 concurrency control services, function 6 authorization services and function 7 support for data communication.
3. Explain in detail the database design goals.
4. Explain mandatory access control and role-based access control for multilevel security.
5. Explain the Encryption and Public Key Infrastructures.
6. Explain in detail the problems and open issues in data warehouses. How are data warehouses different from views ?
(Ixi5=15)
Consider the following database tables : Order_Aug
|
Ord # |
Ord date |
Cust # |
|
Ord_Items | ||
|
Ord # |
Item# |
Qty |
|
Items | ||
|
Item # |
Descr |
Price |
|
Customers | ||
|
Cust # |
Cust name |
City |
Write the SQL Query for the following :
a) Insert a new row to Ord_Aug.
b) Find the SUM and AVG of quantity values of all rows where item 5 = SWI.
c) Retrieve all the rows from Ord_items in ascending order of item 5. If there are more than one record for same item 5 display them in descending order of Qty.
d) Retrieve the records of Ord 5, Ord_Aug.cust 5, custname implementing Join Operator.
e) Select all the Cust 5 where the customer name start with S.
|
Attachment: |
| Earning: Approval pending. |
