Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i A Class has attributes: Clasle and EnrollmentLimit. o A Teacher teaches none, one or several Classes ofa Unit. 0 A Session is assigned to

image text in transcribed
image text in transcribed
i A Class has attributes: Clasle and EnrollmentLimit. o A Teacher teaches none, one or several Classes ofa Unit. 0 A Session is assigned to a Teacher. 0 A Schedule is created for each Year and Semester. A Schedule links Sessions, Rooms and corresponding Classes. 0 A Teacher uses none, one or several types of Media. Your assignment submission consists of two parts. Part 1. Conceptual Model 0 Identify Entities 0 Identify entity supertypes and subtypes and their types, inheritance, and discriminators. 0 Describe relationships between entities and their cardinalities 0 Identify entity primary keys 0 Draw a Conceptual Model Entity-Relationship diagram Part 2. Logical Model 0 Describe data attributes and their types for each entity 0 Redesign the Conceptual model removing many-to-many relationships {if any] 0 Identify primary, composite (if any) and foreign keys (if any) for each entity 0 if there are any one-to-one relationships then describe them 0 Draw a Logical Model diagram

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

Elementary Number Theory

Authors: Underwood Dudley

1st Edition

0486134873, 9780486134871

More Books

Students also viewed these Mathematics questions

Question

How to Calculate the Regression Line

Answered: 1 week ago

Question

Can anyone help solve this?

Answered: 1 week ago

Question

What are the purposes of promotion ?

Answered: 1 week ago

Question

The relevance of the information to the interpreter

Answered: 1 week ago

Question

The background knowledge of the interpreter

Answered: 1 week ago