CSC 240               Spring 2006                    Assignment 1 – Data Modeling

 

Assigned: 02/08/06

Due: Start of Class on 02/13/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 WINGDOODLE and FRAZZLE. 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 CONTAINS – so a WINGDOODLE CONTAINS (a) FRAZZLE(s), and a FRAZZLE IS CONTAINED BY (a) WINGDOODLE(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 Price à BarCode  in a supermarket? Why or why not?