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.

Reviews

Write a Review

 

Database Management System Questions & Answers

  System analysis hi this is mohammed i need your help kindly

hi this is mohammed i need your help kindly find the attached file and try to finish at the soonest as i need to submit

  1 what is meant by data independence explain your answer2

1. what is meant by data independence? explain your answer.2. identify two benefits of separating application software

  Describes a suitable methodology from the literature

Describes a suitable methodology from the literature for the purpose of designing, constructing and testing of a commercial BIDW for a multinational company.

  What suppliers have sold more than 10000 euros

Define main key and foreign key. Represent graphically the relational data base, with its tables and connections of foreign keys. Follow this rule: 1:N connections is represented table with just one line above and table with multiple lines below.

  Hsada systems analysis and design

Determine and confirm client business expectations and needs and determine and apply appropriate development methodologies

  What type of entertainment events are the most popular

What type of entertainment events are the most popular? Has this always been the case or has there been a shift in recent years - Which area of venues used for organizing events is most popular in past 10 years?

  Access values through queries to databases

However, the only way you can access values is through queries to the databases. In single query, you can specify value k to one of two databases.

  Design of a data warehouse

Enterprises are accumulating substantial amounts of data that are necessary for their business operations.

  Database systems1 list the acid properties explain the

database systems1. list the acid properties. explain the usefulness of each.2. consider the following two transactions

  Write a select statement that answers this question

Write a SELECT statement that returns these columns - Write a SELECT statement that answers this question: Which customers have ordered more that one product? Return columns:

  Use three-sphere model for systems management

Use the three-sphere model for systems management and brainstorm issues related to the change based on the business, technology, and organization spheres.

  Explain the life cycle of an information systems

Imagine that you run a photography printing store. Your employees have been using punch cards for time entry since you started the business.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd