Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
Get 20% Off + $20 Signup Bonus ! Limited Time, Hurry !
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

0 Page
Find the Total Number of Employees

...

Course

MIS602

Subject

Database

University

Torrens University

Season

Fall

0 Page
Design and Develop Information Business

...

Course

MIS605

Subject

Database

University

Torrens University

Season

Fall

5 Pages
Consolidated Domain Model

 Pictorial Model of the Organization (see Fig 2-1 of text for example) • High Level Organizational Chart (see Fig 2-5 of text for example)  Stakeholder Chart (see Fig 2-4 of text for ex ...

Type

Programming

Subject

Database

12 Pages
MIS605-Systems Analysis and Design

Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include: a) Identify, critically evaluate and recommend information systems solutions for inef ...

Course

MIS605

Type

Programming

Subject

Database

University

Laureate International Universities

CSC72001 Database Systems

Question

Answered

Task Description

A.1. Overview

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.

A.2 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 online 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. In addition to storage of information about students, courses (such as Bachelor of IT), units (such as CSC72001), staff and workshops, you must allow for the following:

A.2.1 Record student enrolment in a course, including enrolment date;

A.2.2 Record student enrolment in a unit, including the Session and the type of enrolment (internal or external);

A.2.3 Record student enrolment in a workshop;

A.2.4 Record student assessment submission, with date submitted and marks given.

B. Assessment Requirements

B.1 Assignment 2 Report

Using the ERD supplied and the data requirements provided in the Excel file, you must analyse the database needs of the client. You should provide an explanation of your database decisions or data you feel is relevant in your Assignment 1 report. Some suggested headings for this report are included in the report template (available in this assignment folder):

Client Business Rules

Assumptions Made

Naming Conventions

Data types chosen

B.2 MySQL database

Create a MySQL database using phpMyAdmin. You must name this database as your username followed by A2. For example: eyuwon10A2.

You will build the required tables, columns, data types and relationships based on your analysis. You are free to add any tables you feel are needed or would enhance the system. You must include, but are not limited to, the client’s specific data requirements. You may choose to add additional data columns to store other information about students, teachers, etc if you wish to do so.

B.3 Test Data

You must provide enough valid data in your database to run the SQL queries below successfully with at least 5-10 resulting rows. In particular, association tables will need to be sufficiently populated to give meaningful test results. You may refer to the provided sample data for references on the data format. However, you need to analyse and transform the sample data to be suitable for your database, e.g. you will be required to use your assumption on some fields that are not available in the sample data.

B.4 Export Script

You must create an export script (.sql) to create a backup of all database structures, including table definitions and data.

B.5 Proof of Testing

The results of your report queries should be added to your Assignment 2 report (see B1). This can be a screen dump of each query result inserted into your report, but MUST be readable. You should paste each query into your report, then the results of that query.

Assignment 2 CSC72001 – Database Systems

B.6 SQL Queries:

B.6.1 Workshop enrolment list

Create a query to display the workshop enrolment lists for all students enrolled in Session 3, 2019. The result should include the session, unit code, unit name, campus location, workshop day & time, tutor name, student number and student name. The result should be sorted by the unit code, campus location, workshop day and time then student last name and first name.

B.6.2 Workshop count list

Create a query to display the number of students who were enrolled in workshops in all sessions for 2019. The result should include the session, unit code, unit name, campus location, tutor name and the total count of students enrolled. The result should be sorted by the Session, unit code, campus location and workshop day & time.

B.6.3 Student Transcripts

Create a query to display the information required for a Student Transcript. The result should include the student number, student name, year, session, unit

B.6.4 Student Assessment Totals

Create a query to display the total marks for each student’s assessments in all sessions for 2019. The result should include the student names, unit code, the sum of marks given for their assessments and the final grade given. It should be sorted by the student’s last name and first name, session, and unit code. Note: the final grade is entered by the unit assessor into the database, not calculated automatically from the total.

CSC72001 Database Systems

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

28 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com has proved to be the best cheap assignment help provider in USA. Despite keeping the prices to a minimum, we keep providing top-notch quality college paper writing services for all types of academic papers. Our wide range of services includes report writing help, help with essays, dissertation writing services, coursework help. Students from all corners of the USA prefer to pay our experts for writing top quality assignments. Moreover, it is guaranteed they won't regret for paying our experts to write assignment.

More CSC72001 CSC72001 Database Systems: Questions & Answers

Q
icon

We aren't endorsed by this University

Find the Total Number of Employees

...

View Answer
Q
icon

We aren't endorsed by this University

Design and Develop Information Business

...

View Answer
Q

Consolidated Domain Model

 Pictorial Model of the Organization (see Fig 2-1 of text for example) • High Level Organizational Chart (see Fig 2-5 of text for example)  Stakeholder Chart (see Fig 2-4 of text for example) • Organization (not system) Vision Statement • Organization Mission Statement Syste ...

View Answer
Q
icon

We aren't endorsed by this University

MIS605-Systems Analysis and Design

Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include: a) Identify, critically evaluate and recommend information systems solutions for inefficiencies in business processes, procedures and work practices using data and process modelling tec ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?