Super Simple Database Design Question? - database design document
How do I set up the relational tables is way, the documents produced?
For example:
Identity can be sent to
Teachers (1 or all)
Kim
Tom
Vic
and ...
Librarians (1 or all)
Shelly
Ed
I keep an eye on who gets what use Microsoft Access.
Can someone send me that advice to be similar to primary and abroad should?
There are many more names for each group, which was reduced for better understanding. My opinion is that the user with check boxes that will receive the e-mail chooses.
Friday, January 15, 2010
Database Design Document Super Simple Database Design Question?
1 comment:
Here is a simple system that allows the multiple copies of a document to be sent to different recipients, and only one receiver to receive multiple documents.
Table name: DOCUMENT
doc_id .... Digital (or text)
Title text .....
.. Description of the text (or, where appropriate, Notepad)
other fields are needed
Table Name: Recipient
doc_id .... Digital (or text)
recip_id .. Digital (or text)
...... Full name (name of recipient)
send_dt ... Date / Time
recv_dt ... Date / Time
other fields are needed
DOCUMENT.doc_id is the primary
RECIPIENT.doc_id is the foreign key
RECIPIENT.doc_id and RECIPIENT.recip_id (together) are the main key of the recipient
Note that the fields involved in the relationship the same type, domain names must be, but may be identical or different - no question.
Create a head-to-many relationship between DOCUMENT.doc_id and RECIPIENT.doc_id. (The document is a separate entity, the recipient is the responsible body - or the father of the child & TBles, if you prefer)
In this configuration, the access will not allow the records contained in the table, unless there is a specific recipient entry in the table DOCUMENT.
You might get more intelligent, by a group (or groups) table, and use it to create a many to many. E-mail if you need further assistance.
§
Post a Comment