Lab 3 - Working with phpMyAdmin

LAB 3

This is project is about the MYSQL Operation in Relationship tables

Retrieve Records from a database : Course in Votey 303 on Wednesday SELECT `pfkStudentNetId`,`pfkEnrollmentId`,`pmkNetId`,`fldLastName`,`fldFirstName`,`fldMiddleName`,`pmkEnrollmentId`,`Subj`,`#`,`Title`,`Start Time`,`End Time`,`Days`,`Bldg`,`Room`,`Instructor`FROM`tblStudentEnrollments`JOIN `tblStudents` ON `pmkNetId` = `pfkStudentNetId`JOIN `tblEnrollments` ON `pmkEnrollmentId` =`pfkEnrollmentId`WHERE`pfkStudentNetId` LIKE 'yxue'

UVM Course List
Name Subj # Title Days Time(Start ~ End) Location(Building + Room) Instructor
Kamiku XueSTAT151QR: Applied Probability T R 10:05 ~ 11:20REMOTE COURSESingle, Richard
Kamiku XueMUL033Private Lessons:Piano TBA ~ REMOTE COURSEDickerson, Melissa B
Kamiku XueJAPN001Elementary Japanese IM W 15:30 ~ 17:20L/L CM 314Ueno, Natsumi
Kamiku XueCS148QR: Database Design for WebM W F 14:20 ~ 15:10VOTEY 303Erickson, Robert M.
Kamiku XueCS124QR: Data Struc & AlgorithmsM W F 13:10 ~ 14:00TERRIL 308Dion, Lisa
Kamiku XueCS121QR: Computer OrganizationM W F 10:50 ~ 11:40REMOTE COURSEEddy, James Robert