This is an individual assignment. You may ask other class members, and random people (only) the same types of questions I would answer. You must develop your own individual answers.
Task:
Answer the questions below:
1. Suppose you have been assigned to a project, and must develop an E/R diagram for the project. Suppose that you have identified entity (types) of WIDGET and FROOBLE. If you do not know the appropriate connectivity for the relationship (let’s call the relationship CONTAINS – a WIDGET CONTAINS a FROOBLE, a FROOBLE is contained by a WIDGET) between these, what questions would you ask in order to determine the connectivity? (You cannot ask “what is the connectivity?” or any variation. You are asking “lay people” involved in the operation of the business.) (NOTE – this question only concerns connectivity. I’m not interested in questions such as “What is a FROOBLE?”)
2. Our analysts believe that there is a functional dependency Party ® VoteOnSSPrivatization. Given the data collected by our clients, shown below, what can you say about the following regarding the possibility of a functional dependency existing?
|
Politician# |
Party |
VoteOnSSPrivatization |
|
1023 |
Dem |
N |
|
4321 |
Dem |
N |
|
5123 |
Rep |
Y |
|
6109 |
Rep |
Y |
|
1234 |
Dem |
N |
|
5011 |
Rep |
Y |
|
1001 |
Dem |
N |
|
2112 |
Rep |
Y |
|
1111 |
Rep |
Y |
|
9012 |
Dem |
N |