BraviaResearch.com

You are here: Home Resources Importance of Data Management

Importance of Data Management

Importance of Data Management - 4.0 out of 5 based on 1 review
4.5 1 1 1 1 1 1 1 1 1 1 Rating 4.50 (1 Vote)

2.1.1 Interpretation of results

In order to show the execution process for this question, the Accounting Information System is used as the module. The first thing in this case is to select the coursework marks from the table submitted_by, then multiplied the marks by the weight of the coursework which is 0.2 to create  table (AIS_CW) to show student ids, first and last names, and their marks. The same operation was used to extract weighted exam marks from the table sat_by and helped to create table (AIS_EX). The two tables (AIS_CW and AIS_EX ) are then inner joined and added more information, such as the students’ first and last name  and  the module code to create table (QA). The last process is to sort the resultant table in alphabetical order and freeze the column to be sure it will remain unchanged

Summary statistics for all modules

This question is complicated and involves selecting every module for each student and for all the students. It is important to have in mind all the exams and all the coursework done for every student. There is also need to note the weightings for every module and track the exams and coursework for every module. This is because some modules have an exam as the only assessment while others require coursework only.

2.2.0 Query and results

SQL statements Table ALL_EX:

SELECT MODULE_CODE, STUDENT_ID, WEIGHTING*MARK AS EX_MARK

FROM EXAM, SAT_BY

WHERE EXAM.EXAM_CODE=SAT_BY.EXAM_CODE;

Table ALL_CW:

SELECT COURSEWORK.MODULE_CODE, SUBMITTED_BY.STUDENT_ID, WEIGHTING*MARK AS CW_MARK

FROM COURSEWORK, SUBMITTED_BY

WHERE (((COURSEWORK.COURSEWORK_TITLE)=[SUBMITTED_BY].[COURSEWORK_TITLE]));

Table CW_EX:

SELECT [ALL_CW].STUDENT_ID, [ALL_CW].MODULE_CODE, CW_MARK+EX_MARK AS MARK

FROM ALL_CW, ALL_EX

WHERE ALL_CW.MODULE_CODE=[ALL_EX].MODULE_CODE And ALL_CW.STUDENT_ID=[ALL_EX].STUDENT_ID;

Table FINAL_MARK:

SELECT  ALL_CW.STUDENT_ID, ALL_CW.MODULE_CODE,CW_MARK+EX_MARK AS MARK

FROM ALL_CW, ALL_EX

WHERE ALL_CW.MODULE_CODE=ALL_EX.MODULE_CODE

AND ALL_CW.STUDENT_ID=ALL_EX.STUDENT_ID

UNION ALL

SELECT ALL_CW.STUDENT_ID, ALL_CW.MODULE_CODE, ALL_CW.CW_MARK AS TOTAL_MARK

FROM ALL_CW LEFT JOIN CW_EX ON (ALL_CW.MODULE_CODE=CW_EX.MODULE_CODE) AND (ALL_CW.STUDENT_ID=CW_EX.STUDENT_ID)

WHERE CW_EX.STUDENT_ID IS NULL

AND CW_EX.MODULE_CODE IS NULL

UNION ALL SELECT ALL_EX.STUDENT_ID, ALL_EX.MODULE_CODE, ALL_EX.EX_MARK AS TOTAL_MARK

FROM ALL_EX LEFT JOIN CW_EX ON (ALL_EX.STUDENT_ID=CW_EX.STUDENT_ID) AND (ALL_EX.MODULE_CODE=CW_EX.MODULE_CODE)

WHERE CW_EX.STUDENT_ID IS NULL

AND CW_EX.MODULE_CODE IS NULL;

2.2.1 Interpretation of results

In order to extract and produce the required statistics, the relationship between exam and coursework had to be determined. There were 15 students, 5 for each year; each student took 8 modules a year, which makes up 240 modules taken in total. Among these 240 modules, there were 120 requiring coursework and exams, 115 exams only and 5 coursework only. Select each part of these and form ALL_CW, ALL_EX and CW_EX. The graph below further explains the concept: For the results of the operation, use a left join and union to put them together as table FINAL_MARK, with these processed data we can use SQL functions and get the standard deviation, average, max, and min. This can be retrieved through a query named MODULE_STATISTICS. The final step includes adding module convenor name and the division code.

Is the average mark for level 2 modules lower or higher than level 3?

The data required for this question is half processed in question B and will not require a lot of processing. In question B, the average marks for every module are given in table QB, but the information concerning the level is not included. This part links them together.

Newsletter

Make sure you dont miss interesting happenings by joining our newsletter program.

Contact us

Talk to us today. Use the contact provided below

  • Hot line: +1-3155576175

Connect with us

We're on Social Networks. Follow us & get in touch.
You are here: Home Resources Importance of Data Management