K
Zoom
Kizspy.me
Attributes with underline belong to the Primary Key of each entity.
Attributes which reference to the primary key of another table must have the same name as
the attributes in the primary key of the referencing table.
When submitting the responses for this question, submit only SQL statements for creating
tables with corresponding keys and foreign keys. Do not use "create database", "Alter
database", "use database_name" or any statements using database's name in your
submission.
Email:
VARCHAR(100)
Edate: DATE
CourseID: INT
StudentID: INT
Full Name:
VARCHAR(100)
Students
Enrollments
Courses
Course Name:
VARCHAR(100)
Etime: TIME
Lecturer
BirthDate: DATE
Gender:
VARCHAR(10)
+ 100%
Teachers
TeacherID: INT
Full Name:
VARCHAR(100)
Phone:
VARCHAR(15)
Email:
VARCHAR(50)
Close
