There are four questions in this assignment, which carries 80 marks. Rest 20 marks are for viva voce. You may use illustrations and diagrams to enhance the explanations. Please go through the guidelines regarding assignments given in the Programme Guide for the format of the presentation. The answer to each part of the question should be confined to about 300 words. Make suitable assumption, if any.
Question 1: (Covers Block 1)
(a) What are the limitations of file-based systems? How does a database approach resolve those limitations? Also, explain the physical architecture of a database management system (DBMS).
(b) Explain the following terms in the context of a relational model with the help of one example of each:
(i) Key constraints
(ii) Domain constraints
(iii) Candidate key
(iv) Select operation
(v) Project Operation
(vi) Equijoin Operation
(vii) Set Difference operation
(viii) Referential Integrity constraint
(c) A departmental store maintains the inventory of all the items that it sells using a database system. In addition, this system is used for keeping a record of the sales of items to its registered customers. This database is used to find the following details by the staff of the departmental store:
- List of the items that are out of stock.
- List of customers and the items purchased by them.
- List of all the items in the store.
Draw an ER diagram for the departmental store. Specify key attributes and constraints on each entity type and on each relationship type. Note any unspecified requirement and make appropriate assumptions to make the specification complete.
(d) Design normalised tables in 3NF for the ER diagram drawn in part (c), with the required integrity constraints.
(e) Explain the role of the primary index in a database system. Also, compare the primary indexes with the secondary indexes. What are clustering Indexes? Explain with the help of an example
(a) File-based systems have several limitations. Firstly, they lead to data redundancy, as the same data may be stored in multiple files, increasing storage requirements and causing inconsistency. Secondly, file-based systems lack data integrity and enforcement of constraints, resulting in potential errors and unreliable information. Thirdly, accessing data can be inefficient because there is no standard query mechanism, and retrieving specific information often requires writing complex programs. Moreover, file-based systems do not support concurrent access effectively, leading to problems with synchronization and consistency when multiple users attempt to modify data simultaneously. Backup and recovery are also complicated in file-based systems, making data management cumbersome. The database approach resolves these limitations by centralizing data management through a Database Management _________ ________ ____ ______ _________ ____ _________ _____ _____ _____.
______ ______ __________ _____ _________ _________ ________.
________ __________ ___ ______ _________ ______ ______.
_________ __________ ____ _____ ______ __________ _________ _______ _________ ___ _______ ___.
_____ __________ __________ _______ _______ ___ __________ ____.
_____ _______ ________ ____ ________ _____ __________ _______ ________.
_____ _________ ________ __________ _____ _____ _______ ________ ______ __________ ___.
___ ________ _______ _________ _____ ________ _______ _____ ____.
________ ________ ________ __________ __________ ______ _______ _____.
_______ ____ _________ ________ ________ ________ _____.
______ ___ ____ _____ ________ __________ __________ _____ ________.
_______ ______ ______ _____ _____ __________ ________ ____ ________ _________.
______ ________ _________ _______ ______ ____ __________ ___ _____.
_______ ________ __________ _________ ___ ____ ________ __________ ______ ________ _________.
_____ _______ ____ _________ _____ _____.
______ ________ ________ ____ _________ _____ ________ ________ __________ __________.
_________ ________ _____ _________ _____.
____ ______ ________ ______ _______ ______ ___ _________ ____ ________ ________.
___ ____ ___ ____ ________ _______.
_____ _____ ____ ____ ______ ____ _________ _____.
_____ ___ _______ __________ _________ _______ __________ ______ ____ _____ _________.
___ ______ __________ _______ _______ __________ _______ ____ ______.
________ ________ ___ ______ ____ _________ ______ _____ ______.
_________ ________ __________ _________ _________ _________.
__________ ___ ________ __________ _______ ________ ______ ________.
________ ____ _________ ____ _______ __________ __________.
____ ______ ________ ________ ________ ___ ____ ________ _______ ________ __________ _________.
_______ ________ ____ ______ ________ __________ ____ ________ ____ ___ _______ ______.
__________ __________ ___ _______ __________ ______.
__________ ________ _________ __________ _______ _____ __________ _________ __________ _________ ____ _____.
__________ ________ ___ ___ ______ ________.
__________ _________ _____ ____ _____ ______ __________ ______ _______ _________.
__________ __________ ____ __________ __________ ____ _______ _______ ____ __________ __________.
________ ______ _________ ___ __________ __________ ______.
_______ __________ ___ _________ _________ ___ ___.
__________ ________ ___ ______ ____ _________ _____ _____ ___.
___ _________ __________ _____ __________.
______ ____ ____ __________ ____ _________ _______ ___ ___ _____ _____.
________ ______ ________ ________ _____ _____ ____.
__________ ___ _______ ____ ___ ___ ______ _______ _____ ______ ________ ___.
_________ __________ ____ ____ ______ ____ __________ _____ ____ _________ ___ ___.
_____ __________ _____ ___ ______ __________ _______ ___ ______.
_______ __________ ________ _________ _____ ____.
___ ____ ___ ________ __________ ____ ___ ______ ______ ________.
___ ______ ___ ___ ________ __________ _____ ___ ________ _________ ____ _____.
_______ _________ ________ _________ __________ __________ _______.
_____ ______ _____ _____ ___.
______ ___ _______ ______ __________ __________ __________ _______ _______ _________.
_____ _________ __________ _________ _________.
____ _____ ________ ____ ___ _______ _______ __________ ______.
__________ _______ ____ ___ ________ ________ _________ __________ ____.
_________ __________ ______ ______ _______ ______ ___.
____ _______ _____ ________ __________ _________ ________.
__________ _________ ____ ______ _______ _________ ___.
___ ____ ____ ______ ___ _______ ________ _____ _________ _________ ____.
___ ______ ___ ______ _____ ________ ______ ____.
_________ __________ _________ __________ ______ ________ _________ ________ ____ ______ _____.
______ ______ ___ _____ ___ ________.
____ ________ _______ _______ __________ _____ ____ _________ ______.
_________ ____ _________ _________ _______ __________ __________.
___ ______ _____ ________ ____.
________ ______ ________ _______ __________ _____ __________ ____ _______ _________ __________ __________.
_________ _________ ____ __________ _____ _______ _____.
__________ _______ _______ ______ ___ _______ __________ ____.
____ ___ ________ __________ ___ _____ _____ ________ _____.
_____ __________ _________ _____ ______ ______ _____ _______ _____ ________ ____ _________.
__________ _____ ____ _______ ___ ______ _____ ________ ________.
________ ______ _______ ___ _____ _______ ____.
________ _______ ________ ____.
Get Full Answer on WhatsApp