Assignment 5-1 ch6

Assignment 5-1 ch6 - 1Assignment 5-1 Assignment 5-1...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 1Assignment 5-1 Assignment 5-1 Discussion Questions for Chapter 6 Megan Matthews ACCT425-V3WW- Accounting Information Systems Professor Jerome-Stebens October 6, 2011 2Assignment 5-1 D2. In creating relational tables there are three objectives: 1.) Avoid redundancy 2.) Avoid null values and 3.) Create a minimum database (one that has a few tables as possible). Redundancy avoidance is crucial in relational database design because a table that contains redundancy is NOT relational and most relational database software packages will prevent entry of redundant data. The most critical rule for avoiding redundancy in converting a relationship in a conceptual model into a relational format is to only allow posting of 1 in the relationship being converted. If an entity can participate in the relationship multiple times, then there would be potentially be multiple values of a foreign key to post into the entitys table. To avoid null values in the foreign key fields, post foreign keys only into tables of entities that have mandatory participation in the...
View Full Document

This note was uploaded on 12/17/2011 for the course ACCOUNTING 425 taught by Professor Stebbins during the Fall '11 term at Franklin.

Page1 / 2

Assignment 5-1 ch6 - 1Assignment 5-1 Assignment 5-1...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online