4. List which worker (by name) has worked for which project (by name). Sort the list in the ascending order of the age of the worker. [25]

A-2 Keys (10 points) (i) [5pt] Find all the candidate keys of the Relation R(ABCDE) with FD's: DC, CE →A, DA, and AE → D (ii) [5pt] Determine all the candidate and superkeys of the relation R(ABCDEF) with FD's: AEF → C, BF→ C, EF→ D, and ACDE - F

A-3 Minimal Cover (10 points) [10 pt] Find all minimal covers for the following set F of functional dependencies. XZ, XYZ, Z- UT, ZUT, ZW → XY, WT → Z Show your working clearly. Points will be deducted if you do not show the extraneous attributes, and their elimination.

A-4 Equivalence (15 points) [15pt] Consider the following set of F.Ds. Determine if FD1 is equivalent to FD2 or to FD3: FD1: {BC->D, ACD->B, CG->B, CG->D, AB->C, C->A,D->E,BE->C,D->G,CE->A,CE->G} FD2: {AB->C,C->A,BC->D,CD->B,D->E,D->G,BE->C,CG->D} FD3: [AB->C,C->A,D->G,BE->C,CG->D,CE->G,BC->D,CD->B,D->E} You must show closure of each LHS attributes on the left hand side of each FD_i where i = {1,2,3} via going through the other FD set. Then establish the equivalence.

1. Evaluate the ER Diagram below. Based on your analysis, document five business rules.

2. Analyze the dependencies that exist in this table design and normalize it to the 3rd normal form. Note: Please provide the relation dependency diagram with annotations, as well as the final 3NF relations.

8. Create the DDL for the creation of a Customer Table with 8 columns including data types, an identity column that increments, along with a primary key, be sure to allow the data structure to support a type 2 slowly changing dimension.

Module 4 Assessment Part 3 Purpose In this assessment, you will practice using a variety of query functionality to include using functions, calculations, and parameters. You will also create an action query to update data in a table to demonstrate other ways to manipulate data using queries in Access.

9. Write a SELECT statement based on the tables in the third normal form from your response to Question 2. Include at least 1 join and 1 filter clause.

Module 4 Assessment Part 1 Purpose You will practice using SQL in the Access environment. You will examine data from a sample database using simple, single table select queries.