Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help with SQL? Only #2 has to be answered. SQL (13 points) in the foloving items, inplenent uerything described in SQl,using the myeq1 monitor of

Help with SQL?
Only #2 has to be answered.
image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introductory Relational Database Design For Business With Microsoft Access

Authors: Jonathan Eckstein, Bonnie R. Schultz

1st Edition

1119329418, 978-1119329411

More Books

Students also viewed these Databases questions