Reference no: EM131184384
Assignment - Entity-Relationship Modeling
Please submit the three parts of this assignment using this document.
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.
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 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
|
|
|
|
|
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.
Define a class for rational numbers
: Define a class for rational numbers. A rational number is a number that can be represented as the quotient of two integers. For example, 1/2, 3/4, 64/2, and so forth are all rational numbers.
|
Design an amplifier to have nominal closed-loop gain
: If component value variation in the B network may produce as much as ±1% variation in B, to whatvalue must A be raised to ensure the required minimum gain?
|
Discuss the types of mangers that your business will need
: Discuss the types of mangers that your business will need. - What types of teams will they need to manage in order to positively impact the business?
|
How do you see technology impacting the future of education
: Read "Evaluating the Effectiveness of Technology in Our Schools" and "Technology in the Classroom." How do you see technology impacting the future of education
|
Write a detail document about the various business rules
: 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.
|
Analyze your listening performance
: Identify whether you let the person know, by your words or actions, you cared about his or her dilemma, even if you were not able to help in any other way. Analyze your listening performance
|
Personal communication style for internet company executive
: What is your evaluation of this type of personal communication style for an Internet company executive?- How does this message affect the emotions and attitudes within the organizations?
|
What is the electric field intensity in the dielectric
: Polarization in dielectrics. The space between two large parallel plates, separated a distance d = 0.1 mm is filled with a dielectric with relative permittivity of 4. The plates are connected to a 12 V battery.
|
Formulate a linear programming problem
: Formulate as a linear programming problem by defining the decision variables, stating the objective function and stating the constraints.
|