Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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. Answers to your three requests should contain at least one JOIN; an aggregation function ; a GROUP By clause; and a WHERE or HAVING clause.
- All vehicle maintenance that occurred in the month of March
- All parts bought from Summit Racing
- The total number of vehicles
- Write descriptions for two modifications for data already in the database.
- Change the Studebaker VIN to include enough preceding zeros to be 17 digits
- Change the source of the Studebaker ignition switch to Amazon.com
- Write descriptions for two deletions for data already in the database. Some examples:
- Delete the most recent Harley maintenance record
- Delete Walmart from sources
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.
Maintenanoe Vehicles onumber ar varchar 32 Maint Name VIN Nm Maint Date Maint Mileage int varchar32 varchar32 date Vehicle Lic Vehicle Mileage int PartID Vehicle Desc varchar 32 varchar1024 Maint Note varchar1024 Sources Parts Par Source Name Source Street varchar 32 Source_City varchar3 archar char Part Name varchar32 Part Illustration varchar32 Source State varchar32 Source Zip Source Phone varchar 32 Source URL Part ty Source Name int int varchar32 varchar 32Step 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