Hello learners In this article we are going to discuss NPTEL Introduction to Database Systems Assignment 1 Answers. All the Answers provided below to help the students as a reference, You must submit your assignment with your own knowledge and use this article as reference only.
About the course:-
Databases are the backbone of almost all the digital services and e-governance solutions. Modern businesses and financial systems heavily depend on databases systems and transaction processing for their successful operation. This course introduces the students to the various theoretical and practical principles involved in the design and use of databases systems with the help of database management systems (DBMS) and the SQL Standard
NPTEL Introduction to Database Systems Assignment 1 Answers 2024:
1. Storing data and meta-data separately makes RDBMS general-purpose and flexible.
Answer :- a
2. “Data Model” is nothing but a data structure where data is stored.
Answer :- b
3. An RDBMS can typically manage more than one database.
Answer :- a
4. A database can not be created unless an RDBMS is used.
Answer :- b
5. Relational data model provides the concept of “Entity”.
Answer :- b
6. ER Model is NOT a representational-level data model.
Answer :- a
7. Three-schema architecture is part of the Entity-Relationship Data Model.
Answer :- b
8. Transaction Manager takes control of the system when it recovers after a failure.
Answer :- b
9. People who make use of application programs need to know the logical schema of the database completely.
Answer :- b
10. People who develop the application programs need not know the physical schema of the database.
Answer :- b
11. People who develop the application programs need to know the logical schema of the database completely.
Answer :- a
12. A “log” in the RDBMS keeps track of update operations of all transactions.
Answer :- a
13. Complete the sentence: Logical Data Independence is the ability to modify…
Answer :- b
14. Complete the sentence: Physical Data Independence is the ability to modify…
Answer :- a
15. An Entity-Relationship (ER) Model represents:
Answer :- a
16. A person who develops a high-level language program that meets a functional requirement of the database is usually called:
Answer :- b
17. The people playing the following role need NOT have an understanding of the complete logical schema of the database:
Answer :- a
18. Consider the following statements:
S1: A view usually provides access to a part of the data relevant to a group of users
S2: A view usually provides access to the complete database
S3: The feature of defining views is to be compulsorily provided by the RDBMS
S4: The feature of defining views may not be provided by an RDBMS.
Answer :- b
19. Consider the following sets:
M = { p: RDBMS Run-time System; q: Transaction Manager; r: Buffer Manager;
s: Recovery Manager}
F = { w: Transaction Error Handling; x: Concurrency Control; y: Query Execution; z: Paging}
What is the most appropriate matching between sets M and F?
Answer :- a
