MIS602 Assignment 2 Page 3 of 4
| 18 | Write a query to fetch the data about the first call, including the customer details, the phone number the call was made and the total number of towers used for the connection. The expected output of the query is shown below.
|
5 Marks | ||||||||||
| 19 | Who is the youngest and oldest customer of postcode 3181, having an iPhone? | 5 Marks | ||||||||||
| 20 | In not more than 200 words, comment on whether the tables are in 3NF. Justify your argument with relevant examples, and then explain at least two ways to improve this database based on what you have learned in weeks 1-8. Draw specific examples from the database to support your answer. |
5 Marks | ||||||||||
| Total | 85 Marks |
Submission Instructions
1. The database used for this assignment is available in the ‘MIS602_Assessment 2_Database SQL Files’
folder. You need to download and import the file into MySQL Workbench.
2. Copy and paste all the SQL questions into a word document. Under each question, provide the
corresponding SQL query, the first 10 lines of the result and the output as evidence of running the
query. Submit the word document via the Assessment link in the main navigation menu.
Referencing
It is essential that you use the appropriate APA style for citing and referencing research. Please see more
information on referencing here http://library.laureate.net.au/research_skills/referencing
Submission Instructions
Submit Assessment 2 via the Assessment link in the main navigation menu in MIS602 Database Modelling
and Database Design. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal.
Feedback can be viewed in My Grades.
Academic Integrity Declaration
I declare that except where I have referenced, the work I am submitting for this assessment task is my own
work. I have read and am aware of Torrens University Australia Academic Integrity Policy and Procedure
viewable online at http://www.torrens.edu.au/policies-and-forms
I am aware that I need to keep a copy of all submitted material and their drafts, and I will do so accordingly.