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

Create a query to display the information required for a Student

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

O spun 11 A2 COURSE CourseCode : int(7) unsigned CourseName : varchar(200) # CreditPoints : int(3) Notes : varchar(300) v spun 11A2 COURSE_ENROLMENT StudentID : int(11) unsigned Course Code : int(7) unsigned EnrolmentDate : date Status : varchar(20) spun 11 A2 STUDENT StudentID : int(11) unsigned FirstName : varchar(30) LastName : varchar(30) Address : varchar(100) City : varchar(30) State: varchar(30) Postcode : varchar(6) Phone : varchar(12) Email : varchar(100) spun 11A2 UNIT spun 11A2 UNIT_ENROLMENT UnitEnrolmentID : varchar(7) # StudentID : int(11) unsigned @ UnitOfferingID : varchar(8) # Year : int(4) # Session : int(1) EnrolmentType : varchar(40) FinalGrade : varchar(20) spun 11 A2 UNIT OFFERING UnitOfferingID : varchar(8) UnitCode : varchar(11) # Year : int(4) # Session : int(1) UnitAssessorID : varchar(8) e Locations : varchar(40) UnitCode : varchar(11) UnitName : varchar(200) Prerequisities : varchar(100) Description : varchar(300) v spun 11 A2 WORKSHOP_ENROLMENT WorkshopID : int(7) unsigned StudentID : int(11) unsigned v o spun 11 A2 UNIT_ASSESSOR UnitAssessorID : varchar(8) StaffID : int(6) unsigned o spun 11 A2 STAFF StaffID : int(6) unsigned @ FirstName : varchar(30) LastName : varchar(30) Campus : varchar(20) Office Location : varchar(30) @ Email : varchar(100) Phone : varchar(12) o spun 11 A2. WORKSHOP WorkshopID : int(7) unsigned UnitOfferingID : varchar(8) Campus : varchar(30) Location : varchar(100) TeacherID : varchar(8) Weekday : varchar(30) Class Times : time spun 11A2.TEACHER TeacherID : varchar(8) Staffit : int(6) unsigned spun 11 A2 STUDENT_ASSESSMENT AssessmentID : varchar(7) StudentID : int(11) unsigned Date Submitted : date # DaysExtension : int(2) # MarkAwarded : int(2) spun 11 A2 ASSESSMENT AssessmentID : varchar(7) UnitOfferingID : varchar(8) AssessmentName : varchar(30) Description : varchar(80) DueDate : date # PossibleMarks : int(2)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

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...

Create a query to display the total marks for each students assessments in all sessions for 2019. The result should include the student names, unit code, the sum of marks given for their assessments...

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...

1.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...

Description: Flyer University (FlyerU) uses a MS Access database (that you will download) to track first-year students and to manage their course offerings. You are asked to complete the...

database management system, pdf is attached COURSEWORK SECOND SEMESTER 2019/2020 SESSION (A192) COURSE CODE & NAME : BKAS3053 DATABASE MANAGEMENT SYSTEM LECTURER'S NAME : ASSOC. PROF. TS. DR. AIDI...

I would like assist for my assessment. The subject is Subsidiary Accounts and Ledgers and Foundation Skills. T-1.8.1 Details of Assessment Term and Year 1, 2017 Time allowed Week 2-7 Assessment No 1...

In this assignment, you are required to design and implement a database system for a given scenario, applying the methodologies and technologies that you learn from the unit. Scenario Suppose that...

If could, I would like to send you the word and pdf files to make it easier for you to solve the problem. You are working with the following relational schema for a university's course management...

SQL Query Design Module Preview This guide contains a preview of the materials for all module courses in this series: Using a Relational Database Management System Single Table Query Commands...

Find ads that utilize the techniques of contrast and novelty. Give your opinion of the effectiveness of each ad and whether the technique is likely to be appropriate for the consumers targeted by the...

Patton Company budgeted the following costs for the production of its one and only product, bells, for the next fiscal year: Direct materials $205,000 Direct labour 125,000 Factory overhead: Variable...

Do you think EPS alone is a strong indicator of a company's financial health, or should it be analyzed alongside other metrics?

An example of a process at a group level is

(Appendices) Megan, age 28, is insured under an individual major medical policy. The plan has a calendar-year deductible of $1,500, a 25 percent coinsurance provision, and an annual out-of-pocket...

(Appendices) Some states have second-injury funds in their workers compensation programs. However, in recent years, a number of states have terminated such funds.LO6 a. How does a second-injury fund...

(Appendices) PURCHASES, SALES, AND COST OF GOODS SOLD. The following data were available for Jeans Inc., a seller of denim clothing, at January 1 of a recent year: Jeans Inc. records purchases and...