Question
Write descriptions for three data querying requirements that could be answered from the data stored in a database represented by your ER diagram. Your classmates
Write descriptions for three data querying requirements that could be answered from the data stored in a database represented by your ER diagram. Your classmates will provide answers based on the requirements.
1-Find all products inventory to be distributed by a distributor named Empire and shipped by a shipper named RunQuick. In the list return have the names of the distributor and shipper displayed, not just the IDs.
2-Find all products in inventory to be shipped by FlightFast that costs more than $50
3-Return all products from a distributor named Dutchess, grouped by their shipper.
2)Write descriptions for two modifications for data already in the database.
1-A distributor has relocated from Beacon, NY to Green Bay, WI. Update this.
2-Sloop has changed the name of the beer called Juice Bomb to Atomic Blast. Reflect this.
3)Write descriptions for two deletions for data already in the database.
1-Delete the Beer called Confliction.
2-Delete the Distributor named Empire.
Write DML statements for each query and post them as replies to your classmates. Do not use a query generator or graphical tool to write these; write them on your own and test them in your chosen DBMS before posting.
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