Project #26782 - Information Technology

Question 2 Business Rules

Please use this four-row format when writing your connectivity-determining business rules.

Figure 1. Publisher Database

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 – 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 "1" entity type and which is the "M" entity type.

Be sure the connectivity row for each 1:M relationship has the correct direction. The rule with the multiplicity "many" will determine the direction. For example, if the rule is: "ONE Publisher may publish MANY Books", then Publisher is the "1" table and Book is the "M" 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 the three binary relationships other than Publisher – Book.

Question 3 Primary Key / Foreign Key Placement

The primary key of a table is often named after the table. Example: ISBN-13 would be chosen as the name of the primary key for the Book 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    



(Hint 1 – There may not be a foreign key attribute if the entity is not on the “M” side of a relationship)

(Hint 2 – Some foreign key attributes and the associative entity set in the table are not shown in Figure 1.)

Question 4 Entity Relationship Diagram

Part A. Update the ERD from Question 2 to account for the M:N relationship between Book and Author.

Part B. The report below shows the fields to identify the review of books by customers. Follow either the Top Down Database Design of the Bottom Up Database Design approach to extend the ERD from Question 2. Provide the new ERD. Include a 4–6 sentence paragraph describing how you chose the approach you used to extend the ERD and the process followed.

Subject Computer
Due By (Pacific Time) 04/05/2014 10:00 pm
Report DMCA
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

out of 680 reviews
More..
All Rights Reserved. Copyright by AceMyHW.com - Copyright Policy