I am sure many have seen this problem before (yes, it is for a class ) I have started it and think its "close" But I am not sure about the relationships, any help would be greaty appreciated.

Below is the problem disreagrd the attached word doc

our regional Oracle User’s Group has grown to include over 200 members. We’re an all-volunteer organization of working adults and secondary-school students, and our records are a mess. We need an information system to help us keep track of our business.

We definitely need to automate our membership records. For each member, we need to keep the member’s name, title, mailing address, office or home phone number, type of membership (individual or corporate), and whether or not the member is has paid the dues (is the member “current”?). We collect dues on a yearly basis, and they are due in January.

We also like to know which company a member works for but keeping this information current is difficult because our members are always changing companies . We try to track only a single current employer for each member. Our members come from many different companies, including Sony, EG&G, and Storage Tech.s. A few of our members are unemployed. For each company, we keep the company name, address, and type of business.. We have a standard set business codes. We keep only the main company address for each company.

We hold various events during the year, and we’d like to track information about each event. Some of our annual events include the September Meeting, the November Meeting, the annual Training Day in January, and our April Meeting. We also hold special events each year.
For example, we held a special CASE (Computer Aided Systems Engineering) day last May, and Richard Barker from Oracle U.K. came and spoke. We hold our events at several different locations around town, including AT&T, Redrocks Community College, and Skyline University. We’d like to track each event’s date, optional description of the event, number of attendees, where it was held, how much money we spent on it, and any comments on the event. We treat all comments as if they came from an anonymous submitter. A set of comments is a free-form text statement of any length. We number each set of comments, and we frequently get multiple sets of comments for an event.
We also track which members attended which events. Some of our members are really active, and others attend very infrequently or just enjoy receiving our newsletter.

We also need to track what type of computer platforms our members are using. We have a unique, three-digit system identification tag for each type of platform. For example, 001 is for UNIX; 002 is for RAC & HA; 003 is for Oracle on Windows; 020 is for Oracle Spatial; 030 is for Oracle & .NET; 050 is for DBMS; and 080 is for Business Intelligence & Reporting Tools.

We also like to track which application areas each member is interested in. Sample application areas include accounting, human resources, entertainment, oil and gas, pharmaceuticals and health systems. The applications should be portable, so we don’t need to know which platforms they run on.

Edited by happygeek: fixed formatting

6 Years
Discussion Span
Last Post by Jayson27

A couple of things I noticed:
--Member has no "status" attribute (for "current") and no way to track when dues were paid. Could be a DuesLastPaidDate attribute or even a separate entity, if you want to keep history.
--Relationship between Company and Business is backwards (assuming it's "Business Type").
--Should be a relationship between Membership and Attendees.
--Should be no relationship between Attendees and AppInterest.
--Relationship between Applications and AppInterest should be identifying.
--Relationship between Membership and Computer Platform is backwards, or could possibly be many-to-many and require a resolution entity.
--Relationship between Membership and AppInterest should be identifying.

As a separate note, you may wish to move your entities around to try to "uncross" some of the lines. It improves readability.

Hope this helps!

Edited by BitBlt: n/a

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.