Question: Module 3 covers the install of the database software as well as database table creation. A working database application is required from this point on

Module 3 covers the install of the database software as well as database table creation. A working database application is required from this point on in the course. The text discusses various software management systems but the focus of most figures in the book refer to MySQL.
For assessment of the installation, you MUST first create all database tables by downloading and running the scripts included in the course shell. You can then begin working on the exercises below.
Please complete exercises 1-6 for the StayWell Student Accommodation database on page 94 as indicated below.
Your submission document must include BOTH the SQL statement you wrote EXACTLY AS RUN and the results for each query execution.
Results can downloaded as a .CSV file from Oracle, opened in Excel, and copy/pasted to your Word document. Screenshots can also be taken of the Excel results using the Windows Snipping Tool.
Please refer to the text for examples in formatting your final document for submission to the dropbox.
Final submissions must be in .doc, .docx, or .pdf formats. No others will be accepted for grading. Include the module number and your name when saving the file for upload

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!