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.

Expert Solution

Answer:

ERD (page 1)

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

Database Design (page 2)

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

venereology answered 4 months ago

Entity-relationship data model (ERD)-Business rule, assumptions You are required to develop an ER model to represent...

Entity-relationship data model (ERD)-Business rule, assumptions You are required to develop an ER model to represent the information requirements of company you are working for. You also need to write business rules and assumptions. Task 2: Create the Data Dictionary base on your ERD diagram.

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.

Question

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

Solutions

Expert Solution

Related Solutions