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.
Turn In:
Text or Word file submitted to Blackboard
1. Suppose that you are modeling for SEPTA, and that SEPTA wants to keep track of BUS DRIVERS and all of the ROUTES that the bus drivers can be assigned to (they know the route etc). What do you think the connectivity between BUS DRIVER and ROUTE is? Briefly explain why.
2. In keeping track of books in a library, we have identified COPY (a single copy of a book) as being in a Many to One relationship to BOOK. In designing tables, where should the foreign key linking the two tables be put? Explain.
3. 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 FIASCOL and MEDIUS. If you do not know the appropriate connectivity for the relationship (let’s call the relationship IS ABOVE – a FIASCOL IS ABOVE a MEDIUS, a MEDIUS is BELOW a FIASCOL) between these, what questions would you ask in order to determine the connectivity?
4. Our analysts believe that there is a functional dependency Party ® Invitation
Given the data (known to be correct) collected by our clients, shown below, what can you say about the following regarding the possibility of a functional dependency existing?
|
Name |
Party |
Contribution |
Amount |
Invitation |
|
Smith |
Dem |
Y |
$1000 |
Y |
|
Tanaka |
Dem |
Y |
$100,000 |
Y |
|
Harris |
Dem |
N |
$0 |
N |
|
Bush |
Rep |
N |
$0 |
N |