For this week, I would like for you to build the SQL needed to CREATE the $$JustLee Books$$ database...use the ERD diagram in this week's Power Point as a guide for the names of the tables and fields in them...also, take a look at the sample SQLs to give you an idea of how to define the data...

My expectation is that you define the fields based on the data they contain...for example, do NOT make every character field $100$ characters...that would be considered incorrect...do NOT make every field containing dollar values $9,2...$that would also be considered incorrect...

Also, use proper naming standards as we discussed $($i$.$e$.,$ XXX$\_$XXX$\_$XXX$)...$so for example, the CUSTOMERS table has a field called "CUSTOMER#$"...$you should name it something like CST$\_$NUM...there is a field in CUSTOMERS called "Lastname"...you should call it something like CST$\_$NME$\_$LST$...$

JUST CREATE THE TABLES...do not worry about keys for now...also, do not worry about DELETEs and DESCRIBEs in your SQL$...$we will deal with these next week...

YOU SHOULD BE TURNING IN A TEXT FILE WITH YOUR SQL AND PROPER COMMENTS...I have included a sample text file below...I will run the SQL from the text file to make sure it all works...I have included a sample text file showing you how your file should look...in the sample, the CUSTOMERS table is complete, but the ORDERS table is NOT!$)...$