CSC 310 Database Design Examen 2023

Extrait du sujet

1. SECTION A: Answer all Questions. Write the letter of the correct Answer

   1.

   Designers use which of the following to tune the performance of systems to support timecritical operations? a) Denormalization b) Redundant optimization c) Optimization d) Realization

2. 2.

   In the schema (dept_name, size) we have relations total_inst_2007, total_inst_2008. Which dependency have led to this relation? a) Dept_name, year->size b) Year->size c) Dept_name>size d) Size->year