I am creating a simple troube-ticket database in MySQL and decided to try to normalize it after reading the normalization article on this site.
So far, I have 3 tables:
faculty
-------
id
fname
lname
room
phone
email
request
request
-------
id
type
date/time
status (of request)
performed by (staff member)
requested by (faculty member)
staff
-----
id
fname
lname
email
action (performed on request)
My question is, how do I put it all together? I created databases with one table before, but never multiple tables. Let's say a staff member performs an action on a certain request that was requested by a certain faculty member. How does one code all of this so the tables all work together?
Thanks
So far, I have 3 tables:
faculty
-------
id
fname
lname
room
phone
request
request
-------
id
type
date/time
status (of request)
performed by (staff member)
requested by (faculty member)
staff
-----
id
fname
lname
action (performed on request)
My question is, how do I put it all together? I created databases with one table before, but never multiple tables. Let's say a staff member performs an action on a certain request that was requested by a certain faculty member. How does one code all of this so the tables all work together?
Thanks