Database Design and Data Modeling Unit 2
Outcomes addressed in this activity:
Course Outcomes:
IT525-2: Use data modeling concepts.
IT525-3: Use entity-relation diagrams in the design of a database.
Project Instructions:
Question 1. Definitions
Define each of the following terms (1 pt. each). In addition, provide an example of each term (2 pts. each).
a. Business Rule
b. Entity Set (Entity Type)
c. Entity Instance
d. Attribute
e. Relationship
f. Connectivity
g. Cardinality Constraint
h. Primary Key
i. Foreign Key.
j. Associative Entity
Question 2. Business Rules
Please use this four-row format when writing your connectivity-determining business rules.
Figure 1. Publisher Database<\/p>\n
Explanation of each row in the 4-row format:
(1) Write the entity pair. Underline and\/or bold.
(2) Give one business rule. Indicate the multiplicity of that rule in parentheses.
(3) Give the other business rule. Indicate the multiplicity of that rule in parentheses.
(4) Give the connectivity. (If the connectivity is M:N, give the associative entity name.)
Following is an example of the required four-row format for business rules for a binary relationship for this Assignment.
Publisher \u2013 Book
ONE Publisher may publish MANY Books [M]
ONE Book has ONE Publisher [1]
Publisher 1:M Book.
Complete the same 4-row format for the remaining relationships in the ERD illustrated in Figure 1.
The Unit 2 Enrichment Seminar will have more information about writing these rules and for determining, in a one-to-many relationship, which is the \u201c1\u201d entity type and which is the \u201cM\u201d entity type.
Be sure the connectivity row (row 4) for each 1:M relationship has the correct direction. The rule with the multiplicity \u201cmany\u201d will determine the direction. For example, if the rule is: \u201cONE Publisher may publish MANY Books\u201d, then Publisher is the \u201c1\u201d table and Book is the \u201cM\u201d table, so you would write the connectivity as: Publisher 1:M Books.
Use the four-row format to write the business rules and connectivity for each of the four binary relationships other than Publisher-Book in the enterprise data model pictured above in Figure 1.
Question 3 Primary Key\/Foreign Key Placement
The primary key (PK) of a table is often named after the table. Example: ISBN-13 is chosen as the name of the primary key for the Book table; PublisherID is the PK of the Publisher table.
For each entity set in the table below, give the primary key attribute(s) and the foreign key attribute(s) (if any).
Entity Set Primary Key Attribute(s) Foreign Key Attribute(s)
Publisher
Volume
Book
Book-Author
Author
Country<\/p>\n
(Hint 1 \u2013 There may not be a foreign key attribute if the entity is not on the \u201cM\u201d side of a relationship)
(Hint 2 \u2013 One entity type in the above table is not shown in Figure 1.)
Question 4 Entity Relationship Diagram
Note: If you are going to use the Toolwire virtual desktop to access the Visio application, read the \u201cUsing Toolwire.docx\u201d file in Doc Sharing. That document will explain how to prepare your computer to access the virtual desktop, how to save your work, and how to upload and download files from the virtual desktop.
Part A. Update the ERD from Question 2 to account for the M:N relationship between Book and Author. Start with the diagram in the \u201cIT525_Unit2_Publisher_Q4A.vsd\u201d file. See the \u201cIT525.Unit2.Visio Tutorial\u201d document in Doc Sharing.
Part B. The report form below shows the fields to identify the review of books by customers. Follow either the Top-Down Database Design or the Bottom-Up Database Design approach to extend the ERD from Question 2. Provide the new ERD. Include a 4\u20136 sentence paragraph describing how you chose the approach you used to extend the ERD and the process followed.<\/p>\n","protected":false},"excerpt":{"rendered":"
Database Design and Data Modeling Unit 2 Outcomes addressed in this activity: Course Outcomes: IT525-2: Use data modeling concepts. IT525-3: Use entity-relation diagrams in the design of a database. Project Instructions: Question 1. Definitions Define each of the following terms 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-79884","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/79884","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=79884"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/79884\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=79884"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=79884"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=79884"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}