Design Database for Rate My Professor

[cooperbocko]

A team of up to four people will design the database tables and the relationships between them for the Rate My Professor database. Please maintain a document of your contributions for points.

Be sure to maintain proper naming conventions when creating the tables.

Also, do not close the ticket on your own, mark it as ready for review.

[Ig0rGon]

Would this database include a 'Courses' entity?

[cooperbocko]

Whatever you think is necessary. We will decide later what we do and do not need so for now you can add it.

[Ig0rGon]

Check this out, and lmk about it.

[cooperbocko]

Could you do it in the google draw file so it is readily available and in the same format as well?

[Ig0rGon]

How's this one?

[Ig0rGon]

Here is the file for it:

RateMyProfessorDatabase.pdf

[cooperbocko]

You should have the column names as camel case and that still isn't the same kind of format. Let me know if you need the link to the draw file for it.

[ishaanchitre12]

Created a rough design of the Professor, Review, and Course tables for the Rate My Professor database. Yet to include more complex relationships.

[ishaanchitre12]

sorry, accidentally closed issue

[ishaanchitre12]

created additional department table in RMP database and formed several one-to-many relationships

[nickstoni]

Design Database for Rate My Professor.pdf I created a design for the Rate My Professor database. Please let me know if you need it in another format or by using another application.

[nickstoni]

Sorry, I accidentally closed the issue, but it is now set to "Ready for Review."

[cooperbocko]

This looks great so far! Could you do it in the google draw file so that it can be seen by everyone and edited by other people? https://docs.google.com/drawings/d/1LibWQxkO7TgwMY0GElahWZwgi-vY2eCZxD1nApIZVyk/edit

I appreciate you creating it in a class diagram, but I would like to see more of a table design that includes the foreign keys to other tables as well as intermediary tables between them. I think that style will translate better to actual code and not confuse anyone that isn't familiar with this style.

[nickstoni]

Transferred the design to a table format in Google Draw. https://docs.google.com/drawings/d/1-GeyXIeD3RIDAk65fBYVaM8BbsGEG91OUxUsg4-dioo/edit?usp=sharing

[cooperbocko]

For the many to many relationships, could you add intermediary tables since we will needs those for the db. Also if you wanna paste it here https://docs.google.com/drawings/d/1LibWQxkO7TgwMY0GElahWZwgi-vY2eCZxD1nApIZVyk/edit

[nickstoni]

Updated the RMP Database to include additional intermediary tables. Also copied the database to the link. https://docs.google.com/drawings/d/1LibWQxkO7TgwMY0GElahWZwgi-vY2eCZxD1nApIZVyk/edit