Homework: Database Programming Evaluation Practical
Context:
The MIS602 Data Modeling & 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.
Introduction:
You are required to create the database tables as per the ERD below, and then generate the SQL tasks given in the table.
Part 1
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
i. SQL file (24 tasks) with results and outputs in a word document.
ii. Experience/Reflection report.
Note: On the following day, you will receive another student's homework via email to review, for which you are required to write a short critique. This is explained in the following section.
Part 2
Requirements: Based on the homework 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:
i. Comment on the overall usage of SQL statements and commands used.
ii. Provide constructive criticism on how the author can improve their understanding of SQL statements.
iii. Provide some useful readings the author may pursue to help in developing the SQL skills in the future.
Format your homework according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length