MIS602-Assessment-2-Database-programming-evaluation-practical (Part 1 and Part 2)
Assessment 2: Database programming evaluation practical
The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to your understanding of data and database management and its relevance with in business context. It also introduces you to some of the key features of database management system and designing database systems that will feature in later modules of this topic. In order for you to do well in this subject, it is imperative that you undertake all of the learning activities in the modules. The learning activities are presented as a way of scaffolding your learning so that you can attempt the building blocks of the assessments and be in a safe environment to fail and to learn from them. Therefore, doing your learning activities and seeking feedback from them from peers and from the learning facilitator is the single best way of preparing for doing well in this assessment.
You are required to create the database tables as per the ERD below, and then generate the SQL tasks given in the table.
Submission Requirements and Instructions
This assessment comprises of TWO parts.
Requirements: Complete all the SQL tasks given in the table above. After completing the SQL tasks, you are required produce and experience/reflection report (1000 words) in a word document summarizing your experience of doing these tasks.
Submission: Your submission must composed of the following files, which must be submitted to Blackboard on or before
Week 7, Thursday 23:59 (Sydney time)
1. SQL file (24 tasks) with results and outputs in a word document.
2. Experience/Reflection report.
Note: On the following day, you will receive another student’s assignment via email to review, for which you are required to write a short critique. This is explained in the following section.
Requirements: Based on the assignment you received, you are required to write a critique of approximately 500 words. Please note that your critique should provide constructive feedback highlighting the strengths and areas for improvement in the report, as well as any new knowledge gained from evaluating the authors report. You should provide feedback on overall design of the database, and fulfil the following minimum requirements:
· Comment on the overall usage of SQL statements and commands used.
· Provide constructive criticism on how the author can improve their understanding of SQL statements.
· Provide some useful readings the author may pursue to help in developing the SQL skills in the future.
Submission: Your submission must composed of the following files, which must be submitted to Blackboard in a single zipped file on or before Week 7, Sunday 23:59 (Sydney time)
1. Critique of 500 words.
2. The author’s report, which your critique was based upon.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more