Exam Details
Subject | Database Management System | |
Paper | ||
Exam / Course | Post Graduate Diploma in Computer Application (PGDCA)/ Advance Diploma inComputer Applications (ADCA) / Masters in Computer Applications (MCA) | |
Department | School of Computer and Information Sciences (SOCIS) | |
Organization | indira gandhi national open university | |
Position | ||
Exam Date | December, 2016 | |
City, State | new delhi, |
Question Paper
The people's bank. offers five types of accounts: loan, checking, premium savings, daily interest saving and money market. It operates a number of branches and a client of the bank can have any number of accounts. Accounts can be joint. Identify the entities of interest and show their attributes. What relationships exist among these entities Draw the corresponding
What are M-Way Search Trees and how can they be used for Indexing
Consider the following set of FDs
A BC, AB CD, B D BC D Remove the redundant FDs from the set. Identify the possible candidate keys.
Describe the Network Model and its implementation.
What is Referential Integrity? Describe with the help of an example.
2. Consider the following tables
S Sname, Status, City)
SP PI, Quantity)
Write SQL Queries for the following:
Get supplier numbers and status for suppliers in Paris, in descending order of status.
Get unique Sname for suppliers who supply part P2.
Get all pairs of supplier numbers such that the two suppliers are located in the same city.
Get supplier numbers for suppliers with status >20 and city is New York.
Get the number of suppliers who are supplying at least one part.
What is ISAM Describe the various types of Indexes.
What are Views? Describe with the help of an example.
Explain the differences between a weak entity and a strong entity with the help of an example.
Consider the following data:
Create a B-Tree of order 5 to insert the
above data.
Suppose you are given a relation
R
with the following functional dependencies:
{CE D C
Find all candidate keys.
Identify the best normal form that R satisfies 2NF, 3NF or BCNF).
If the relation is not in BCNF, decompose it until it becomes BCNF. At each step identify a new relation, decompose and re-compute the keys and the normal forms they satisfy.
Describe the View Updating Rule and the Integrity Rule.
What are M-Way Search Trees and how can they be used for Indexing
Consider the following set of FDs
A BC, AB CD, B D BC D Remove the redundant FDs from the set. Identify the possible candidate keys.
Describe the Network Model and its implementation.
What is Referential Integrity? Describe with the help of an example.
2. Consider the following tables
S Sname, Status, City)
SP PI, Quantity)
Write SQL Queries for the following:
Get supplier numbers and status for suppliers in Paris, in descending order of status.
Get unique Sname for suppliers who supply part P2.
Get all pairs of supplier numbers such that the two suppliers are located in the same city.
Get supplier numbers for suppliers with status >20 and city is New York.
Get the number of suppliers who are supplying at least one part.
What is ISAM Describe the various types of Indexes.
What are Views? Describe with the help of an example.
Explain the differences between a weak entity and a strong entity with the help of an example.
Consider the following data:
Create a B-Tree of order 5 to insert the
above data.
Suppose you are given a relation
R
with the following functional dependencies:
{CE D C
Find all candidate keys.
Identify the best normal form that R satisfies 2NF, 3NF or BCNF).
If the relation is not in BCNF, decompose it until it becomes BCNF. At each step identify a new relation, decompose and re-compute the keys and the normal forms they satisfy.
Describe the View Updating Rule and the Integrity Rule.
Other Question Papers
Departments
- Centre for Corporate Education, Training & Consultancy (CCETC)
- Centre for Corporate Education, Training & Consultancy (CCETC)
- National Centre for Disability Studies (NCDS)
- School of Agriculture (SOA)
- School of Computer and Information Sciences (SOCIS)
- School of Continuing Education (SOCE)
- School of Education (SOE)
- School of Engineering & Technology (SOET)
- School of Extension and Development Studies (SOEDS)
- School of Foreign Languages (SOFL)
- School of Gender Development Studies(SOGDS)
- School of Health Science (SOHS)
- School of Humanities (SOH)
- School of Interdisciplinary and Trans-Disciplinary Studies (SOITDS)
- School of Journalism and New Media Studies (SOJNMS)
- School of Law (SOL)
- School of Management Studies (SOMS)
- School of Performing Arts and Visual Arts (SOPVA)
- School of Performing Arts and Visual Arts(SOPVA)
- School of Sciences (SOS)
- School of Social Sciences (SOSS)
- School of Social Work (SOSW)
- School of Tourism & Hospitality Service Sectoral SOMS (SOTHSM)
- School of Tourism &Hospitality Service Sectoral SOMS (SOTHSSM)
- School of Translation Studies and Training (SOTST)
- School of Vocational Education and Training (SOVET)
- Staff Training & Research in Distance Education (STRIDE)
Subjects
- Accounting and Financial Management
- Advanced Database Design
- Advanced Discrete Mathematics
- Advanced Internet Technologies
- Artificial Intelligence and Knowledge Management
- Communication Skills
- Computer Graphics and Multimedia
- Computer Organisation & Assembly Language Programming
- Data and File Structure
- Data Communication and Computer Networks
- Database Management System
- Database Management Systems
- Design and Analysis of Algorithm
- Discrete Mathematics
- Elements of Systems Analysis & Design
- Numerical and Statistical Computing
- Object Oriented Analysis and Design
- Object Oriented Technologies and Java Programming
- Operating System Concepts and Networking Management
- Operating Systems
- Parallel Computing
- Principles of Management and Information Systems
- Problem Solving and Programming
- Software Engineering
- Systems Analysis and Design