Question: Help with SQL? SQL (13 points) in the foloving items, inplenent uerything described in SQl,using the myeq1 monitor of 3 points) In th ng described
SQL (13 points) in the foloving items, inplenent uerything described in SQl,using the myeq1 monitor of 3 points) In th ng described in SQl, using the mysql monitor of the mysql DBMS. For how to submit it refer to item 4. below. Consider the database shown below: 1. (75 points) Write appropriate SQL DDL statements for declaring the STUDENT GRADE relational DB schema (shown in Figure 2.1) a. (30 points-5x 6 pts) Specify in SOL the attributes, their data type, the primary keys. b. (15 points 5 x 3 pts) Create the referential integrity constraints (i.e., create the foreign keys and the (15 points-5 x 3 pts) Create the referential integrity constraints (ie, create theforeign keys and the foreign keys -Oprimary keys relationships-we did this for Figure 2.1 on the first days of this semester on the board). b
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
