Critical Thinking Assignment 85 Points Important Read 808285

Critical Thinking Assignment85 Pointsimportant Read Firstchoose One

Critical Thinking Assignment85 Pointsimportant Read Firstchoose One

Choose one of the following two assignments to complete this week. Do not do both assignments. Identify your assignment choice in the title of your submission.

Assignment Choice #1 : 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.

Submit all three parts of this assignment in one document called CT03 assignment. The document can be found on the course information page with the course documents.

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).

The first three rows are filled in to provide an example of how the table should be completed.

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

Part 2: Write a detail document

Using the provided information, write a detailed 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. 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 in the CT03 assignment document for submission. Your paper must be a minimum of two pages, double-spaced, and comply with CSU-Global Guide to Writing and APA Requirements.

Related Assignments