I need help on how to create a college database by inserting the codes into the query. I will need the following codes f

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
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

Post by answerhappygod »

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)
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply