The document outlines the structure of a PGDBM examination for Relational Database System Concepts, including sections for short answer questions and detailed explanations. It covers topics such as advantages of DBMS, normalization, SQL commands, and the duties of an Oracle DBA. Additionally, it includes a compulsory question requiring the identification of entities and relationships in a bus company scenario, along with the creation of an E-R diagram and normalization techniques.
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
0 ratings0% found this document useful (0 votes)
16 views2 pages
Relational Database System Concepts (RDBMS)
The document outlines the structure of a PGDBM examination for Relational Database System Concepts, including sections for short answer questions and detailed explanations. It covers topics such as advantages of DBMS, normalization, SQL commands, and the duties of an Oracle DBA. Additionally, it includes a compulsory question requiring the identification of entities and relationships in a bus company scenario, along with the creation of an E-R diagram and normalization techniques.
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
MOUNT CARMEL INSTITUTE OF MANANGEMENT, BANGALORE-52
PGDBM 5" TRIMESTER EXAMINATION — DECEMBER 2011
RELATIONAL DATABASE SYSTEM CONCEPTS (RDBMS)
‘TIME :3 HOURS MAX MARKS : 100
SECTION ‘A’
Answer any nine of the following. Each question carries two marks. (9X2=18)
1, What is the advantage of DBMS?
2. Define data in DataBase Management System.
3. What do you mean by constraints in DBMS?
4, What do you mean by schema?
5, Define Entity and Attribute.
6. What are the advantages of Relational Model?
7. What is the difference between a candidate key and the primary key for a given relation?
8. What is the need for Normalization?
9. Define a View.
10, What is a Trigger?
11, What is Datamodel?
12, What is the use of log in data recovering?
SECTION ‘B’
Answer any FIVE QUESTIONS. Each question carries EIGHT marks (5X8=40)
1. Explain the queries available in the Data Definition Language and Data Manipulatior.
Language.
. Explain the insertion, deletion and update anomalies in a Relational Database design,
. With a suitable example, explain the E-R model.
|. Explain with syntax and example the GROUP BY and HAVING clause commands.
. Write short notes on Functional Dependencies and access control.
What are the duties of an ORACLE DBA? Explain,
. Explain the differences between file oriented system and database oriented system.
Fave wD
Page 1of2 1. @), Explain in brief about relationship and relationship sets,
(b). Discuss about the relational data model
2. Explain in detail the various operators available in SQL with example,
3. Explain the various normalization techniques with suitable illustrations,
4, List out the various failure threats of a database and explain the log based Tecover:
technique,
5. COMPULSORY QUESTION
A Country Bus Company owns a number of buses. Each bus is allocated to :
particular route, although some routes may have several buses, Each route passe:
the towns have a garage where busses are kept and each of the busses are identified
by the registration number and can carry different numbers of Passengers, since ths
vehicles vary in size and can be single or double-decked. Each route Is identities bya
route number and information is available on the average number of passengers
carried per day for each route. Drivers have an employee number, name, address, and
sometimes a telephone number.
[dentify various entities, attributes and relationships forthe system with reference to
the listed activites. Also, draw an E-R diagram. Draw the necessary tables and
indicate the primary Key, foreign key, in each table. Indicate how Normalization ts
done with the help of tables for the above activities.
SOHO bene Reeser ReeE Hens eie eine
Page 2 of 2
