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 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 for the StayWell Student Accommodation database on page 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 copypasted 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
