1. Identify what tables has one- to- many (1:M or 1..*), many- to- many(M:N or *..*) and one- to - one ( 1:1 or 1..1) relationship base on the given database.

Sheet1 . . . Exit Full Screen A B C D E F G H J K L M N 0 HEU Enrollment System CO N Students_Information_Table In_case_of_emergency_info_table Subject_Information_Table id PK, Auto-increment id PK, Auto-increment id PK, Auto-increment d_number archar(10 Guardian_frame farchar(50) course_code farchar(50) Fname archar(50) Guardian_Iname /archar(50) course_number farchar(50) name archar(50) Guardian_mname Varchar(50) units archar(50) 9 Mname 'archar(50) Guardian_address farchar(100) descriptive_title /archar(100) 10 Birthdate Varchar(50) Guardian_phone_number Varchar(15) 11 Birthplace archar(50) Schedule_Table 12 Picture archar(100) Instructor_Table id PK, Auto-increment 13 Permanent_address Varchar(100) id PK, Auto-increment room Varchar(50) 14 Current_address Varchar(100) id_number int(11 day /archar(50) 15 Email_add Varchar(50) fname Varchar(50) time Varchar(50) 16 Phone_number archar(15) name farchar(50) 17 In_case_of_emergency_id int(11) mname farchar(50) Enrollment_Table 18 department /archar(50) id PK, Auto-increment 19 unit Varchar(50) subject_id nt(11) 20 schedule_id nt(11) 21 intructor_id nt(11) 22 student_number Varchar(50) 23 24 25 26 27 28 29 30 31 32 33 34 35 36