Your task is to create and test a database in MySQL using PhpMyAdmin. You are provided...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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 DATA2001 Assessment2_SampleData.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 datatypes 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 DATA2001), 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 enraiment in a workshop, A.2.4 Record student assessment submission, with date submitted and marks given. B.6.1 Workshop enrolment list Create a query to display the workshop enrolment lists for all students enrolled in Session 1, 2015. 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 2014. 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 B.6.4 Create a query to display the information required for a Student Transcript. The result should include the student number, student name, year, session, unit code, unit name and final grade. The result should be sorted by the student's last name, first name, by year, session and then by unit code. Student Assessment Totals Create a query to display the total marks for each student's assessments in all sessions for 2014. 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. 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 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 DATA2001 Assessment2_SampleData.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 datatypes 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 DATA2001), 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 enraiment in a workshop, A.2.4 Record student assessment submission, with date submitted and marks given. B.6.1 Workshop enrolment list Create a query to display the workshop enrolment lists for all students enrolled in Session 1, 2015. 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 2014. 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 B.6.4 Create a query to display the information required for a Student Transcript. The result should include the student number, student name, year, session, unit code, unit name and final grade. The result should be sorted by the student's last name, first name, by year, session and then by unit code. Student Assessment Totals Create a query to display the total marks for each student's assessments in all sessions for 2014. 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.
Expert Answer:
Answer rating: 100% (QA)
Ans Given that Newtons second law Fma its forms for a impulse velocity Equation du t Principles is d... View the full answer
Related Book For
Organic Chemistry
ISBN: 978-1118133576
11th edition
Authors: Graham Solomons, Craig Fryhle, Scott Snyder
Posted Date:
Students also viewed these accounting questions
-
Your task is to prepare isopropyl methyl ether by one of the following reactions. Which reaction would give the better yield? Explain your answer. (1) Isopropyl methyl ether Or (2) Isopropyl methyl...
-
Your task is to construct a report regarding criminal offenses investigated by U.S. attorneys by offense and year using the following data from the U.S. Department of Justice. Your report should...
-
You are provided with annual return, standard deviation of returns, and tracking error to the relevant benchmark for three portfolios. Calculate the Sharpe ratio and information ratio for the three...
-
4. (a) (c) 6 -6 5 6 5 7 6 (b) (d) -5 6 6 -7 [6-5] 7-6
-
When a good is limited, some means must be found to ration the scarce commodity. Some examples of rationing devices are auctions, ration coupons, and first-come, first-served systems. What are the...
-
A slow jogger runs a mile in 13 min. Calculate the speed in (a) in/s, (b) m/min, (c) km/h. (1 mi 5 1609 m; 1 in = 2.54 cm.)
-
The risks of incorrect rejection and incorrect acceptance are related but involve two entirely different outcomes: Incorrect rejection means the risk of concluding that recorded book value is...
-
Computing the gain or loss on sale of equipment. Fedup Express acquired a delivery truck on January 1, 2004, for $48,000. It estimated that the truck would have a six-year useful life and $6,000...
-
Suppose that you have a short position in 10 3-month call option contracts. How do you hedge this long position in calls using 3-month puts? Should you long or short the puts? And how many put...
-
Consider the data in Figure 5.25 for Deb?s Dance Studio: Adjustment Data 1. Insurance expired, $1,000. 2. Dance supplies on hand, $1,100. 3. Depreciation on dance equipment, $2,500. 4. Salaries...
-
What is the success of the Edsa Revolution? Explain
-
Suppose that a bird watching club has collected data on the number of sightings of 20 different bird species in each of 100 different cities. The data has been stored in an two dimensional array as:...
-
6) Given the function: f(x)=x-2x - 15 a) Find the value of the slope of the function for x = 0 and x = 10. b) Find the value of x such that the first derivative f'(x) = 0. c) Using your answer from...
-
7) Find the first derivatives of the following functions, simplifying your answers where possible: a) y = 10 + 4x + 2x-1 b) y = 8x + x - 10 c) y = (x - x) d) y = log10 (x)
-
An excited molecular level E) is connected with three lower levels [n) and the groundstate (0) by radiative transitions with spontaneous probabilities Aio=4107 s, Ai1 = 3 107 s-, A2 = 1107 s-1, A3 =...
-
8) The below mathematical function shows how hourly wage (hw) depends on years of schooling (S) and years of work experience (E): hw = 10 + 8S - S + 10E - 2E - 2SE a) What is the effect on hourly...
-
The de voltage, Vdc, in Figure 1 represents the voltage generated by an array of solar cells constructed on rooftop of BN building. These solar panels are capable of producing 1.8 kW of green energy....
-
Show that gj concave AHUCQ Abadie For nonnegative variables, we have the following corollary.
-
Explain the following observations: When tert-butyl bromide is treated with sodium methoxide in a mixture of methanol and water, the rate of formation of tert-butyl alcohol and tert-butyl methyl...
-
When an aldehyde or a ketone is condensed with ethyl a-chloroacetate in the presence of sodium ethoxide, the product is an α,β-epoxy ester called a glycidic ester. The...
-
The heat of hydrogenation of allene is 298 kJ mol-1, whereas that of propyne is 290 kJ mol-1. (a) Which compound is more stable? (b) Treating allene with a strong base causes it to isomerize to...
-
What is the total amount of slack in all critical path activities?
-
PERT assumes that individual task times can be modeled with what type of prob- ability distribution?
-
Would a project with 100 tasks always be more challenging to manage than a differ- ent project with only 20 tasks? Why or why not?
Study smarter with the SolutionInn App