Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started