Question

In: Computer Science

SNOWMOBILE CLUB - Database Development Draw an Entity-Relationship Diagram which must include all entities and their...

SNOWMOBILE CLUB - Database Development

Draw an Entity-Relationship Diagram which must include all entities and their attributes. Primary Keys underlined, Foreign Keys labeled, Weak entities double boxed.

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

The ER diagram for the given problem statement is as shown in the above diagram. The procedure to obtain the same has been mentioned in the first two images.

venereology answered 6 months ago
Next > < Previous

Related Solutions

A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that...
A database needs to be developed that supports a supermarket. (i) Design an entity-relationship diagram that captures, as far as possible, the requirements stated below. (Statements in brackets are additional explanations and not part of the requirements proper.) If you make any assumptions in your design, please write them down. Assumptions, however, must not contradict the requirements. 1. The supermarket sells products. Each product is uniquely identified by its product number. Moreover, a product has price. The supermarket also records...
A new database needs to be developed. You are required to draw the related Entity Relationship...
A new database needs to be developed. You are required to draw the related Entity Relationship Diagram (ERD) that includes the following information: (a) Employee (the company has several employees) (b) Department (each employee is assigned to one department) (c) Payroll (each employee receives his/her pay for the period) (d) Customer (employees sell products to customer) (e) Products (the company offers several products) Note that an employee can sell products to several customers and that every customer can be served...
2. Draw an entity relationship diagram (ERD) for the following situation: The state of Georgia is...
2. Draw an entity relationship diagram (ERD) for the following situation: The state of Georgia is interested in designing a database that will track its researchers. Information of interest includes researcher name, title, position; university name, location, enrollment; and research interests. Each researcher is associated with only one institution, and each researcher has several research interests. 3. Visit a Web site that allows customers to order a product over the Web (e.g., Amazon.com). Create a data model that the site...
Database Question Create two entities for Online Journalists business. Each entity must have 5 attributes and...
Database Question Create two entities for Online Journalists business. Each entity must have 5 attributes and explain the type of each attribute.
What role does the entity-relationship (ER) diagram play in the database design process? Discuss the different...
What role does the entity-relationship (ER) diagram play in the database design process? Discuss the different types of information represented in the ER diagram and the symbols used to represent them. How would you approach the diagramming process?
Based on the following situation,draw a complete Entity Relationship Diagram using theCrow’s Foot notation...
Based on the following situation, draw a complete Entity Relationship Diagram using theCrow’s Foot notation which includes:All entities and attributes Relationships Connectivity and relationship participation (4.5 Marks)Primary and foreign keys (3.5 Marks)A lecturer in a university can manage multiple projects. But, it is not compulsory for a lecturer to manage a project. Each project is managed by only one lecturer. Lecturer will have a staff number, a name, a rank, and a research specialty. Projects have a project number, a...
5. Draw an entity-relationship diagram, including minimum and maximum cardinality, for the following: The system stores...
5. Draw an entity-relationship diagram, including minimum and maximum cardinality, for the following: The system stores information about two things: cars and owners. A car has attributes for make, model, and year. The owner has attributes for name and address. Assume that a car must be owned by one owner and an owner can own many cars, but an owner might not own any cars (perhaps she just sold them all, but you still want a record of her in...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) DRAW ER DIAGRAM AS ONE FULL LIBRARY SYSTEM, NOT DIFFERENT FOR EACH ATTRIBUTE. Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID:...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database)...
Draw an ER diagram with these attributes ( ER diagram for SQL for a library database) Attributes :           Customer Cust_ID: key identifier, required, simple, single valued Cust_Name{ first name, last name}: Key Identifier, simple;composite, multivaried   Address{street, city,zip,state}: Customer address, required, composite, single can be derived from zip (placeholder, there should be another attribute here to represent the books taken out by the customer. Not sure.)           Inventory Book_ID: Key identifier, required, simple single valued Book_Name: Key identifier, required, simple, single-valued Genre:...
case study 1.    Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify...
case study 1.    Draw an Entity Relationship Diagram (ERD) for the following problem. Make sure you identify correct relationships, attributes, and identifiers (keys). 2.    Implement the database design into tables using an industrial-strength database management system (e.g. Oracle SQL+). case: HELP is a voluntary organization that provides aid to people. Based on the following brief description of operations, create the appropriate fully labeled Crow’s Foot ERD. Individuals volunteer their time to carry out the tasks of the organization. For each volunteer, their...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT