Reference no: EM13929869
Write SQL to perform the following queries and updates. You should test your script to make sure it runs without error:
a. Retrieve all of your customers' names, account numbers, and addresses (street and zip code only), sorted by account number.
b. Retrieve all of the videos rented in the last 30 days and sort in chronological rental date order.
c. Produce a list of your distributors and all their information sorted in order by company name.
d. Update customer names to change their maiden names to married names. You can choose which records to update.
e. Delete customers from the database. You can choose which records to delete.
How am I to conduct all of htis without using a program? The professor said to "simulate" and that it was ok to use Microsoft
Word.
Attached are my scripts (in a word document) and the ERD Diagram from my first project. Please review my scripts and help me to
match them with my ERD Diagram. Also please help me to complete the other areas of this assignment.
Attachment:- Aponte_Michael_Project2.doc
Attachment:- Aponte_Michael_ERD.zip
|
What alternatives to the exclusionary rule might be adopted
: What alternatives to the exclusionary rule might be adopted to enforce the protections of the Fourth Amendment? How effective are such alternatives likely to be
|
|
Difference between probable cause and reasonable suspicion
: What is the difference between probable cause and reasonable suspicion? How long can police detain a suspect based on reasonable suspicion
|
|
Prepare an bibliography for negligence liability of a driver
: Prepare an annotated bibliography for the following topic: Negligence liability of a driver of a car to his or her guest passenger.
|
|
Where victim told police that her assailant was very thin
: Would it be permissible for police to construct a lineup including four visibly overweight persons along with a slim suspect, where the victim told police that her assailant was "very thin"? Why or not
|
|
Write sql to perform the following queries and updates
: Retrieve all of your customers' names, account numbers, and addresses (street and zip code only), sorted by account number
|
|
Write a two to three page personal reflection
: Write a two to three page personal reflection in which you consider, in some detail, your relationship to your own writing, both private writing and academic writing.
|
|
How have new health care technologies control costs
: How have new health care technologies and pressures to control health care costs affected nurses and nursing practice? Has it affected the characteristics of nurses and nursing
|
|
Create the proposal essay using process writing
: Create the Proposal Essay using process writing, ensuring your final draft is between 3 and 4 pages in length, typed, and double spaced in Times New Roman.
|
|
What was the average interest rate on target
: What was the average interest rate on Target's long term debt in the fiscal year ended January 29, 2011 (2010)?
|