Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.**

image text in transcribed

Here is the question: Employees have an id, name, department and datejoined. A manager who is also an employee is managing a department and can be a manager of several employees in that department.

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: 3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Driven Web Sites

Authors: Joline Morrison, Mike Morrison

2nd Edition

? 061906448X, 978-0619064488

More Books

Students also viewed these Databases questions