NEED COMPLETED ASAP

profilezeaird

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

Part 1: Complete the table.
Part 2: Write a detail document about the various business rules and define how the described scenario works with respect to entities and their relationships.
Part 3: Create an E-R Diagram.

INSTRUCTIONS:

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

   

 

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 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. You may want to review the assignment criteria found in the Rubric under "Course Information" in the left navigation pane.

Assignment Choice #2CRUD – Defining Information Ownership 

One easy way to determine information ownership is to think of CRUDcreate, read, update, and delete. If you cannot only read but also create, update, and/or delete information, then in some way you own that information because you are responsible for its quality.

Here again, let’s consider your school as an example and focus on your personal and transcript information. That information includes your student ID, name, address, phone number, GPA, declared major, declared minor (if you have one), and courses completed (your transcript).

Part 1: Identify Create, Update, and Delete Privileges
For each piece of information, first identify who has create, update, and delete privileges. Include any individuals or departments that have these sorts of information privileges. There may be several. If so, who is ultimately responsible for your personal and transcript information? Second, identify all the groups of people at your school who can only view (read) your information.

Part 2: Develop a CRUD Matrix 
Develop a CRUD matrix that outlines the relationships among the pieces of information and user privileges (example: http://ocean.otr.usm.edu/~w300778/is-doctor/pubpdf/sc2008.pdf).

Part 3: Write a Detail Document
Write a detail document about the various business rules that define how the scenario described in Part 1 works with respect to information ownership and their relationships. Identify the appropriate relationships among the information, and define the minimum and maximum privileges associated with each relationship.

Your paper must be a minimum of two pages, double-spaced and comply with CSU-Global Guide to Writing and APA Requirements. You may want to review the assignment criteria found in the Rubric under "Course Information" in the left navigation pane.
    • 9 years ago
    • 20
    Answer(3)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      assignment_choice_1.docx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      mis_300_module_3_option_1_entity-relationship_modeling.docx

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      docx_2.docx
    Bids(1)