Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use UML notation model 3. Computer and Information Science College (CCIS) database A college divided into four schools. A Dean who is a professor

please use UML notation model
image text in transcribed
3. Computer and Information Science College (CCIS) database A college divided into four schools. A Dean who is a professor administers each school. Each professor cannot be a dean of more than one school. It is not necessary that each professor need to be a dean of the school. At least one department should be there in a school. Each department belongs only to a single school \& each school has many departments. Each department may offers courses but not all the department (Research Department do not offer courses). The department may offer several sections (classes), each of those classes is taught by a professor at a particular time and place. Each department has one or more professor, one and only one professor can be the chair of the department, and no other department professor is required to accept the chair positions. Each professor may teach maximum four classes or none. Each class is a section of a course Create an Entity Relationship diagram with UML Model that captures this information about the CCIS. Be certain to indicate identifiers and cardinality constraints

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

Oracle Database 11g SQL

Authors: Jason Price

1st Edition

0071498508, 978-0071498500

More Books

Students also viewed these Databases questions