I need help on how to create a college database by inserting the
codes into the query. I will need the following codes for MySQL
Server!!! Please include an image of the completed database
project, if possible!!
With the Deliverables:
Document “Relationship report” showing Table names used in the
database Table relationships Keys Table Fields names Field Data
types Constraints
SQL (code) to create the following:
Faculty contact list Course Book List by Semester Course
Schedule by semester Student Grade Report by semester Faculty
Semester grade report (number of A's, B's, C's, D's, F's per
course) Student GPA report by semester and overall (semester and
cumulative) Mailing list for Diplomas Student Demographics over
time (how many were under 18 last year, this year)
Sample query output (at least 10 entries per query):
Faculty contact list Course Book List by Semester Course
Schedule by semester Student Grade Report by semester Faculty
Semester grade report (number of A's, B's, C's, D's, F's per
course) Student GPA report by semester and overall (semester and
cumulative) Mailing list for Diplomas Student Demographics over
time (how many were under 18 last year, this year)
I need help on how to create a college database by inserting the codes into the query. I will need the following codes f
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
I need help on how to create a college database by inserting the codes into the query. I will need the following codes f
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!