III. (10 pts) Database life cycle (DBLC): Show, for each one of the 10 tasks (on the
left), the id (number) of the corresponding parent activity (on the right).
Tasks
Activities
a) Data analysis and requirements
1 Conceptual Design
b) ER modeling
2 Logical Design
c) Distributed database design
3 Physical Design
d) Defining tables, attributes, primary
and foreign keys
e) Table normalization
f) Defining indexes and views
g) Estimating data storage requirements
h) Installing the DBMS
i) Assign access rights to the tables
j) Modifying the physical design
4 Implementation and Loading
5 Testing & Evaluation
IV. For the following questions about database transactions, give ALL true answers.
a) (6 pts) Database transactions are executed concurrently (interleaved) for the
purpose of:
1. Processing efficiency (maximize system throughput, minimize response
time...)
2. Enforcing security
3. Ensuring data integrity
