Reference no: EM13853635
Critical Thinking Assignment - week 3
Assignment Choice 1 Entity-Relationship Modeling
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:
- 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).
- For each recognized attribute, identify if it is a primary key with an X in the Primary Key column.
- 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.
|
Explain how e-commerce planning is similar store planning
: Discuss the various factors that need to be considered when planning to launch an e-commerce website. Explain how e-commerce planning is similar to and different from traditional brick-and-mortar store planning.
|
|
Provide specific in-depth comment instead of general comment
: You are expected to read beyond textbooks and able to apply the knowledge gain from real life examples either from your working environment. You are encouraged to provide specific in-depth comments instead of general comments.
|
|
Personal control of the individual
: Attribution theory suggests that when we observe an individual's behavior, we attempt to determine whether it was internally or externally caused. Internally caused - those that are believed to be under the personal control of the individual.
|
|
What ways might it be less just way of viewing murder
: Islamic law views murder differently from the way murder is viewed in either common law or civil law systems. In what ways might the Islamic perspective be a more just way of viewing murder and in what ways might it be less just way of viewing mu..
|
|
Entity-relationship modeling
: 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.
|
|
Explain what significant differences you would need
: Explain all the procedures involved in proving or refuting your hypothesis. Explain what significant differences you would need to find to confirm or refute hypothesis
|
|
How would you respond to rn jolie
: How would you respond to RN Jolie when she tells you to lie about what happened to Mrs Davis and what are your responsibilities in this situation and what should you do to stay within the boundaries of professional nursing practice
|
|
Identify a workplace problem that you are familiar
: Identify a workplace problem or an opportunity that you are familiar with in day to day job - "we do not provide enough time for testing," "the plastic coffee cups leak," or "We accept changes in requirements.
|
|
Important component of the american judicial system
: Citizen participation in the court process is an important component of the American judicial system
|