3. Get the name and the age of the youngest worker who got A [40] a. Hints: since the age and grade information are in two different tables (which two?), you'd have to first join the two. Use where clause to join them as discussed in class. b. Then add a clause to the where clause to print only those rows that contain grade 'a'. c. Once you have the workers who got 'a', you can select the youngest following approach similar to question 2.

5. Find the workers from the birthcity that includes 'city' [20]. a. Hint: use the expression "like"

First Choice: Design a Simple Database using Ms. Access 2013-365 (any DATABASE of your choice) The Database (your project) must include, using: Tables (1 to 2 tables) The tables are the backbone and the storage container of the data entered into the database. If the tables are not set up correctly, with the correct relationships, then the database may be slow, give you the wrong results or not react the way you expect. So, take a bit of time when setting up your tables. Design view Design view gives you a more detailed view of the structure of the form. You can see the Header, Detail, and Footer sections for the form. You cannot see the underlying data while you are making design changes; however, there are certain tasks you can perform more easily in Design view than in Layout view. Datasheet view In the Open dialog box, select the database that you want to open, and then click Open. On the Create tab, in the Tables group, click Table. A new table is inserted in the database and the table opens in Datasheet view.. The Lookup Wizard The Lookup Wizard establishes a relationship between tables. It creates a foreign key that refers back to the primary key of another.

Second Choice: Create PDF or Word file (1-2 maximum Pages) about: the difference between Database management system and Database

Question #2. Consider the three transactions T1, T2, and 13, and the schedules $5 and S6 given below. Show all conflicts and draw the serializability (precedence) graphs for $5 and 56, and state whether each schedule is serializable or not. If a schedule is serializable, write down the equivalent serial schedule(s).

Question #3. Write a PHP script for each of the following questions: (a) Suppose you are given an array color with some values. Write a PHP script to get the first element of the array.

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

BACKGROUND You are provided with a conceptual and logical data model based on the narrative in Assignment 1A. They are included in the appendix of this document.

5. Create an ERD for a chain of Candy Stores. They will want to track customer, product, employee, store location, sale amount, discount type (if any), discount amount (if any). Be sure to include cardinality via crow's feet as well as identified PK and FK for each table. No other sample fields are necessary.

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