Question
Design a generalization /specialization hierarchy for a University Admission System. The University has many programmes, each programme has a specific duration. Registration into a programme requires students to register for many subjects of that Programme. The eligible students can take fresh admission or can re-register in the courses by paying the requisite fee.
Justify your placement of attributes at each level of the hierarchy. Convert the diagram into tables with integrity constraints for each table.
Explain the multi-valued dependency and Join-Dependency with the help of an example of each. Explain the 4th Normal Form and 5th Normal Form with the help of an example of each.
Explain the term Serializability with the help of an example. Explain the two-phase locking protocol in the context of concurrent transactions. Also, explain the timestamp-based protocols for concurrent transactions.
Explain the following with the help of an example.
(a) Stored Procedures and Triggers
(b) Embedded SQL
What are Multimedia databases? What are the challenges in designing multi-media databases? Also, explain the requirements of a Geographical Information System and features of Genome databases.
What is access control in the context of DBMS? What are the different access permissions that can be granted using SQL? Explain with the help of an example of each. Explain the concept of Statistical database security with the help of an example.
Explain the transaction management and indexing in PostgreSQL.
Briefly explain the architecture of the Oracle Database Management System
IGNOU Doubts & Queries
Click to Contact Us
Call - 9199852182 Call - 9852900088 myabhasolutions@gmail.com WhatsApp - 9852900088