CSC 240              Fall 2006              Assignment 1 – Data Modeling

 

Assigned: 09/20/06

Due: Start of Class on 09/25/06

 

This is an individual assignment.  You may ask teammates, 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 PAPAZA and MADRAT. If you do not know the appropriate connectivity for the relationship between these, what questions would you ask in order to determine the connectivity? (let’s call the relationship OWNS – so a PAPAZA OWNS (a) MADRAT (s), and a MADRAT IS OWNED BY (a) PAPAZA (s)) (You cannot ask “what is the connectivity?” or any variation. You are asking “lay people” involved in the operation of the business.)

 

2.        Generally, is there a functional dependency StudentLastName ® Major ? Why or why not?