Information system. Entity-Relationship Modeling.<\/p>\n
Please submit the three parts of this assignment using this document below.<\/p>\n
Part 1: Complete the table.
\nPart 2: Write a detail document about the various business rules and define how the described scenario works with respect to entities and their relationships.
\nPart 3: Create an E-R Diagram.<\/p>\n
Part 1: Complete the Table
\nFill out the table by following these instructions:<\/p>\n
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).
\nFor each recognized attribute, identify if it is a primary key with an X in the Primary Key column.
\nIdentify the entity that the Primary Key belongs to (write the name of the entity in the last column).<\/p>\n
The first three rows are filled in to provide an example of how the table should be completed.<\/p>\n
INFORMATION
\nENTITY
\nATTRIBUTE
\nPRIMARY KEY
\nENTITY THAT ATTRIBUTES BELONG TO
\nDepartment
\nX<\/p>\n
Course Number<\/p>\n
X
\nX
\nCourse
\nCourse
\nX<\/p>\n
Course Name<\/p>\n
Course Description<\/p>\n
Number of Credit Hours<\/p>\n
Instructor Name<\/p>\n
Room Number<\/p>\n
Time of Day<\/p>\n
Day of Week<\/p>\n
Instructor ID<\/p>\n
Department ID<\/p>\n
Department Name<\/p>\n
Class Schedule<\/p>\n
Class Section Number<\/p>\n
Room Capacity<\/p>\n
Instructor<\/p>\n
Room<\/p>\n
Part 2: Write a Detail Document
\nUsing 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\u2019t 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.<\/p>\n
Part 3: Create an E-R Diagram
\nDraw 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.<\/p>\n","protected":false},"excerpt":{"rendered":"
Information system. Entity-Relationship Modeling. Please submit the three parts of this assignment using this document below. Part 1: Complete the table. Part 2: Write a detail document about the various business rules and define how the described scenario works with Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-17520","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/17520","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=17520"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/17520\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=17520"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=17520"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=17520"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}