RdsDiagram
Course
CourseID: INTEGER
CourseName: VARCHAR(50)
CourseDesc: VARCHAR(255)
CourseHours: INTEGER
CoursePrice: REAL
CourseContentLink: INTEGER
CourseProgram: VARCHAR(10)
Class
ClassID: INTEGER
ClassCourseID: INTEGER
ClassCampusID: INTEGER
ClassInstructorID: INTEGER
ClassStudentID: INTEGER
ClassStartDate: DATE
ClassEndDate: DATE
ClassStartTime: TIME
ClassEndTime: TIME
Student
StudentID: INTEGER
StudentClassID: INTEGER
StudentStreet1: VARCHAR(25)
StudentCity: VARCHAR(25)
StudentState: CHARACTER(2)
StudentZip: NUMERIC(5,5)
StudentPhone: CHARACTER(10)
StudentEmail: VARCHAR(100)
StudentRefrenceBy: VARCHAR(50)
StudentBirthday: DATE
StudentSex: CHARACTER(1)
StuidentNote: VARCHAR(255)
Campus
CampusID: INTEGER
Campusname: VARCHAR(20)
CampusStreet1: VARCHAR(25)
CampusStreet2: VARCHAR(25)
CampusCity: VARCHAR(25)
CampusState: CHARACTER(2)
CampusZip: NUMERIC(5,5)
CampusNbrOfClassrooms: INTEGER
CampusPhone: CHARACTER(10)
CampusManager: VARCHAR(50)
CampusEmail: VARCHAR(100)
Instructor
InstructorID: INTEGER
InstructorStreet1: VARCHAR(25)
InstructorCity: VARCHAR(25)
InstructorState: CHARACTER(2)
InstructorZip: INTEGER
InstructorPhone: CHARACTER(10)
InstructorEmail: VARCHAR(100)
InbstructorRefrenceBy: VARCHAR(50)
InstructorBirthday: DATE
InstructorSex: CHARACTER(1)
InstructortNote: VARCHAR(255)
table
MynewTable
Mynewtablekey: INTEGER
column: INTEGER
column2: INTEGER
Campus_CampusEmail: VARCHAR(100)
column3: INTEGER