ENTD261 Week 6

I’m studying for my MySQL class and don’t understand how to answer this. Can you help me study?

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)Selectall records

b)Selectall records sorted descending , ascending

c)Selectall records with condition (where)

d)Count all records

e)Countall 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

Get 20% discount on your first order with us. Use code: GET20

CHOOSE YOUR WRITER