CMIS450: HW1a (E/R Modeling)



CMIS450: HW1 - E/R Modeling

Home Work Requirements:

1. Draw an E/R diagram (conceptual model) for each of two scenarios (Illinois Computers- Customer Order Form and DMV-Vehicle Registration).

2. Indicate the relevant attributes for each entity (you may make up some attributes on your own to make the underlying business scenario meaningful).

3. For each of the entities in your diagram, underline the identifying attribute(s), i.e., the attribute(s) that may be used to uniquely identify each entity instance.

4. Specify the maximum and minimum cardinality for each relationship.

Note:

1. Clearly state any assumptions you make. However, make sure your assumptions are realistic. Do not make any assumptions just to suit your answer.

2. The assignment will be graded as follows:

Adequate representation of the scenario (Entities, Relationships, cardinality): 80%

Presentation format (typed, graphics): 20%

CMIS450: HW1a (E/R Modeling)

|  |  |  | ILLINOIS |  |

| | | |COMPUTERS | |

| 2734 Maple Street |  |  |  |  |

|  |  |  |

|  | Address: _________________________________________ |  |

|  | City: _____________________ State: ______ Zip: ______ |  |

|  | Phone: ____________________ |  |  |  |

  |  |  |  |  |  |  |  | |  |  |  |  |  |  |  |  | |  |Item No. |Description |Quantity |Price/Unit |$Amount |  | |  |  |  |  |  |  |  |  | |  |  |  |  |  |  |  |  | |  |  |  |  |  |  |  |  | |  |  |  |  |  |  |  |  | |  |  |  |  |  |  |  |  | |  |  |  |  |  |  |  |  | |  |  |  |  |  |  |  |  | |  |  |  |  |  |  |  |  | |  |  |  |  |  |  |  |  | |  |  |  |  |  |Sub-total |  |  | |  |  |  |  |  |Freight Amount |  |  | |  |  |  |  |  |Tax |  |  | |  |  |  |  |  |Total Amount |  |  | |  |  |  |  |  |  |  |  | |

HW1b: Case Scenario: DMV - Vehicle Registration

The Department of Motor Vehicles (DMV) for the State of Illinois is developing a new database to support Vehicle Registration. The following requirements have been specified based on interviews with key staff and a review of DMV documents.

Vehicle Registration

The vehicle registration unit of the DMV tracks data on automobiles, busses, motorcycles, trucks, aircraft, and boats. Every vehicle has a DMV vehicle identification number, year, make, model, and manufacturer’s ID (the number stamped on the engine block). Most vehicles have license plates, with the exception of aircraft and boats. For taxis, commercial airplanes, municipal busses, and ferryboats, the DMV also issues and records an eight-character ‘medallion’ number, the date of most recent inspection, and vehicle capacity (maximum number of passengers).

Vehicles are registered annually; the DMV must record the most recent registration date, full name and mailing address of owner(s), and sales price of the vehicle. Annual registration fees are calculated from the sales price.

Specific kinds of vehicles have special data requirements. The DMV must record the displacement, engine class (diesel, gas, sail) and keel length of boats. Manufacturer’s horsepower rating and date of last emissions check are recorded for all busses, trucks, autos, and motorcycles. The number of axles of busses and trucks must be maintained for calculation of the annual commercial highway tax. Finally, the DMV must store the name of the home airport and Federal Aviation Administration code of each airplane.

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download