Database Management Systems Quiz

DBMS provides data abstraction, data independence, and data manipulation languages, while file systems lack these features. The database system architecture includes centralized, client-server, parallel, and distributed architectures.

An E-R diagram is an entity-relationship diagram used to visually represent entities and their relationships in a database. Its components include entities, attributes, and relationships. To reduce an E-R diagram into tables, entities are represented as tables and relationships are represented using foreign keys.

1NF (First Normal Form) ensures atomicity of values, 2NF (Second Normal Form) deals with partial dependencies, 3NF (Third Normal Form) addresses transitive dependencies, and BCNF (Boyce-Codd Normal Form) eliminates non-trivial functional dependencies on candidate keys.

<p>The measures of query cost include disk I/O, CPU time, and network traffic. Selection and join operations are used to retrieve specific data from tables based on specified conditions and to combine data from multiple tables, respectively.</p> Signup and view all the answers

<p>The basic operations in relational algebra include selection, projection, union, set difference, Cartesian product, and join. Relational calculus, on the other hand, is a non-operational language that specifies what to retrieve, but not how to retrieve it.</p> Signup and view all the answers