MIS602: Data Modelling and Database Design - Database Programming Evaluation Report - Engineering Assignment Help

Assignment Task:

Context: 

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. 

Instructions: 

You need to create the database tables as per below entities and complete the tasks listed in this instruction. 

Entities: 

Task 1: Create three tables with relevant keys as suggested in the above diagram 

Task 2: Insert record of 10 employees in the employee table 

Task 3: Insert record of 5 departments in the department table 

Task 4: Insert record of 5 salary levels in the salary table 

Task 5: Write a query to display the information about the employees in the employee table 

Task 6: Write a query to display the name of all the employees 

Task 7: Write a query to display the name of all the employees and their jobname. 

Task 8: Write a query in SQL to display the unique jobname for all the employees 

Task 9: Write a query to increase the salary for all the employees by 12%. Display the empname, jobname and salary after the increment 

Task 10: Write a query to display the employee names with minimum and maximum salary. 

Task 11: Write a query to display the employee id, employee name, jobname of all the employees whose salary is greater than 90,000 P.A. 

This MIS602: Engineering Assignment has been solved by our Engineering Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.