Develop an ERD. If you make additional assumptions, document them as business rules. all entities, relationships,...

Develop an ERD. If you make additional assumptions, document them as business rules. all entities, relationships, primary keys, foreign keys and weak entities must be labeled. You have been asked to develop a database to help the Wisconsin Snowmobile Association track their club members. The following are the predefined business rules:

1)Snowmobile Clubs are tracked by Wisconsin county.

2)A club can be assigned to multiple counties.

3)Members can belong to one or more clubs.

4)Some clubs could have the same name.

5)New clubs can be started at any time.

6)The Wisconsin Snowmobile Association has an elected Executive Board consisting of a President, Vice President, Secretary, Treasurer and Executive Director, all of whom must be current members.

7)Each county must have a Director and a Representative.

8)Each club has a President, Vice-President, Secretary and Treasurer.

Solutions

Expert Solution

Answer:

ERD (page 1)

--------------------------------------------------------------------------------------------------------------------------------

Database Design (page 2)

---------------------------------------------------------------------------------------------------------------------------------------------

venereology answered 1 month ago

Next > < Previous

Related Solutions

Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The...

Use the following business rules to draw the fully labeled Crow's Foot ERD in Visio. The diagram must include all entities, attributes, and relationships. Primary keys and foreign keys must be clearly identified on the diagram. Write all appropriate connectivities and cardinalities on the ERD. a). A company has many divisions. Each division operates many departments, but each department is operated by one division. b). A department employs many employees but not more than 100. c). Each employee is employed...

I need a list of business rules and corresponding ERD for a simple, very basic Pet...

I need a list of business rules and corresponding ERD for a simple, very basic Pet Store. Don’t think Petco or PetSmart, think little shop with only one location. They sell puppies, kittens, fish, and some reptiles. They also sell fancy food, toys, and beds for all these pets. Basically, the store sells things (2 entities), by whom (entity), to who (entity), and how (entity). I need two things: First, information containing the operation and business rules for a simple...

Facilitie Planning. Can you make an example. Develop a relationship chart for the relationships between you,...

Facilitie Planning. Can you make an example. Develop a relationship chart for the relationships between you, your professor, department chair, college dean and university president.

Create a database design with the following rules. List down all the entities and attributes and...

Create a database design with the following rules. List down all the entities and attributes and draw out the relationships. List all the business rules. 1. A person can have multiple accounts (Track individual accounts, Trusts, IRA, 401k, HSA, etc) a. Not all accounts must be through brokerage 2. Multiple brokerages (Fidelity, Vanguard, ect) a. Multiple accounts with different brokerages b. Multiple types of accounts allowed at each broker 3. Categorization of investments (Large Cap, mid cap, small cap, Bonds...

1- How do business owners create legal entities? Is the process the same for all entities?...

1- How do business owners create legal entities? Is the process the same for all entities? If not, what are the differences? 2- What is an operating agreement for an LLC? Are operating agreements required for limited liability companies? If not, why might it be important to have one? 3- How do corporations protect shareholders from liability? If you formed a small corporation, would you be able to avoid repaying a bank loan from your community bank if the corporation...

In implementing Electronic document management system (EDMS), develop business requirements document (BRD) that details the requirements...

In implementing Electronic document management system (EDMS), develop business requirements document (BRD) that details the requirements and design for an enterprise EDMS. This should to address creating a new EDMS to be used by a company to store and track all e-documents. Also, • Identify the types of e-documents and other content that can be created • For each type of e-document, provide an example e-document • Define the key personnel within who require access to the EDMS.

Explain the importance of B2B relationships and how to make them effective. Mention the entry modes...

Explain the importance of B2B relationships and how to make them effective. Mention the entry modes for International Markets and explain at least 2 of them (include advantages and disadvantages).

Develop a summary which outline and explains all the rules and guidelines associated with the procedure...

Develop a summary which outline and explains all the rules and guidelines associated with the procedure surgical device Pacemaker-Leadless and Pocket less System

The structure, authority relationships, and rules of the Alibaba organization. Use the organization chart , you...

The structure, authority relationships, and rules of the Alibaba organization. Use the organization chart , you can choose to use imformation about instructions on main executive positions, responsibilities of different departments, their authority relationships and conflicts the structure may bring, give your suggestion about its organization.

11. What are three general characteristics of private not-for-profit (NFP) entities that make them different from...

11. What are three general characteristics of private not-for-profit (NFP) entities that make them different from for-profit entities?

Subjects