How to use SQL to get information out - SELECT....
Learn how to connect tables together - Look at primary keys, foreign keys
Create two shifts
Different roles
Different users
Random shift times
A day has a shift.
A day can have multiple shifts.
A shift has a role and a user.
A shift also has a start time and end time.
A user has a firstname, last name, email, password...
There may be other fields that you need to figure out as well...like where does the name of the day go?
Goal:
Create SQL tables called "Users", "Roles", "Shifts", "Days"
Research:
Create two shifts
A day has a shift. A day can have multiple shifts. A shift has a role and a user. A shift also has a start time and end time. A user has a firstname, last name, email, password... There may be other fields that you need to figure out as well...like where does the name of the day go?
Goal: