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 | June, 2015 | |
| City, State | new delhi, |
Question Paper
"What are the characteristics of database management system? Explain in brief.
Explain primary indexing, secondary indexing and "clustering.
Differentiate between the following In brief:
Simple vs Composite attribute
Simple vs Multi-valued attribute
What are the different relational algebra operations? Explain each.
What is participation constraint? Explain total and partial participation constraints.
What do you mean by normalization Explain 1NF, 2NF and BCNF and 3NF.
What are equivalence sets of functional dependencies Verify whether the following two sets of functional dependencies are equivalent or not:
F B AC
G B A
What do you mean by schedule Explain conflict serializability and view serializability.
What is two-phase locking? Explain static and dynamic two-phase locking.
Two-phase scheduler is subject to deadlock. Explain with example.
What is tuple calculus? How is it different from domain calculus?
"Withdraw Rs 1,000 from a saving account using ATM." How can ACID properties be ensured for the above transaction Explain.
OR
Write short notes on any two of the following:
Fully Functional Dependency
Derived Attributes
Database Recovery
7. Considering the banking enterprise system, draw the complete ER diagram.
Explain primary indexing, secondary indexing and "clustering.
Differentiate between the following In brief:
Simple vs Composite attribute
Simple vs Multi-valued attribute
What are the different relational algebra operations? Explain each.
What is participation constraint? Explain total and partial participation constraints.
What do you mean by normalization Explain 1NF, 2NF and BCNF and 3NF.
What are equivalence sets of functional dependencies Verify whether the following two sets of functional dependencies are equivalent or not:
F B AC
G B A
What do you mean by schedule Explain conflict serializability and view serializability.
What is two-phase locking? Explain static and dynamic two-phase locking.
Two-phase scheduler is subject to deadlock. Explain with example.
What is tuple calculus? How is it different from domain calculus?
"Withdraw Rs 1,000 from a saving account using ATM." How can ACID properties be ensured for the above transaction Explain.
OR
Write short notes on any two of the following:
Fully Functional Dependency
Derived Attributes
Database Recovery
7. Considering the banking enterprise system, draw the complete ER diagram.
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