K
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.
Zoom
Email:
VARCHAR(100)
Edate: DATE
CourseID: INT
StudentiD: INT
Full Name:
VARCHAR(100)
Students
Enrollments
Courses
Course Name:
VARCHAR(100)
m
Etime: TIME
BirthDate: DATE
Gender:
VARCHAR(10)
Lecturer
+ 100%
TeacherID: INT
Teachers
Full Name:
VARCHAR(100)
Phone:
VARCHAR(15)
Email:
VARCHAR(50)
Close
