DISTANCE EDUCATION
M.C.A. DEGREE EXAMINATION, MAY 2018.
First Semester
RELATIONAL DATABASE MANAGEMENT SYSTEMS
(2010 Academic Year onwards)
Time Three hours Maximum 100 marks
PART A — x 8 40 marks)
Answer any FIVE questions.
1. What is a Data Model? Explain.
2. Give the usage of the Rename operation with an example.
3. Consider the following relation:
EMP NAME, DATE_OF_BIRTH, SEX,
DATE_OF_JOINING, BASIC_PAY, DEPT) Develop an
SQL query that will find and display the average
BASIC_PAY in each DEPT.
4. Define Primary Key and Foreign Key with table
explanations.
5. Give a brief description on DML commands.
6. Explain the overview of the Oracle Architecture.
Sub. Code
103
DE-4097
2
SP 5
7. Discuss in details the operators, SELECT, PROJECT and
UNION with suitable examples.
8. Explain Joining Function with an examples.
PART B — × 15 60 marks)
Answer any FOUR questions.
9. Discuss in detail about Data Base System Architecture
with neat diagram.
10. Consider the following six relations for an
Order-processing
Database Application in a Company:
CUSTOMER (CUSTNO, CNAME, CITY)
ORDER (ORDERNO, ODATE, CUSTNO, ORD_AMT)
ORDER_ITEM (ORDERNO, ITEMNO, QTY)
ITEM (ITEMNO, ITEM_NAME, UNIT_PRICE)
SHIPMENT (ORDERNO, ITEMNO, WAREHOUSENO,
SHIP_DATE)
WAREHOUSE (WAREHOUSENO, CITY)
Here, ORD_AMT refers to total amount of an order;
ODATE is the date the order was placed; SHIP_DATE is
the date an order is shipped from the warehouse. Assume
that an order can be shipped from several warehouses.
Specify the foreign keys for this schema, starting any
assumptions you make.
DE-4097
3
SP 5
11. Discuss the terms Distributed Database and
Client/ Server Database.
12. Explain Data Independence and its types with examples.
13. Create two table, 'University' and 'Student' using Join
function to join both the tables entity. And also use the
COPY and DROP commands.
14. Explain about Discretionary access control based on
GRANT and REVOKE privileges.
15. Explain the following with examples
DML
DCL
Embedded SQL.