Question

Using the Erwin Software (or draw.io) to construct a logical data model using the IE notation to fit the following circumstances. Place all 4 solutions in a single Erwin file for convenience. Draw data models for the following situations. In each case show also all cardinalities and verbs. Make reasonable assumptions about prime keys where necessary

a) RU has many students. For each student the student no, name and date of birth is retained. There also many student clubs. Each club has a unique name, mission statement and annual fee (if any). A student may join many clubs (but may join none) and will receive a unique membership is for that club. All clubs will have members.
b) Every department at RU has a unique department name and a location. Budgeting expense forecasts are made by each department in April of each year broken down by month for a 2 year look ahead period. Budgets are made against a standard set of Accounts. Each account has a unique account number and description. In addition to the budgeted expense amount, the actual amount spent is recorded when that month has completed and retained until the end of the current year.
c) An orchestra employs many musicians. Each musician can play many different types of instrument for the orchestra. Retain a unique id, the name, salary and date of birth for each musician and the level of their expertise in each type of instrument they can play. For each instrument type used in the orchestra retain the name of the type (e.g. Violin) and its category (e.g. strings). All instrument types have an assigned at least one musician.
d) A property management company manages many shopping malls. Each shopping mall operates many store locations. Each store location has a unique store number within its own mall. Also retained for each store is the annual lease rate, the frontage and square footage. For each mall retain the unique mall id, the address, mall name, and a contact phone number. Large retail chains rent store locations in the malls. For each retail chain retain the unique chain id and the name. A specific chain many rent more than one store location in any particular mall. At any one time not all store locations are rented.

Answer 1

To construct a logical data model using the IE notation in the Erwin software (or draw.io), you will need to create entities and their relationships based on the given circumstances in each situation.

Step-by-step explanation:

To construct a logical data model using the IE notation in the Erwin software (or draw.io), you will need to create entities and their relationships based on the given circumstances.

To construct a logical data model using the IE notation in the Erwin software (or draw.io), you will need to create entities and their relationships based on the given circumstances in each situation.

In situation a), you will have entities for students, clubs, and memberships with appropriate attributes and cardinalities. In situation b), you will have entities for departments, locations, budgets, and accounts.

In situation c), you will have entities for musicians, instruments, and instrument types. In situation d), you will have entities for property management company, shopping malls, store locations, and retail chains.