Database

This page previews how our system will display stored information: tutoring requests, tutors, and matches. In Unit 3, these tables will be generated from the real database and connected to forms and reports.

All tutoring requests (preview)

Request ID Student Course Need Pay Status
R-014 William Brogan MATH-M211 Integration; midterm prep $150-$250/hr Unmatched
R-015 Da'Sheala Walton CSCI-C343 Structure Review; debugging Free Matched
R-016 John Dietz INFO-I308 Regression; homework $100-$200/hr In Progress

Additional INfo can go here

All tutors (preview)

Tutor ID Tutor Courses Format Pricing Matched?
T-002 Jetson Black MATH-M211; INFO-I308 Online; group $20/hr Yes
T-003 Justin Burrell CSCI-C212 In-person Free No

Additional Info can go here

Matched pairs (preview)

Match ID Student Course Tutor Payment Match Status
M-008 Da'Sheala Walton CSCI-C212 Justin Burrell Free Matched
M-009 John Dietz INFO-I308 Jetson Black Paid In Progress

Additional Info can go here

Row Returned Example

This is a example of what it would look like to return rowss based on a query

R-014William Brogan - MATH-M211 - $15-$25/hr
R-019Jetson Black - ECON-E201 - Free
I imagine this is where UNIT 3 stuff will come in

Need Clairity

Just for Jetson's sake, what method are we going to learn for formating data from the DB? currently i just took a skeletoned out CSS style for tables from a previous project to model sample table data.

If we wanted to keep this sample styling, we could use JS to call the database somehow and then dynamically put the information into the tables.

If we have a different idea in the class for getting data on a webpage then this will need to be updated.