Identify each entity and show relationships

Assignment Help Microeconomics

Reference no: EM133917934

Assignment: Data Modeling - 30 marks

Instruction

Do a Crow's Foot ER diagram for each business rule. The diagrams should clearly describe and identify each entity and show relationships. Show all cardinality, primary keys, and foreign keys. Use verbs to name and clarify relationships. Show only the attributes contained explicitly in the case/ business rules. Make sure each entity is in the third normal form and each attribute is atomic. You should also make and document any reasonable assumptions where you feel the case is vague, ambiguous, or missing data necessary to meet the requirements. Simplify M: N relationships, if any. Submit a PDF file only. Other file formats are not accepted.

Task

The database design process's requirements collection and analysis phase has provided the following data requirements for a charitable community association. The association has members who pay monthly contributions. The main purpose of the database is to maintain accurate data about its members and their contributions and be able to generate reports such as the number of active members, members who did not pay their monthly payments, payments collected per month, etc.

1. The community association maintains member number(unique), name (first and last name), home address(number, street name, city, province, and postcode), home phone number, mobile phone number, date of birth (DOB), sex, email, membership start date and their specialization. A member can have many specializations. Although the values for home address, home phone number, and mobile phone number change, the association maintains the current values only, i.e., they do not maintain historical data.

2. Each member contributes a monthly contribution. The monthly contribution scheme is CAD 20 per month, with 5% and 15% discounts when a member pays a six-month (bi-annual) and a yearly (annual) contribution, respectively. Get the instant assignment help.

3. A member may serve in one or more committees. The association maintains on each committee the committee number (unique), title, a brief description of the committee, and the type of committee (executive, social, cultural or fund-rasing). In addition, theassociation maintains on each member when they joined the committee, their role (a member can be a chairperson, secretary or just a member), and the expected membership end date. A member plays only one role in a committee, and all the roles are the same for each committee, i.e., the responsibilities of a chairperson are the same no matter the type of the committee.

4. A committee may organize several events, which may be organized by more than one committee. The association maintains the event name, description, start and end date, location, and the number of expected participantsfor each event. Each even has a unique event number.

5. A member of the association manages historical artifactsfor the association. The association maintains an asset tag (unique), name, description, acquisition date, condition, provenance, current value, and artifact image.

6. Represent the complete set of requirements in one ER diagram.

Reference no: EM133917934

Questions Cloud

Which machine is the constraint in this plant : Which machine is the constraint in this plant? Machine A, B or C?

What does central hr department provide for organization : In a centralized human resource structure, what does the central HR department provide for the organization?

Which is reflected on the graph by a the supply curve : Graph Input Tool ? 50 Price of a sedan 45 18. This would cause the of sedans to increase, which is reflected on the graph by a the supply curve.

What is the minimum efficient scale : Suppose that you are a food manufacturer who can invest in two different plant sizes. What is the minimum efficient scale?

Identify each entity and show relationships : Do a Crow's Foot ER diagram for each business rule. The diagrams should clearly describe and identify each entity and show relationships.

By how much does n fall : Consider a planning economy with a continuum of workers of measure 1. Production of the good is given by y = zn where n is the abor. By how much does n fall?

Which economists describe as risk-averse behavior : Which economists describe as risk-averse behavior. Would a person with risk-averse tendencies be likely to purchase insurance?

What are potential long-term consequences of interest rate : What is the dual mandate? What are the potential long-term consequences of the current interest rate environment for the US economy?

What was corresponding inflation rate suggested by index : Which price index suggests the highest rate of inflation between the years 2000 and 2001? What was the corresponding inflation rate suggested by this index?

User Account

All Pages