Answered step by step
Verified Expert Solution
Question
1 Approved Answer
MySQL DBMS: Show a screenshot when completed For each of the following English descriptions, provide a valid SQL statement and show the evaluated result (command
MySQL DBMS: Show a screenshot when completed
For each of the following English descriptions, provide a valid SQL statement and show the evaluated result (command line or screen capture). Views are not allowed and the SQL should be a single statement. (a) Get project numbers and names for projects supplied by supplier S2. (b) Get the full details for parts supplied by a supplier in London. (c) Get all shipments where the quantity is in the range 300 to 750 inclusive. (d) Get part numbers for parts supplied by a supplier in London to a project in London. (e) Get all supplier-number/part-number/project number triples such that the indicated 1. supplier, part and project are collocated (f) Get the triples in (e) that are not collocated. (g) For each part being supplied to a project, get the part number, project number and the total quantity. (h) Get part numbers for those parts supplied to all projects in London. Given the English description: For parts that are supplied to some projects in average quantity of more than 350, show part numbers and part names (popular bulk parts) (a) Write a valid SQL statement (b) Define a view that completes this description and show the result: For parts that are 2. supplied to some projects in average quantity of less than 400. (c) Prove that the view has been created in the system catalog (hint: SQL on information_schema again) 3. Do the following and prove that it was successful: (a) Create an index with UNIQUE option on JNAME of the PROJECT table. (b) Create an index with UNIQUE pltion on PNAME of the PART table. (c) Insert in the SPJ table this tuple: (S5, P6, J9, NULL)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