Exam Details
| Subject | Advanced Database Design | |
| 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
Consider the following situation:
A subject can be taught by several' teachers. The subject has defined textbooks (may be one or more). The following represents this information
<img src='./qimages/14278-1a.jpg'>
Perform the following tasks for the above:
Represent the data shown above in a relation Course_Teacher_Text (Course, Teacher, Text).
Identify the FDs and MVDs in the relation created as above. Also identify the primary key.
Normalise the relation into 4NF.
Show that the normalisation of relations as above will result in lossless decomposition.
Consider the following relations:
Student (enrolmentno, name, programme) Result (enrolmentno, subjectcode, marks)
Consider the query on these relations
"List the enrolment number, name, subject code and marks of a student whose enrolment number is "120000111"."
Represent the query using SQL.
Convert the SQL query into equivalent relational algebraic query.
Draw the query tree for the above relational algebraic query.
Using the query tree, transform the relation algebraic query to an equivalent relation algebraic query, which may reduce the query evaluation cost.
Differentiate between object relational database management system and object oriented database management system.
What is a star schema in the context of a data warehouse? Explain with the help of an example.
Explain the use of JDBC with the help of an example. Compare JDBC with ODBC.
Explain the data integrity and triggers in Oracle database management system.
A University has many Professors. Some of these Professors are full time employees, whereas some of them are visiting faculties. Every Professor teaches one or more courses. University stores the name, qualification and experience of every Professor. In case the Professor is a full time Professor his/her date of employment is stored. In case the Professor is a visiting Professor his/her host institution's name is recorded. Every course of the University has a course name, credits and course code.
Draw an EER diagram for the University as defined above.
Convert the EER diagram to equivalent relations having proper keys and constraints.
Explain any two security failures that are possible in a database system. What is meant by table access control in the context of database security? Explain two SQL commands that can be used for access control with the help of examples.
List any four transaction features of PostgreSQL. management
Consider the following transactions:
Tl: Transfer Rs 5,000 from Account A to Account B. You may assume that the required amount is available in Account A.
T2: Add an amount Rs 1,000 as interest in both the accounts -Account A and Account B.
Write the pseudocode of the two transactions. You must assume read-before-write protocol.
What are the different problems that can occur if both the transactions are executed concurrently?
Rewrite the pseudocode of transactions including Lock and Unlock statements to ensure that the transactions execute without any concurrency related problem.
What is Data Mining Why is it useful What is meant by classification in data mining? Explain with the help of an example.
List the features of the following database models:
Mobile databases
Multimedia databases
Explain the utility of XML with the help of an XML document that shows the list of customers of an organisation. You need to store customer name, current address and one or more phone numbers for each customer. Create the customer list with at least two customers. Also create the DTD that verifies the created XML document.
What is meant by the term in the
context of Database Management System
Why is it used?
Consider a student database:
Student (enrolmentno, name, programme)
Course (course_code, course_name)
Registration (enrolmentno, course_code)
Create a view for a student whose
registration number is "101" and shows the
list of all the courses registered by him/her.
The list should show the course_code and
course_name registered by the student
whose enrolment number is "101".
Define the following giving their purpose:
Object definition language
Semi-structured data
Data Mart
5. Explain each of the following with the help of an example/diagram, if needed:
Knowledge database
Data Dictionary
Data Replication in distributed database
Properties of transactions
Checkpoints in the context of database recovery
A subject can be taught by several' teachers. The subject has defined textbooks (may be one or more). The following represents this information
<img src='./qimages/14278-1a.jpg'>
Perform the following tasks for the above:
Represent the data shown above in a relation Course_Teacher_Text (Course, Teacher, Text).
Identify the FDs and MVDs in the relation created as above. Also identify the primary key.
Normalise the relation into 4NF.
Show that the normalisation of relations as above will result in lossless decomposition.
Consider the following relations:
Student (enrolmentno, name, programme) Result (enrolmentno, subjectcode, marks)
Consider the query on these relations
"List the enrolment number, name, subject code and marks of a student whose enrolment number is "120000111"."
Represent the query using SQL.
Convert the SQL query into equivalent relational algebraic query.
Draw the query tree for the above relational algebraic query.
Using the query tree, transform the relation algebraic query to an equivalent relation algebraic query, which may reduce the query evaluation cost.
Differentiate between object relational database management system and object oriented database management system.
What is a star schema in the context of a data warehouse? Explain with the help of an example.
Explain the use of JDBC with the help of an example. Compare JDBC with ODBC.
Explain the data integrity and triggers in Oracle database management system.
A University has many Professors. Some of these Professors are full time employees, whereas some of them are visiting faculties. Every Professor teaches one or more courses. University stores the name, qualification and experience of every Professor. In case the Professor is a full time Professor his/her date of employment is stored. In case the Professor is a visiting Professor his/her host institution's name is recorded. Every course of the University has a course name, credits and course code.
Draw an EER diagram for the University as defined above.
Convert the EER diagram to equivalent relations having proper keys and constraints.
Explain any two security failures that are possible in a database system. What is meant by table access control in the context of database security? Explain two SQL commands that can be used for access control with the help of examples.
List any four transaction features of PostgreSQL. management
Consider the following transactions:
Tl: Transfer Rs 5,000 from Account A to Account B. You may assume that the required amount is available in Account A.
T2: Add an amount Rs 1,000 as interest in both the accounts -Account A and Account B.
Write the pseudocode of the two transactions. You must assume read-before-write protocol.
What are the different problems that can occur if both the transactions are executed concurrently?
Rewrite the pseudocode of transactions including Lock and Unlock statements to ensure that the transactions execute without any concurrency related problem.
What is Data Mining Why is it useful What is meant by classification in data mining? Explain with the help of an example.
List the features of the following database models:
Mobile databases
Multimedia databases
Explain the utility of XML with the help of an XML document that shows the list of customers of an organisation. You need to store customer name, current address and one or more phone numbers for each customer. Create the customer list with at least two customers. Also create the DTD that verifies the created XML document.
What is meant by the term in the
context of Database Management System
Why is it used?
Consider a student database:
Student (enrolmentno, name, programme)
Course (course_code, course_name)
Registration (enrolmentno, course_code)
Create a view for a student whose
registration number is "101" and shows the
list of all the courses registered by him/her.
The list should show the course_code and
course_name registered by the student
whose enrolment number is "101".
Define the following giving their purpose:
Object definition language
Semi-structured data
Data Mart
5. Explain each of the following with the help of an example/diagram, if needed:
Knowledge database
Data Dictionary
Data Replication in distributed database
Properties of transactions
Checkpoints in the context of database recovery
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