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));create table sql based on this erd example: CREATE TABLE ( ATTENDANCE_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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!