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).