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

  E-businesss technologies and software

E-businesss technologies and software and Can you help me get started with this assignment?

  Why is knowledge management particularly important

Why is knowledge management particularly important to a company that wants to become a learning organization?

  Accounting information systems ais database software

accounting information systems ais database software systemsquestion 1discuss some of the diferences between the

  Question 1a classify the subsequenta presentation serverb

question 1a classify the subsequenta. presentation serverb. application serverc. database serverd. software application

  Training needs assessment

Training needs assessment - Explain the problem and examine the needs (using the analyses above)

  Required resources in system implementationhow do you

required resources in system implementationhow do you evaluate number of required resources in system

  Develop a security awareness plan for employees

What are the company's major information security threats and Develop a security awareness plan for employees and franchisees

  Multinational organization from a global organization

Transnational and Multinational Organizations - This solution explains how you would differentiate a transnational or multinational organization from a global organization.

  Role and function of the inventory types that exists within

role and function of the inventory types that exists within the supply chaindescribe the role and function of each

  Forecasting methods explained in this solutionhello thank

forecasting methods explained in this solutionhello thank you for taking the time to look and consider my posting on

  Define each of the following- mis tps dss and ai

Information systems typically support different work models. You have been asked to create a report on what work models exist, and which model is most applicable to your organization. Define each of the following: MIS, TPS, DSS, and AI

  Systems analysts and project managers to projects

The IS management position the coordinates all systems maintenance projects, allocates systems analysts and project managers to projects, and schedules development work is the:

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