Exam Details
| Subject | Database Management System | |
| Paper | ||
| Exam / Course | B.Tech In Computer Science And Engineering (BTCSVI) | |
| Department | School of Engineering & Technology (SOET) | |
| Organization | indira gandhi national open university | |
| Position | ||
| Exam Date | December, 2015 | |
| City, State | new delhi, |
Question Paper
What are the disadvantages of DBMS as compared to file processing systems Explain in detail.
What are the different subsystems in DBMS architecture?
What do you mean by mapping cardinalities Explain various types of cardinalities.
When should we use weak. entities while modelling a database?
3. Given the relational schema:
sales_person name, start-yr, dept_no)
trip trip_id, from_city, to_city, departure_date, return_date)
expense (trip_id, account_no, amount) dept (dept_no, dept_name)
Write the relational algebra for the following queries:
Find the most expensive and least expensive trip.
Find the average expenditure of trips involving the amount more than RS 2,000.
Find the department of the person spending maximum amount on a trip.
Find the person going maximum number of times on trips.
Explain the rules for decomposing a relation.
Given the relation schema and a functional dependency
FD=
B
C
What is candidate key?
What normal form is it in Explain.
What is log-based recovery How is it different from shadow paging?
How can a non-serializable schedule be changed into a serializable schedule?
Discuss the atomicity and concurrency in databases.
What is database protection How is it achieved? What are its advantages?
7. Construct an ER diagram for a Library Management System keeping record of the following information:
Books
Members
Fine
Publisher
Book Bank
List all the assumptions you make about the database and mapping constraints.
8. Write short notes on any two of the following:
Generalization
Cascading Schedules
View
What are the different subsystems in DBMS architecture?
What do you mean by mapping cardinalities Explain various types of cardinalities.
When should we use weak. entities while modelling a database?
3. Given the relational schema:
sales_person name, start-yr, dept_no)
trip trip_id, from_city, to_city, departure_date, return_date)
expense (trip_id, account_no, amount) dept (dept_no, dept_name)
Write the relational algebra for the following queries:
Find the most expensive and least expensive trip.
Find the average expenditure of trips involving the amount more than RS 2,000.
Find the department of the person spending maximum amount on a trip.
Find the person going maximum number of times on trips.
Explain the rules for decomposing a relation.
Given the relation schema and a functional dependency
FD=
B
C
What is candidate key?
What normal form is it in Explain.
What is log-based recovery How is it different from shadow paging?
How can a non-serializable schedule be changed into a serializable schedule?
Discuss the atomicity and concurrency in databases.
What is database protection How is it achieved? What are its advantages?
7. Construct an ER diagram for a Library Management System keeping record of the following information:
Books
Members
Fine
Publisher
Book Bank
List all the assumptions you make about the database and mapping constraints.
8. Write short notes on any two of the following:
Generalization
Cascading Schedules
View
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
- Advanced Computer Architecture
- Artificial Intelligence
- Computer Architecture
- Computer Networks
- Computer Organisations
- Cryptography And Network Security
- Data Structure
- Data Warehousing And Mining
- Database Management System
- Design and Analysis of Algorithm
- Digital Image Processing
- Discrete Maths Structure
- E-Business
- Formal Language And Automata
- Logic Design
- Microprocessor
- Mobile Computing
- Object Oriented Programming
- Operating Systems
- Parallel Algorithms
- Pattern Recognition
- Principles of Programming Lang.
- Real Time Systems
- Software Engineering
- Software Quality Engineering
- Software Reusability
- System Programming And Compiler Design
- Theory Of Computation
- Unix Internals And Shell Programming
- Web Technology