THE EMPLOYEE AND DEPARTMENT DATA IN THE QUESTION IS JUST FOR EXAMPLE.

1. Define an (extended) Entity-Relationship model for your data from hw1. Following the requirements for entities, divide up the attributes from assignment 1 into appropriate entities and describe their characteristics as follows:

o Indicate which attribute(s) is the key. That is, which attribute(s) uniquely identify instances of each entity.

1. If there is more than one candidate key, indicate this

o If any attributes are composite, separate them into the appropriate "sub-attributes", continuing until you are left with only attributes that cannot be broken down further.

1. If any of these composite attributes is represented as a single data value on your website, like if it is put into one column of a table there, explain why the components of the attribute may need to be accessed separately.

o For each attribute, indicate whether it can be null or not

o If any attributes are multivalued or derived from other attributes, indicate this.

o See if you have at least 3 entities. If you do not, go back to your website to get more data until you do (include any new references). Do not forcibly split one entity into two entities just to meet the requirement. You will be penalized if your entities are not chosen well.

2. Describe each relationship among your entities. Describe the cardinality as well as the participation of each entity involved in each relationship.

3. Write 6 queries, but in plain English (no SQL yet)

o Each query will result in a table of data show a sample answer using data from the website

o At least 4 of the queries should include values from or based on data from 2 or more entities

o Examples from the Company example in Elmasri:

1. Get the first, middle and last name of employees who do not have a supervisor

Answer is the single row James, E, Borg

2. Get the name of each department and the number of employees in each department uses data from both Department and Employee entities, with the NUM_EMPS attribute being an example of a derived attribute

Answer is 3 rows:

DNAME	NUM_EMPS
Headquarters	1
Administration	3
Research	4

HOW DO I DO THIS?

HW 1 is below for reference:

No.	Team Name	Points Per Game	Total Yards Per Game
1.	Baltimore Ravens	33.2	407.6
2.	San Francisco 49ers	29.9	381.1
3.	New Orleans Saints	28.6	373.9
4.	Tampa Bay Buccaneers	28.6	397.9
5.	Kansas City Chiefs	28.2	379.2
6.	Dallas Cowboys	27.1	431.5
7.	New England Patriots	26.2	354.0
8.	Minnesota Vikings	25.4	353.5
9.	Seattle Seahawks	25.3	374.4
10.	Tennessee Titans	25.1	362.8
11.	Los Angeles Rams	24.6	374.9
12.	Philadelphia Eagles	24.1	360.8
13.	Atlanta Falcons	23.8	379.7
14.	Houston Texans	23.6	362.0
15.	Green Bay Packers	23.5	345.5