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, 2015
City, State new delhi,


Question Paper

Assume there is the following requirement for a distance learning educational institution:

The institution offers different Post-Graduate, Graduate and Diploma level programmes. The programme delivery is done through local learning centres, using TV and Radio Broadcast. Schedule of programme delivery is sent to all the students at the beginning of each semester. Students registration records are managed by local learning centres.

Design an ER diagram for the system indicating all the entities, attributes, keys and cardinality. Make necessary assumptions wherever required.

Explain three models of database systems. What are the properties of a relation in a Relational model

Explain the following relational algebra operations With suitable examples:

Selection

Projection

Cartesian product

What are the problems of file management system Explain, how does the database system overcome the problems of file management system.

Explain the advantages of object oriented database management system over relational database management system.

Consider the following relations, where the primary keys are underlined:

TRAIN Number, Start_Station,
Dest_Station, Name)

TICKET Boarding_Station,
Dest_Station, T_Number, Class, Fare)

PASSENGER (Name, Address, PNR_No,
Seat_No)

Write the following queries in SQL:

Retrive the names of all the passengers who are going from Delhi to Jaipur by Train number T1001 in AC-2 Class.

Insert a new train with Train number T2002 from Delhi to Mumbai.

Cancel a ticket with PNR_N0 22005567, and passenger name "Ravi".

List all the trains that start from Mumbai with destination Delhi.

List all the passengers' names who are travelling by Train number T2011 and their fare is greater than 1000.

What is distributed database system Explain how data replication is managed/avoided in distributed databases, with an example.

What is integrity constraint? Explain two types of integrity constraints which may be imposed on a relational database.

Explain the role and responsibilities of a database administrator.

Explain frame based knowledge representation. Make the frame representation of a "Doctor".

What is checkpoint? Explain the advantage of using checkpoints in database recovery, with an example.

What is a view? Explain why a view of a table is created. Briefly explain two disadvantages of using view.

What is direct file organisation? Explain the advantages and disadvantages of hashing with the help of an example.

What is functional dependency? Explain with the help of an example and dependency diagram.


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