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.