Hey everyone! I am a student and am supposed to find some problems with this database design and eventually come up with ways how to fix them. I have listed some problems below that I have found, can someone help me with either fixes or additional problems that you see?

1.) Two tables with same name certification.
2.) The relationship from University to certification needs a foreign key to get to the table.
3.) It doesn’t look like a faculty member can work at more than one university.
4.) The Phone entity needs to be connected somehow to the database.
5.) No foreign key between Sponsor and Faculty_proj.
6.) No foreign key from Company to Conference.

Attachments Faculty_DB.gif 93.7 KB
6 Years
Discussion Span
Last Post by debasisdas

At first look this design seems to be too critical.

Some tables can be merged.

Needs dedicated time to provide a solution.


Yes. I agree. Other than all the foreign keys missing I am not seeing much else. This is pretty confusing and should probably be explained, and fixed, in class.


The entities are too tightly coupled , it will be a real pain if any changes are required to implement in future.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.