img-responsive

Please Wait

CSC72001: Creation and Testing of Database in MYSQL – IT Assessment Answer

Internal Code: 1AFIGG

Subject Code: CSC72001

IT Assessment Answer

Task Description

Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided with a scenario and supporting documents, describing the requirements that Southern Cross University may have for a database to handle their student enrolments. You are provided with most of the design for such a database and will need to create a relational database to meet the client needs. You will also need to add sample data and create SQL queries to provide results suitable for reporting.

Scenario

Southern Cross University provides a variety of Bachelor degrees to students studying internally across campuses at Coffs Harbour, Lismore and the Gold Coast, as well as by distance education. Student enrolments and their progress in units need to be stored in a database. A systems analyst has partially designed this database (see Entity Relationship Diagram provided). You have been brought into the project to finish creating and testing the database to support SCU needs.

Additional to the ERD, SCU has provided you with some lists and details about what information needs to be stored for enrolment and recording of student results. Some of the data for each of these lists has been provided in the file SCUStudentEnrolment.xlsx, included with this assessment. The client had provided you with as much as they know about the data requirements. As with most client-provided data, much information is duplicated in the sample data (the data is not normalised), and the spreadsheets do not reflect the finished database table design. You will have to decide on and set the data-
types and lengths, as well as finish the design of the database.

University: Southern Cross University

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

Solution image

Get 500 Words For FREE on Your Next Assignment By Australia's #1 Assignment Help Provider