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 eg the
material on the ER model and the enhanced ER model from chapters and 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 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
