Olto
Rookie

Joined: 11 Nov 2002 Posts: 71
|
Posted: 12/18/04 - 02:48 Post subject: basic database design question...
|
|
|
This may be a shot in the dark, but hopefully someone here will be willing to help. For a gen ed requirement we have to create an entity-relationship diagram (or create in access which would be easier) for this database:
http://classes.nyu.edu/courses/1/C20.0001.007.FA04/content/_875568_1/Logical_design_example.pdf
We only are concerned with page 3. We have to trim it down to as few entities as possible. My idea was to create a table for employee(name, SSN, start date, diploma), job(code, name, level, start date, stop date, min salary, max salary, employees salary, dept code), department(code, name, location), and equipment (with code, purchase date, cost, type). Then another table would be "job assignments" to link the 3 jobs (current, last job, and the job previous to that) from employee to job. And finally an "equipment assignment" table to link the 3 equipment assignments to each employee. However, I keep running into problems (ambiguous joints and many to many relationships). Any help would be greatly appreciated. Thanks!
|
|