【紧急求助】:一个数据库ER图及SQL语句的实现,多谢
1。Propose a relatively simple schema design for a school which will need to track students, courses, faculty, and grades. Please state assumptions you made on each entity and relation. (Draw ER diagram)
2。Then write a SQL query to report each student’s average grade under each faculty member. (Write in SQL syntax. See output example blow.)
Example Output:
Faculty Name Student Name Avg. Grade student received on
courses taught by this teacher
John Smith Jane Thompson 92
John Smith Matt London 84
Mary Johnson David Lewis 68
Mary Johnson Jane Thompson 75