Question: 1.0 DATABASE DESIGN You are to create the database and table based on your ERD model. For each table you created, it should consist of

 1.0 DATABASE DESIGN You are to create the database and table

1.0 DATABASE DESIGN You are to create the database and table based on your ERD model. For each table you created, it should consist of at least THREE (3) different data types as attributes. Construct the SQL queries to create the database, tables, attributes with relevant data types and descriptions. Set the Primary and Foreign Keys for each table by referring to their relationship PPB Approval PPBD pid decision ppb_comment ppib supported date HOP Approval HOP hop_decision hop_comment hop_supported date Dean Approval deand dean decision dean_comment dean approval date 2.2. supported by approved by PKPP Approval PKPPUR pop_decision pl_comment pop supported_date HO supported by supported by * contain Course_Registration regid as id add as dropar Application Form red apptype SLO HOPID PPIB_ID PKPPID deand Statud Course crid crs code CPS name cs section Ors_credit hour or class quota Application_status Status_id Faculty Approval Sad facultyfreceived_dare proved by faculty process_date faculty approval has facultyd Entity-Relationship Diagram (ERD) Enrolment ed registe apply reg date Faculty prog_code programe faculty belong to Student SLO stuname Stu_og stu_handphone credit smp prog_code

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!