Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A community center offers various classes to its members. The center wants to develop a database to manage class registration, instructors, and members. Each class
A community center offers various classes to its members. The center wants to develop a database to manage class registration, instructors, and members. Each class has a unique ClassID, a name, a description, and a room number. Instructors are identified by their ID numbers. The community center also keeps track of their name and area of expertise. Some instructors have more than one area of expertise. All classes must be taught by instructors, and you cannot have more than one instructor per class. It is possible for an instructor to teach multiple classes. Sadly, not all instructors are teaching classes. Members have unique MemberID, as well as a first name, last name and address, composed of the street, city, state and zip code. The center allows members to enroll in multiple classes and all members must be enrolled in a class. The center makes sure that all classes have at least members enrolled. For each member, the center also keeps track of the date of enrollment, and the class completion status.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started