Define and draw the basic relationships among entity classes

Assignment Help Management Information Sys
Reference no: EM13749580

Scenario

In conjunction with taking MIS 200, Drexel has decided to test the idea of offering weekend seminars to cover the basics of the Internet and the Web. Initially, Drexel will offer two such seminars: Web101 - The Basics of the Web and Internet, and Web205 - Building a Web Site. Web 101 will have five different sections, and Web 205 will have four different sections.

Although they are not required to, students can enroll in one or both seminars. The seminars are held for eight hours on a single day. There is no cost associated with taking the seminars. One instructor, from a pool of qualified instructors, will be assigned to each section of each seminar. Some instructors will obviously not be assigned to teach any of the sections, and some instructors may be assigned to several different sections.

The system should track the final grades assigned to each student. Drexel is simply testing this idea in this particular term. So, don't worry about the term (e.g., Fall, Winter, Spring, or Summer) or the year.

Phase 1

For the above scenario, create a simple two-column table that lists all the entity classes in the left column and their associated primary keys in the right column. Then, record as many business rules as you can find provided in the scenario.

Phase 2

In this phase, define and draw the basic relationships among the entity classes.

If you correctly completed Phase 1, you know there are four entity classes.

Your task is to define among which of those entity classes relationships exist and then write some verbs that describe each relationship.

Phase 3

In this phase, you are to define the cardinality among entity classes.

Your tasks is to create the numerical relationships by adding the symbols of |, O, and ← (crow's foot) in the appropriate places.

Phase 4

In this phase, you are to eliminate a many-to-many relationship. If you correctly completed phase 3, you will be able to identify a many-to-many relationship between _____ and ______. You need to eliminate this many-to-many relationship by creating an intersection relation. What did you name the intersection relation? What does the completed E-R diagram look like?

Reference no: EM13749580

Questions Cloud

Working with an income statement and balance sheet : Prepare a balance sheet and income statement for Beblond, Inc. from the following information.
How does the production volume affect break-even analysis : How does the production volume affect break-even analysis. Could a service firm use a production-line approach or self-service design and still keep a high customer focus (personal attention)
What is the marginal revenue product of the fourth worker : What new decisions will you make regarding production levels and pricing for your Widget facility - what is that firm's marginal revenue as it increases output from 160 units to 180 units?
Describing what is known of the tribes pre-columbian history : Describing what is known of the tribe's pre-Columbian history, including settlement dates and any known cultural details. Describing the cultural and religious beliefs of the chosen tribe.
Define and draw the basic relationships among entity classes : For the above scenario, create a simple two-column table that lists all the entity classes in the left column and their associated primary keys in the right column. Then, record as many business rules as you can find provided in the scenario. defi..
Carefully design a program for modifying the behavior : Carefully design a program for modifying the behavior, making sure to include all relevant conditioning principles incorporated within your plan (which might include the use of positive and negative reinforcers, punishment, shaping, schedules of rein..
The current organizational structure at domino''s : Determine whether the current organizational structure at Domino's is a good match for its corporate strategies. Explain your rationale. Evaluate alternative structures to determine which one would be most appropriate for Domino's to consider and ..
Describe the process of counter-conditioning : Describe the process of counter-conditioning including a real- life event depicting this process. You must cite and reference any sources in APA style. Otherwise, it is considered plagiarism.
Explain the case of stella liebeck vs. macdonald''s : Explain the case of Stella Liebeck vs. MacDonald's. Could government regulation have prevented this accident. Why or why not? Consider issues of product liability, product safety, and legal paternalism in your answer.

Reviews

Write a Review

Management Information Sys Questions & Answers

  Information technology and the changing fabric

Illustrations of concepts from organizational structure, organizational power and politics and organizational culture.

  Case study: software-as-a-service goes mainstream

Explain the questions based on case study. case study - salesforce.com: software-as-a-service goes mainstream

  Research proposal on cloud computing

The usage and influence of outsourcing and cloud computing on Management Information Systems is the proposed topic of the research project.

  Host an e-commerce site for a small start-up company

This paper will help develop internet skills in commercial services for hosting an e-commerce site for a small start-up company.

  How are internet technologies affecting the structure

How are Internet technologies affecting the structure and work roles of modern organizations?

  Segregation of duties in the personal computing environment

Why is inadequate segregation of duties a problem in the personal computing environment?

  Social media strategy implementation and evaluation

Social media strategy implementation and evaluation

  Problems in the personal computing environment

What is the basic purpose behind segregation of duties a problem in the personal computing environment?

  Role of it/is in an organisation

Prepare a presentation on Information Systems and Organizational changes

  Perky pies

Information systems to adequately manage supply both up and down stream.

  Mark the equilibrium price and quantity

The demand schedule for computer chips.

  Visit and analyze the company-specific web-site

Visit and analyze the Company-specific web-site with respect to E-Commerce issues

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