Define the minimum and maximum cardinality

Assignment Help Database Management System

Reference no: EM13756431

Assignment: Entity-Relationship Modeling

Let us consider the information that your school tracks for a class. In this instance, a class is a scheduled course. For example, your school may offer FINA 2100- Introduction to International Financial Markets as a course. If the school offers it in the fall, then it becomes a class. Below, we have provided some basic business rules and many pieces of information that your school probably tracks about the class:

• A course may (or may not) require one or more prerequisite courses, and a course may (or may not) serve as a prerequisite of other courses.
• Each course belongs to a specific department and a department can have many courses.
• One or more sections of a course will be scheduled each semester at different times of the day and on different days of the week.
• One instructor will teach a scheduled course section in a specific classroom. The same classroom can be used for many different course sections at different times.
• A department has many instructors and an instructor may teach for multiple departments.

Part 1: Complete the table

Fill out the table by following these instructions:

1) For each piece of information that the school wants to track, identify if it is an entity or an attribute (place an X in the appropriate column).

2) For each recognized attribute, identify if it is a primary key with an X in the Primary Key column.

3) Identify the entity to which the Primary Key belongs (write the name of the entity in the last column

INFORMATION	ENTITY	ATTRIBUTE	PRIMARY KEY	ENTITY THAT ATTRIBUTES BELONG TO
Department	X
Course Number		X	X	Course
Course	X
Course Name
Course Description
Number of Credit Hours
Instructor Name
Room Number
Time of Day
Day of Week
Instructor ID
Department ID
Department Name
Class Schedule
Class Section Number
Room Capacity
Instructor
Room

Part 2: Write a detail document

Using the provided information, write a detail document about the various scenarios described in Part 1 with respect to entities and their relationships. The E-R diagram will be created from your findings. Don't worry about going through the normalization process at this point. Identify the appropriate relationships among the entities, and define the minimum and maximum cardinality of each relationship. Make some additional assumptions about the business rules, if necessary.

Part 3: Create an E-R Diagram

Draw the initial E-R diagram based on the given business rules and the scenarios you defined in your detail document. Include a screen shot or jpeg of the E-R diagram.

Reference no: EM13756431

Questions Cloud

Particularly suited for multichannel-interactive marketing : Which product or service have you recently encountered that would be particularly suited for multichannel or interactive marketing? Why?

Implementing wheatley theories : Transformational thinking often requires a paradigm shift. Much of your MBA coursework has focused on the processes and skill set of the dominant management paradigm. How will you integrate these new perspectives into your business acumen? Identify t..

Elements of the mcdonald organization : Complete the four elements of the McDonald's organization chart exercise in the Assurance of Learning Exercise 7A on page 248 of the textbook.

Expand your business to the global market : The organizational ethics in US corporations is often different than the ethics and legal compliance in foreign countries. How do these differences impact the globalization of business? If you were going to expand your business to the global market, ..

Define the minimum and maximum cardinality : Don't worry about going through the normalization process at this point. Identify the appropriate relationships among the entities, and define the minimum and maximum cardinality of each relationship. Make some additional assumptions about the bus..

What ways did american society undergoe major changes : what ways did American society undergoe major changes in the early nineteenth century?

What are the current health care policy issues : Question# 1: What are the current health care policy issues in NY state? Is the state doing anything to enhance any health care issues, and is NY state doing enough?

Minimum-cell-cost method and vogels approximation method : In terms of logic or scientific reasoning, distinguish among the following three methods of developing an initial transportation solution: northwest corner method, minimum-cell-cost method, and Vogel’s approximation method.

Controlling the weight of a box of cereal : As a quality analyst you are also responsible for controlling the weight of a box of cereal. The Operations Manager asks you to identify the ways in which statistical quality control methods can be applied to the weights of the boxes.

User Account

All Pages