Writing SQL Statements

Resources:

• Textbook Chapters 6 and 7
• Websites:
  • SQL Statement Syntax Website provides an SQL tutorial.
  • SQL Syntax Website provides SQL instructions.

Review the data model defined in Week 2, and then review the attached questions and define the SQL statements associated with each question:

SQL Exercise Assignment Submission:

• You must use the attached file and answer questions listed on the document.
• Right click the file and save it to your computer.
• Complete the assignment offline and save it to your local hard drive or flash drive.
• To Submit, go to Blackboard and click on assignment link.
• Click “Attach File” and Click “Browse My Computer”
• Select your file and click “Open” to attach it.
• Do NOT enter anything in the comments. If you have any comments, send them separately via email.
• If you are not ready to submit it, do not click “Submit.”
• When you are ready, click “Submit” to complete (upload) your assignment. Clicking “Save as Draft” does not submit your file.