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 | June, 2016 | |
| City, State | new delhi, |
Question Paper
An online book database maintains the details such as ISBN, title, price, year of publishing, number of pages, author, publisher of various textbooks, language books and novels. The user can view the details of various authors and publishers. The database also maintains the details of the ratings and feedbacks of other authors about a particular book. The ratings of the book are displayed along with other details of the book. Design an ERD for the Online Book Database. Assume suitable attributes for the entities and mark the key attribute in the ERD.
What are distributed databases Describe the structure of distributed databases. Describe the issues related to storing a relation in the distributed database.
Write short notes on the following:
Functional Dependency
Multivalued Dependency
Remote Procedure Call
Object Oriented System
Object Linking and Embedding
What is a Knowledge Base System Describe the four types of Knowledge Representation Schemes.
What are the five main differences between a file processing system and a DBMS?
Consider the two sets of FDs for the relation R E).
A B,AB C,D AC,D E
A BC, D AE
Are they equivalent? Justify your answer.
Design Semantic Net Representation for the following facts
"Elephants are mammals. They are large in size and have a long trunk. Their ears are large. Elephants like bananas. Appu is an elephant but Appu likes apples."
Describe the three-layer architecture of DBMS.
Define 3NF and BCNF with examples.
Consider the following relational schema: Courses Cname)
Students (Rollno, Sname, Age, Year)
Registered for Rollno)
Write the SQL Queries for
Find the age and year of the youngest student in each year.
Display the list of students course-wise.
Display the list of students not registered for any course.
Describe Client-Server Architecture and its advantages.
What are Keys Differentiate between Candidate, Primary and Foreign keys with the help of suitable examples.
What is ISAM How is overflow of records handled in ISAM
What are distributed databases Describe the structure of distributed databases. Describe the issues related to storing a relation in the distributed database.
Write short notes on the following:
Functional Dependency
Multivalued Dependency
Remote Procedure Call
Object Oriented System
Object Linking and Embedding
What is a Knowledge Base System Describe the four types of Knowledge Representation Schemes.
What are the five main differences between a file processing system and a DBMS?
Consider the two sets of FDs for the relation R E).
A B,AB C,D AC,D E
A BC, D AE
Are they equivalent? Justify your answer.
Design Semantic Net Representation for the following facts
"Elephants are mammals. They are large in size and have a long trunk. Their ears are large. Elephants like bananas. Appu is an elephant but Appu likes apples."
Describe the three-layer architecture of DBMS.
Define 3NF and BCNF with examples.
Consider the following relational schema: Courses Cname)
Students (Rollno, Sname, Age, Year)
Registered for Rollno)
Write the SQL Queries for
Find the age and year of the youngest student in each year.
Display the list of students course-wise.
Display the list of students not registered for any course.
Describe Client-Server Architecture and its advantages.
What are Keys Differentiate between Candidate, Primary and Foreign keys with the help of suitable examples.
What is ISAM How is overflow of records handled in ISAM
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