Question

Using the notation exemplified in following question , list a set of tables and attributes (and identify keys) to represent the following data:

In a very simple school database, students have a student ID and a name. Each student has only one advisor (who has an ID and a name). Each advisor advises many students. Students take many courses. Each course has an ID, a name, and the number of credits. The database also stores when a student took a course (the semester/year) and his/her final grade for that course (on that semester).

Answer 1

Entities are - Students, CourseList, Advisor and CourseSelection.

Step-by-step explanation:

The database is structure is designed using Crow Foot Database Notation as attached