Database Info management - Is this correct

drputo

Ok,

what I am trying to do is set up a system for a casino party company.

What I want to do is set it up so each party will have all the details together such as

Date
Time
Location

Also, I want to list who worked there.

Now, usually for every party there is about 10 people. Does this mean that I have to create a TABLE for every party?

Would have to name each table something like:

PARTY 001
PARTY 002 etc.

Would it look something this?

Table = Party001

Dealers Time Location

Paul 9:30PM Hotel
John
Peter
Craig

Also I would have to make an Employee list and for each Employee I want to state what parties they have worked.

Does this also mean that I should make a table for each worker?

Table - Employee001

Fname Lname Phone email City

John Paul 555.5555 email@email.com Nowhere land

Or should i do it like this:

Table = EMPLOYEES

employeeID FName LName Phone email partiesWorked

But if I do it this way I don't think there's a way to do it right?

I hope someone can clarify this for me.

Thank you.

konsu

hello, you do not need to create separate tables for each party or for each employee. all parties go in to the same table, employess go in to another table.

drputo

Konsu I really aprreaciate your reply but I don't think that will work.
I have been thinking all day and can't see how I can show 8 different dealers in one column.

Thanks again.

konsu

if you need any further help, please clarify how you want to represent dealers and i will tell you how this can be done in a single table.

Roger_Ramjet

Usual way

table Staff

staff_id name etc etc

table Parties

party_id date time location etc

Then, to link staff to the parties they worked

table PartyStaff

party_id staff_id start finish role

And to people the parties

table PartyGuests

guest_id party_id name address phone etc

To find the guests for a party you query

select * from Parties INNER JOIN PartyGuests ON Parties.party_id=PartyGuests.party_id
where Parties.party_id= $party

To find the staff from a party you query

select * from Parties INNER JOIN PartyStaff ON
Parties.party_id=PartyStaff.party_id
where Parties.party_id= $party

Take it from there

drputo

Roger thank you so much!!!

I want to add what dealers will be going to the party dynamicly.

I guess I need to have many rows of the same party_id in the PartyStaff table.

So would PartyStaff table look like this?

PartyStaff table

party_id-----staff_id

1-----5
1-----8
1-----12
1-----6
1-----16
2-----5
2-----8
2-----12

2-----6

2-----16

Also, what is that $party variable at the end. Did you just define that.

Once again Roger, thank you!!!

Roger_Ramjet

Yes, to both Qs.

The contents of partystaff would be like that; and $party is a var I defined to stand in for user input - when you want to look up the staff who worked at a given party. You would change it to staff_id=$staff to look up what parties a given staff member worked, etc.