Question: Directions for the Problems. Draw a conceptual data model to model the scenario in each problem. Use the model constructs ( e . g .

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
Carlton Square Circus Academy (CSCA) offers classes on circus skills such as
juggling and unicycling. CSCA keeps track of the classes it offers as well as its
teachers and students. Attributes of class include ClassID, StartDate, EndDate,
StartTime, EndTime, ClassSize, and Fee. Attributes of teacher include
TeacherID, TeacherName, (composed of FirstName, MiddleInitial, and
LastName), PaymentPerClass, and CircusSkills. Many teachers have more than
one circus skill. Attributes of student include StudentID, StudentName
(composed of FirstName, MiddleInitial, and LastName), StudentAddress
(composed of Street, City, State, and ZipCode), DateOfBirth, and Age. Students
can take more than one class, but must take at least one class. Each class can
have multiple students, but must have at least one student. All classes are taught
by a single teacher. Teachers must teach at least one class and can teach more
than one class

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 Databases Questions!