I am having trouble with this db because I want to throw everything into one table because of the one-to-one relationship with Event table. I’ve been taught that every subject should have its own table.
The purpose of this db is to keep track of all the media, applications, release forms, and so on distributed.
My difficulties are with Media and Meeting tables. Sometimes media will be sent out prior to meeting and sometimes the media is given at the meeting or an extra copy (courtesy copy) is provided to the company. I don’t want to count it twice if an original was given and then a courtesy copy was given. If a rep cold-call ABC and send them media prior to meeting, and then when meeting give them a courtesy copy I don’t want media to be counted as two. It should be like one original and one copy. I don’t want it to appear as though the reps have been hounding this company and sending media to the same company over and over again for the same contract.
Here’s how it suppose to work:
1. Choose a company name from Company table
2. Click a button on the form to create an Event
3. Enter the Date and time. If the Event Type is 59, then meeting form will open, or
4. If the Event Type is 58, then media form will open so I can say what I sent and so on.
Attached is the db so far.
Any suggestions on the setup and relationships?
The purpose of this db is to keep track of all the media, applications, release forms, and so on distributed.
My difficulties are with Media and Meeting tables. Sometimes media will be sent out prior to meeting and sometimes the media is given at the meeting or an extra copy (courtesy copy) is provided to the company. I don’t want to count it twice if an original was given and then a courtesy copy was given. If a rep cold-call ABC and send them media prior to meeting, and then when meeting give them a courtesy copy I don’t want media to be counted as two. It should be like one original and one copy. I don’t want it to appear as though the reps have been hounding this company and sending media to the same company over and over again for the same contract.
Here’s how it suppose to work:
1. Choose a company name from Company table
2. Click a button on the form to create an Event
3. Enter the Date and time. If the Event Type is 59, then meeting form will open, or
4. If the Event Type is 58, then media form will open so I can say what I sent and so on.
Attached is the db so far.
Any suggestions on the setup and relationships?
