Question

For this assignment, you should create an Entity Relationship Diagram (ERD) in Visio that shows a many-to-many relationship between DeVry University students and their classes. Since one student can have many classes and each class can have many students, you will need to create an associative entity to store the specific Student_Class data such as grade and attendance. Create the tables as well as the relationships. Don't forget to indicate the Primary Key and Foreign Key in each table. Tables and attributes should be as follows: STUDENTS StudentID Last Name FirstName Address City State Zip CLASSES CourseID Department CourseNumber Instructor Campus YearTerm STUDENT_CLASS (Associative Entity) StudentID CourseID Grade Rating

Answer 1

Solution : Hey, we are not able to make ERD in Microsoft visio software because of its paid version. Moreover, i am providing you the required Crow's Foot ERD for the following given requirement. You can make that in visio yourself.

Note : "pk" stands for primary key and "fk" stands for foreign key. In STUDENT_CLASS table, combined (pk,fk) are showing concatenated primary and foreign keys.