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