Question: create table sql based on this erd example: CREATE TABLE ( ATTENDANCE_ID INT NOT NULL, ATTENDANCE_DATE DATE, ATTENDANCE_STATUS VARCHAR(255), ATTENDANCE_CLASS VARCHAR(255), PRIMARY KEY (ATTENDANCE_ID), FOREIGN
create table sql based on this erd
example:
CREATE TABLE ( ATTENDANCE_ID INT NOT NULL, ATTENDANCE_DATE DATE, ATTENDANCE_STATUS VARCHAR(255), ATTENDANCE_CLASS VARCHAR(255), PRIMARY KEY (ATTENDANCE_ID), FOREIGN KEY (STUDENT_ID) REFERENCE STUDENT(STUDENT_ID));
STUDENT PK STUDENT_ID STUDENT_NAME (1.M) STUDENT ADDRESS THE STUDENT_CONTACT_NUMBER STUDENT GENDER STUDENT_DATEOFBIRTH TEACHER (MM) RESULT PK TEACHER_ID TEACH PK RESULT_ID TEACHER NAME (MM) PK,FK1 (1.M) -TEACH STUDENT ID RESULT_NAME TEACHER ADDRESS PK.FK2 TEACHER_ID RESULT DATE TEACHER_CONTACT_NUMBER TEACHER_ATTENDENCE RESULT_DESC FK RESULT STUDENTID (1,M) (MM) CAN BY INSERT (MM) (1.M ACCESS ATTENDENCE PK.FK1 RESULT_ID PK ATTENDENCE_ID PK.FK2 TEACHER ID ATTENDENCE DATE ATTENDENCE STATUS ATTENDENCE_CLASS
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
