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