Create the following SQL script (Save as w6_firstname_lastname.sql) .
Create a simple Database with the following
1) Create insert script (10 inserts)
2) Create update script (10 updates)
3) Create the following:-
a) Select all records
b) Select all records sorted descending , ascending
c) Select all records with condition (where)
d) Count all records
e) Count all record with condition
4) Create 3 delete scripts
Submit your week 6 work in w6_firstname_lastname.txt (Please save the file as a text file of your scripts and upload the text file here for final review.)
Requirements
Points
Script 1)
40
Script 2)
30
Script 3) & Script 4)
30
TOTAL POINTS
100