IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Access
Search Access Group:

Advanced
-Collapse +Expand Access To/From
To/FromCODEGuides
-Collapse +Expand Access Store
PRESTWOODSTORE

Prestwood eMagazine

June Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyMicrosoft Access BoardMS Access Interactive Topic   Print This     

Entity relationships and table help please?

Entity relationships and table help please? in MS Access Interactive topic (part of our Microsoft Access group).

Quick Search: relationships   Entity relationships   Entity relationships table  
wacjac
-- USA
Hi there - if anyone has a few spare minutes I could really do with some help please.


I'm a student and have been given an exercise to do using MS Access to design a simple database for a fictional dating agency. This database is not concerned with accounts or administration purely the matching of clients and meeting management.

I have racked my brains to come up with an entity relationship diagram but cannot get past the stage of even selecting the entity tables to use. I simply cannot decide whether the males and female should be in seperate tables with the intersecting table being interestes/hobbies and/or areas which they are from - or am I completely barking up the wrong tree here?

Assuming it's purely a hetrosexual database I'd be grateful for any expert opinions as to what you think the tables should be. We are told between 3 and 5 tables will do this.

To quote a small section from the question:-

"She (the dating agency owner) feels that if the client data is stored on a database then it would enable her to produce a short list of potential matches and she could then use her experience to determine which would be the best matches. A considerable amount of personal data is held about clients and it is becoming increasingly difficult for her to remember everyone. It may also make it easier for her to keep track of which clients have met and when. This will help her keep track of active clients and identify those she has not seen for some time and help her follow up on those inactive clients. Clients pay a joining fee, an annual subscription, and also a small fee for each meeting that is arranged"

Once I have got my head around which way to go I am quite competant at building the database.

Does anyone have any thoughts or ideas to help please?

Thanks in advance.

Wacjac
 Posted 20 years ago (Thread Starter)
Comment Quote
About wacjac -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5401, 4 replies
Thread Started 2/25/2002 12:55:00 PM
View Counter=2094
Last Reply Posted 2/26/2002 12:54:00 PM)
Location=-- USA 
Joined=20 years ago   MB Posts=4  
Jocat
Philadelphia
Here's how I would approach the database.

I would create three tables. One table for the all customers, regardless of sex (call it "Customer Table"). This table would capture all customer info (name, address, age, interests, etc). Be sure to have a field to identify the sex. A second table to identify which clients have met, and when (call it "meetings"). A third table for billing purposes.

For identifying matches, I would create one query to select all males, and another query to select all females. Create a third query using the other two queries to locate customers of opposite sexes with similar interests, age, etc.

You can query the "meeting table" to determine which customers are inactive by looking at the last meeting date.

I hope this helps.
 Posted 20 years ago
Comment Quote
About Jocat -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5409 (Level 1.1)  Reply to 5401
Thread Started 2/26/2002 8:04:00 AM
View Counter=2
Location=Philadelphia  
Joined=21 years ago   MB Posts=15  
Jocat
Philadelphia
After re-reading your information, I think you will need another table for when a customer contacts the agency, or when the agency contacts the customer. Query this table for determining inactive customers.

Even though you are not interested in the accounting/administration, I still thing you should include the billing table in your database because the statement by the owner tells you of the fees that the customer must pay.

Hope this helps.
 Posted 20 years ago
Comment Quote
About Jocat -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5410 (Level 1.2)  Reply to 5401
Reply Posted 2/26/2002 8:14:00 AM
Location=Philadelphia  
Joined=21 years ago   MB Posts=15  
wacjac
-- USA
please ignore this reply - just a test to see if the e-mail autoresponder works.
 Posted 20 years ago (Thread Starter)
Comment Quote
About wacjac -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5402 (Level 1.3)  Reply to 5401
Reply Posted 2/25/2002 1:01:00 PM
Location=-- USA 
Joined=20 years ago   MB Posts=4  
Most Recent Post
wacjac
-- USA
Cheers Jocat - your help is very much appreciated although I haven't had chance to even think about your opinion/idea just yet - I've just came home from a very busy day at University and have assignments and projects coming out of my ears at the momemt. I'm gonna get some shut-eye and give this some thought tomorrow.

Thank you very much.

Wacjac
 Posted 20 years ago (Thread Starter)
Comment Quote
About wacjac -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread but email is NOT VERIFIED.
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #5420 (Level 1.4)  Reply to 5401
Reply Posted 2/26/2002 12:54:00 PM
Location=-- USA 
Joined=20 years ago   MB Posts=4  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1283A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #5401 Counter
2094
Since 4/2/2008
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2022 Prestwood IT Solutions.   [Security & Privacy]