we were given this ERD diagram and asked to construct a database. our new database should consist of:

-at least 3 different data types as attributes .

we also have to use SQL queries to create the database, tables, and attributes with relevant data types and descriptions. by referring to the relationships we have to set the primary and foreign keys.

as for the SQL queries, we need to use INSERT, UPDATE, and DELETE a minimum of 10 rows of data into each table. data manipulation needs to follow the constraints as per given.

Enroll Course_application status CA Status FK PK HPK Dean_of_faculty DoF_ID DoF_Name Student_No Course Code V FK shows in monitor approve register Application form Student apply PK HT PK HFK FK HH AF_ID Student_No Course Code HOP/AALID DoF_ID CA_Status Total_Credit Hour Student No Student Name Student PhoneNo Student CGPA Faculty Program Code&Name HPK Head of program Academic advisor HOP/AA ID HOP/AA Name FK FK FK support competing FK has has Course PK PPIB/KOKUM has Credit hour Coordinator measure FK * FK PK FK PPIB/KOKUM Course Coordinator FK Total Credit Hour responsible ++ PK Coordinator ID Coordinator_Name Course_Code PPIB/KOKUM_Course O Total_Credit hour Course_Name Course_Section Course_Credit Hour Add Course Drop Course ENTITY RELATIONSHIP CONNECTIVITY ENTITY Student apply 1:1 ApplicationForm Student registers 1:M Enroll Enroll shows in M:1 Application Form Course Application Form has 1:M HeadOfProgram 1:1 Application Form support/ completing responsible has Coordinator PPIB/KOKUM DeanOfFaculty Course Application Status CreditHour 1:M M:1 1:1 approve PPIB/KOKUM Course Application Form Application Form Course monitor 1:1 measure 1:M