ER Diagram

  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 that the Primary Key belongs to (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 Description X  
Number of Credit Hours X  
Instructor Name X  
Room Number X X Room
Time of Day X X Section
Day of Week X X Section
Instructor ID X X Instructor
Department ID X X Department
Department Name X  
Class Schedule X  
Class Section Number X  
Room Capacity X  
Instructor X      
Room X      

 

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.

Unlike most other websites we deliver what we promise;

  • Our Support Staff are online 24/7
  • Our Writers are available 24/7
  • Most Urgent order is delivered with 6 Hrs
  • 100% Original Assignment Plagiarism report can be sent to you upon request.

GET 15 % DISCOUNT TODAY use the discount code PAPER15 at the order form.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total: