Question
Draw an ER model using clearly denoting maximum and minimum cardinality constraints . Write the one liner and four sentences for each diagram (statements that
Draw an ER model using clearly denoting maximum and minimum cardinality constraints.
Write the one liner and four sentences for each diagram (statements that specify the minimum and maximum cardinality), and the number of tables needed. Post the Primary and foreign keys and any available attributes.
Here is an example answer. Please follow this IF possible I would appreciate it very much.
Here is the question: A class is taught by one faculty, but a faculty can teach many classes. A faculty need not teach any classes but class must be taught by a faculty. A faculty has facultyid, name, address, and department. A class has an ID, name, location, meeting time, and a textbook.
1. Cincinnati String Academy Cincinnati String Academy teaches violin, viola and other stringed instruments to young children. The classes are structured in sessions that start and end at a given date. A music student can enroll for multiple classes in the same session. A class is a particular time slot within a session, and this allows students to enroll in multiple classes in the same session. The fee is based on the number of classes enrolled. A class can have a maximum of 10 students. A student can take a maximum of 3classes. A student can be in the roster without currently enrolling in any class and a class can exist without a single student while waiting for student enrollment before the registration date One Liner: Students enroll in classes ER Diagram: Classes Students class ID (PK) student (PK) startTime is enrolled in firstName end Time lastName session (0,10) (0,3) instrument address phoneNumber fee Four Statements: Maximum Cardinality One student can enroll in up to 3 classes. One class can have up to 10 students enrolled. Minimum Cardinality (Participation): A student need not enroll in a class. A class need not have any students. Number of Tables: 3Step 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