Mission 2 CSC72001 \u2013 Database Methods Net web page 1 of 4
\nCollege of Enterprise and Tourism
\nDatabase Methods (CSC72001)
\nMission 2: Scholar Enrolment Database
\nDue Date: 11.30pm Friday Week 7
\nSubmission: Add report (along with Question Assignment outcomes) and SQL script by means of MySCU
\nWeight: 15% of normal unit analysis
\nA. Exercise Description
\nA.1. Overview
\nYour exercise is to create and try a database in MySQL using PhpMyAdmin. You are provided
\nwith a state of affairs and supporting paperwork, describing the requirements that Southern Cross
\nSchool may have for a database to take care of their scholar enrolments. You are provided
\nwith lots of the design for such a database and would possibly need to create a relational database to
\nmeet the consumer needs. Moreover, you will have in order so as to add sample information and create SQL queries to
\ncurrent outcomes applicable for reporting.
\nA.2 State of affairs
\nSouthern Cross School provides a variety of Bachelor ranges to varsity college students studying
\ninternally all through campuses at Coffs Harbour, Lismore and the Gold Coast, along with by on-line
\ncoaching. Scholar enrolments and their progress in objects should be saved in a database.
\nA strategies analyst has partially designed this database (see Entity Relationship Diagram
\nprovided). You’ve got been launched into the mission to finish creating and testing the database
\nto Help SCU needs. Further to the ERD, SCU has provided you with some lists and
\nparticulars about what knowledge should be saved for enrolment and recording of scholar
\noutcomes. A number of of the information for each of these lists has been provided throughout the file
\nSCUStudentEnrolment.xlsx, included with this analysis. The consumer had provided you with
\nas quite a bit as they know regarding the information requirements. As with most client-provided information, quite a bit
\nknowledge is duplicated throughout the sample information (the knowledge is not normalised), and the
\nspreadsheets do not replicate the finished database desk design.
\nYou may should resolve on and set the data-types and lengths, along with finish the design of
\nthe database. Together with storage of particulars about school college students, applications (paying homage to Bachelor
\nof IT), objects (paying homage to CSC72001), staff and workshops, you have to to allow for the subsequent:
\nA.2.1 Doc scholar enrolment in a course, along with enrolment date;
\nA.2.2 Doc scholar enrolment in a unit, along with the Session and the form of enrolment
\n(inside or exterior);
\nA.2.three Doc scholar enrolment in a workshop;
\nA.2.4 Doc scholar analysis submission, with date submitted and marks given.
\nMission 2 CSC72001 \u2013 Database Methods Net web page 2 of 4
\nB. Analysis Requirements
\nB.1 Mission 2 Report 2 marks
\nUsing the ERD offered and the knowledge requirements provided throughout the Excel file, you have to to
\nanalyse the database needs of the consumer. You want to current an proof of your
\ndatabase alternatives or information you’re feeling is expounded in your Mission 1 report. Some beneficial
\nheadings for this report are included throughout the report template (obtainable on this
\njob folder):
\n\uf0b7 Client Enterprise Tips
\n\uf0b7 Assumptions Made
\n\uf0b7 Naming Conventions
\n\uf0b7 Info types chosen
\nB.2 MySQL database 5 marks
\nCreate a MySQL database using phpMyAdmin. You might determine this database as your
\nusername adopted by A2. As an illustration: eyuwon10A2.
\nYou may assemble the required tables, columns, information types and relationships primarily based in your
\nanalysis. You are free in order so as to add any tables you’re feeling are needed or would enhance the system.
\nYou might embrace, nevertheless often usually are not restricted to, the consumer\u2019s specific information requirements. You might
\nchoose in order so as to add additional information columns to retailer totally different particulars about school college students, lecturers,
\nand so forth if you wish to take motion.
\nB.three Examine Info 1 mark
\nYou might current adequate reliable information in your database to run the SQL queries beneath
\neffectively with not lower than 5-10 ensuing rows. Significantly, affiliation tables will should be
\nsufficiently populated to supply vital check out outcomes. You might seek advice from the provided sample
\ninformation for references on the knowledge format. Nonetheless, it is important analyse and rework the
\nsample information to be applicable in your database, e.g. you could be required to utilize your
\nassumption on some fields that are not obtainable throughout the sample information.
\nB.4 Export Script 1 mark
\nYou might create an export script (.sql) to create a backup of all database constructions, along with
\ndesk definitions and information.
\nB.5 Proof of Testing 1 mark
\nThe outcomes of your report queries must be added to your Mission 2 report (see B1).
\nThat is often a show dump of each Question Assignment finish end result inserted into your report, nevertheless MUST be
\nreadable. You want to paste each Question Assignment into your report, then the outcomes of that Question Assignment.
\nMission 2 CSC72001 \u2013 Database Methods Net web page three of 4
\nB.6 SQL Queries:
\nB.6.1 Workshop enrolment itemizing 1 mark
\nCreate a Question Assignment to point out the workshop enrolment lists for all school college students enrolled in
\nSession three, 2019. The top end result must embrace the session, unit code, unit determine, campus
\nlocation, workshop day & time, tutor determine, scholar amount and scholar determine. The
\nfinish end result must be sorted by the unit code, campus location, workshop day and time
\nthen scholar ultimate determine and first determine.
\nB.6.2 Workshop rely itemizing 1 mark
\nCreate a Question Assignment to point out the number of school college students who had been enrolled in workshops in
\nall durations for 2019. The top end result must embrace the session, unit code, unit determine,
\ncampus location, tutor determine and the entire rely of students enrolled. The top end result
\nmust be sorted by the Session, unit code, campus location and workshop day & time.
\nB.6.three Scholar Transcripts 1 mark
\nCreate a Question Assignment to point out the information required for a Scholar Transcript. The top end result
\nmust embrace the student amount, scholar determine, yr, session, unit
\nB.6.4 Scholar Analysis Totals 2 marks
\nCreate a Question Assignment to point out the entire marks for each scholar\u2019s assessments in all durations
\nfor 2019. The top end result must embrace the student names, unit code, the sum of marks
\ngiven for his or her assessments and the final word grade given. It must be sorted by the
\nscholar\u2019s ultimate determine and first determine, session, and unit code. Bear in mind: the final word grade is
\nentered by the unit assessor into the database, not calculated robotically from the
\nfull.
\nC. Completely different Notes
\nC.1 Marking Requirements
\nMarking Requirements shall be made obtainable by means of a rubric on the MySCU site.
\nC.2 Submission Format
\nYou might be required to submit your job provides every on the Infotech server, and by means of
\nthe MySCU unit site. Your job submission must be inside the kind of a Phrase doc
\nand a SQL script textual content material file. Your Phrase doc must be named as your username_A2.doc
\nor username_A2.docx. (eg: eyuwon10_A2.docx) Your SQL script must be named as your
\nusername_A2.sql (eg: eyuwon10_A2.sql).
\nC.three Distinctive work
\nThis job should be achieved individually and should be your private distinctive work.
\nAlternate of ideas with totally different people can be thought-about educationally treasured nonetheless
\nexcessive collaboration shall be considered plagiarism, which is a School offence. For
\noccasion, the copying of great components of a doc (or database) even when subsequently
\nmodified, is plagiarism. Such tutorial dishonesty shall be penalised in accordance with the
\nSchool\u2019s tips and legal guidelines. The analysis course of may require some school college students to
\nattend an interview in an effort to make clear components of their job.
\nMission 2 CSC72001 \u2013 Database Methods Net web page 4 of 4
\nC.4 Retain duplicate copy
\nYou are strongly prompt to retain a reproduction of distinctive work, and progressive variations of your
\nwork in the middle of the Session. Throughout the event of any uncertainty regarding the submission of
\nanalysis objects, it is doable you may be requested to breed a remaining copy and\/or any earlier
\nvariations of your work.
\nC.5 Penalty for late submission
\nA penalty of 10% per calendar day shall be utilized to all late assignments. An extension of time
\nwill solely be thought-about (not primarily accredited) when a written request is submitted with
\nrelevant supporting documentation and in accordance with School pointers.
\nC.6 Marks and Strategies
\nMarks and ideas suggestions shall be returned by means of your MySCU site for this unit.<\/p>\n","protected":false},"excerpt":{"rendered":"
Mission 2 CSC72001 \u2013 Database Methods Net web page 1 of 4 College of Enterprise and Tourism Database Methods (CSC72001) Mission 2: Scholar Enrolment Database\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1467,1463,1466,1464,1474,1473,1472,1471,1462,1468,1461,1469,1465],"tags":[117,22,1478,8,21,24,36,31,1476,4,1479,1477,1475],"class_list":["post-29489","post","type-post","status-publish","format-standard","hentry","category-academic-paper-writing-services","category-best-nursing-paper-writing-service","category-cheap-custom-essay-writing-service","category-help-with-writing-nursing-papers","category-nr","category-nur","category-nurs","category-nursing-dissertation-writers-help","category-nursing-paper-writing-service-in-3-hours","category-online-nursing-papers","category-paying-someone-to-write-a-paper","category-professional-nursing-essay-writers","category-write-my-nursing-paper","tag-best-nursing-essay-writing-service","tag-best-nursing-paper-writing-service","tag-examples-of-nursing-dissertation-essay","tag-medical-essay-writing-service","tag-nursing-assignment-writing-service-uk","tag-nursing-essay-examples-uk","tag-nursing-essay-writing-examples","tag-nursing-essay-writing-service","tag-nursing-paper-writing-service-in-3-hours","tag-nursing-paper-writing-services-reviews","tag-nursing-school-papers","tag-sample-essay-for-nursing-application","tag-writing-papers-for-bsn"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/29489","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=29489"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/29489\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=29489"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=29489"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=29489"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}