create a relational database Model of this information

Database Extra Credit -5 points Name: Professor Student Number 1385 1385 6366 6366 1385 6366 Student First Name Wednesday Addams Wednesday Addams Course Student Last Name Dorm Room Feynman Plato Smith Darwin Newton Smith Physics 101 Logic 101 Economics 310 Pugsley Biology 220 Calculus 101 Economics 200 Pugsley Plainsman 22 Plainsman 22 19 19 Plainsman 22 19 Addams Addams ger ger Pugsley Wednesday Addams Addams ger Here is a flat file of college courses taught by various professors with two students, Wednesday Addams and Pugsley Addams, enrolled in the various classes. Also included are the students' dorms and rooms 1. Break these into the proper tables for a relational database with the necessary unique (primary) keys. One question to resolve is whether student numbers are ever assigned to another student (your choice). Think about separating the entities. Then ask yourself which entities should actually be together in a table. Lay out your tables with column (entity) names and insert the rows (instances) for each. Finally, consider what join tables have to be created to get the classes and dorm assignments made Add in foreign (secondary) keys to join your table elements together so the professors are paired with the proper courses, the students are in the right courses and also in the correct dorms and rooms 2. When finished you should have seven tables, two of those should be join tables