Directions for the Problems. 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. Be sure to include all

appropriate completeness constraints, disjointness constraints, and subtype indicators in

your conceptual data models

Circus on Wheels offers circus performances for residential, business, and school

clients. Attributes of Performance include PerformanceID, PerformanceType,

Duration, and Cost. Attributes of residential clients include ClientNumber,

ClientName $($composed of FirstName, MiddleInitial, and LastName$),$

ClientAddress $($composed of Street, City, State, and ZipCode$),$ and

NearestCrossStreets. For each residential client, the two nearest cross streets are

stored. Attributes of business clients include ClientNumber, BusinessName,

ClientAddress $($composed of Street, City, State, and ZipCode$),$ and Industry.

Attributes of school clients include ClientNumber, SchoolName,

SchoolDistrictCode, and ClientAddress $($composed of Street, City, State, and

ZipCode$).$ Residential clients cannot also be business or school clients. Business

clients cannot also be residential or school clients. School clients cannot also be

residential or business clients. Circus on Wheels has no other types of clients.

All clients have had at least one performance, and many clients have had more

than one performance over time. A performance $($identified by PerformanceID$)$

can be seen by more than one client over time, and some performances may not

yet have been seen by any clients $($e$.$g$.,$ a new performance that has just been

developed$).$