Question: HAS TO BE IN DIAGRAM! Draw a conceptual data model to model the scenario in each problem. Use the model constructs (e.g., the material on

HAS TO BE IN DIAGRAM! Draw a conceptual data model to model

HAS TO BE IN DIAGRAM!

Draw a conceptual data model to model the scenario in each problem. Use the model constructs (e.g., the material on the E-R model and the enhanced E-R model) from chapters 2 and 3 as appropriate and follow the modeling conventions used in the example problems in the online lessons. Do not use the modeling conventions shown in Figure 2-22 of the Hoffer textbook which illustrate a data model in Visio notation. Do not use modeling conventions that you may happened to see in other books, videos, websites, or other materials that have not been assigned in this course. Be sure to include all appropriate completeness constraints, disjointness constraints, and subtype indicators in your conceptual data models. The book to be used is:Modern Database Management twelfth edition - Jeff Hoffer-Ramesr Venkataraman-Heikki Topi 3. The Minneapolis Wellness and Cultural Organization (MWCO) provides fitness, recreational, and cultural services to the residents of Minneapolis and surrounding communities. In order to use the services of MWCO, people must become members of MWCO. When people become members, MWCO assigns them a MWCOMemberID. For each member, MWCO is also interested in the MWCOMemberName (composed of MWCOFirstName, MWCOMiddlelnitial, and MWCOLastName), MWCOAddress (composed of MWCOStreetAddress, MWCOCity, MWCOState, and MWCOZipCode), MWCOHomePhoneNumber, NWCOWorkPhoneNumber, and MWCOCellPhoneNumber. For residents of Minneapolis, the MWCOParcelNumber of the local residence is also stored, For nonresidents, the MWCODriversLicenseNumber is stored. All members are either residents of Minneapolis or nonresidents, and no members are both residents of Minneasplis and nonresidents

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!