SQL codes to create database (codes) and result ERD from pgadmin4 for the following scenario:
Each course may be taught in different classes. So for example one section of Data Management can be taught on Steven campus, another section on the WEB, a third in the DR, and a forth at an industry site (CitiGroup, etc.)
A faculty member may be full time or part time.
A faculty member may teach one or more classes.
Different faculty members may teach different classes of the same course. So for example, Dr. Morabito may teach one on campus course and one Industry course of Data Management.
Each faculty member may decide on the number of exams that may be given and the type of examinations. So the type of exam may be a midterm, quiz, class participation, lab work, or final.
Student grades are given for each type of examination.
Specific textbooks may be assigned to a course. Each book may have one or several authors. For example one book may be authored by another book by Kroenke and Auer.
A student may be enrolled in one or more classes.
Each non-web class meets in the same room for the entire semester that it is taught.

Answer rating: 100% (QA)

Here are the SQL codes to create the database and the ERD SQL Codes SQL CREATE TABLE Course courseid SERIAL PRIMARY KEY coursename VARCHAR50 NOT NULL ... View the full answer