Member Avatar for Micksnothere

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.

Faculty_DB.gif 93.7 KB
  • 2 Contributors
  • 3 Replies
  • 272 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

At first look this design seems to be too critical.

Some tables can be merged.

Needs dedicated time to provide a solution.

Member Avatar for Micksnothere

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.

Member Avatar for debasisdas

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.