Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Database Management - SQL Assignment Write SQL Script to implement the following relational data base schema and the listed instance. Name your database SPJDatabase. Name
Database Management - SQL Assignment
Write SQL Script to implement the following relational data base schema and the listed instance. Name your database SPJDatabase. Name your script YourLastNameHWNo5.sql. Make sure you have comments at the top of your script that includes your name. Make sure you have the appropriate if statement to delete the database if it currently exists. Write four Select statements to retrieve all of the information about all of the data. This way you can check your script. Bring your script to class on a thumb drive and bring a paper copy of your script as well. I will copy the script to my computer. I will grade your script by running it on my computer. I will make comments and record the grade on the paper copy you submit. S( sno.string 20), sname:string(20), sstatus integer, city:string(20)) P( pno:string(20) pname:string(20), color.string(20), pweightinteger, city string(20)) J(ino string(20). jname.string(20), city:string(20)) SPJ 20 qty integer) SPJ SNAME Smith Jones Blake Sno Pno Jno OTY S1 P1 200 S1 P1 J4700 S2 P3 400 S2 P3 2 200 S2 P3 3 200 S2 P3 J4 500 S2 P3 J5 600 S2 P3 6 400 S2 P3 7800 S2 P5 J2 100 S3 P3 200 S3 P4 2 500 S4 P6 3 300 S4 P6 7 300 S5 P2 2 200 S5 P2 J4 100 S5 P5 J5 500 S5 P5 7 100 S5 P6 2 200 S5 P1 J4100 S5 P3 J4200 S5 P4 J4 800 S5 P5 J4 400 SSTATUS CITY no S1 S2 S3 S4 S5 20 30 30 Paris Paris Athens Pno PNAME COLOR PWEIGHT CITY P1 Nut P2 Bolt P3 ScrewBlue P4 ScrewRed P5Cam P6 Co Red Green 17 London Paris 17 14 12 19 Blue Red Paris NAME CITY Sorter no J1 J2 J3 Paris Athens Reader Console Athens Coll Londoin Terminal Oslo J5 J6 J7 London
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