Database Concepts - Daniel Hamermesh and Amy Parker - IT Assignment Help

Assignment Task:

1. Overview 

Database systems are a key technology for the storage, management, manipulation, and retrieval of structured data. They have an impact on the use of information technology in applications ranging from banking, to travel bookings, to online shopping. In this assignment, you will apply the skills and concepts that you have learned about database systems in the course so far. 

Learning Outcomes 

This assessment is relevant to the following Course Learning Outcomes: 

• CLO 1: Describe various data modelling and database system technologies. 

• CLO 2: Explain the main concepts for data modelling and characteristics of database systems. 

• CLO 3: Identify issues with and compare, justify relational database design using the functional dependency concepts. 

• CLO 4: Apply SQL as a programming language to define database schemas and update database contents. 

• CLO 5: Apply SQL as programming language to extract data from databases for specific users’ information needs 

• CLO 6: Design a database schema using conceptual modeling mechanisms such as entity-relationship diagrams. 

It also supports the following Graduate Learning Outcomes: 

• Enabling Knowledge: You will gain skills as you apply data modeling knowledge effectively in diverse contexts. 

• Critical Analysis: Analyse and model requirements and constraints for the purpose of designing and implementing software artifacts and IT systems. 

• Problem solving: Design and implement database solutions that accommodate specified requirements and constraints, based on analysis or modeling or requirements specification. 

Assignment Questions 

Assignment Overview 

For this assignment, you will be applying your SQL skills to analyze research data, and write a report that details your investigations into the question of whether particular variables such as class size and the perceived attractiveness of teaching staff influence course evaluations. 

As part of this assignment, you are likely to need to carry out some research and refer to additional information beyond what was covered in the course. This is an important skill. Keep a note of any external references that you use, as these will need to be detailed in your report. 

Analyzing Variables That Influence University Course Evaluations 

At most universities, teaching is evaluated through a process whereby students complete course experience surveys, rating courses in response to questions regarding the content, clarity of the material, presentation, and other factors. These questions are typically distilled into a single score that is supposed to reflect overall teaching quality. In most Australian universities including RMIT, this is the Good Teaching Score (or GTS). 

Prior research has indicated that many factors can influence student feedback, and these may include things that are directly asked as part of the surveys (Were the teaching staff good at explaining things? Did the staff work hard to make the course interesting?) and other factors that are not explicitly asked (Was the lecture room too crowded and noisy? Did an unexpected event occur part-way through the semester that required fundamental changes in teaching delivery? Are the teaching staff attractive?). 

Daniel Hamermesh and Amy Parker, two researchers form the USA, collected data to investigate the question of whether teaching evaluations are influenced by the attractiveness of teaching staff [1]. In this assignment, you will be analysing their data to carry out a preliminary investigation into answering this question. The data was collected at the University of Texas at Austin, USA, and includes information about 455 courses, taught by teaching staff in various departments (note that some staff taught multiple courses included in the data set). Courses were of various sizes in terms of the number of enrolled students. Each course was evaluated using student surveys, with responses to the question “Overall, this course was...?” being collected on a 5-level ordinal scale with a minimum score of (1) “very unsatisfactory” and a maximum score of (5) “excellent”. Information was obtained on each faculty member, based on characteristics including their gender, whether they are on a tenure track (roughly speaking, working towards being offered a permanent position at their university), whether they are part of a minority group, and whether they received their education in an English-speaking country. 

Separately, a picture of each teaching staff member was rated by 6 undergraduate students. Hamermesh and Parker describe the rating process as follows: “The raters were told to use a 1 (lowest) to 10 (highest) rating scale, to concentrate on the physiognomy of the instructor in the picture, to make their ratings independent of age, and to keep 5 in mind as an average” [1]. The ratings – subsequently referred to as “beauty” scores – were then normalised to have a mean score of zero. (This means that someone with a rating greater than zero was judged to be more “beautiful” than the average, while someone with a negative score was judged to be less “beautiful” than the average”.) 

This IT Assignment has been solved by our IT 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.