Bear, Acct 425, Assignment 5-1

Bear, Acct 425, Assignment 5-1 - Bear, ACCT 425, 5-1 D2. In...

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

View Full Document Right Arrow Icon
Bear, ACCT 425, 5-1 D2. In creating relational tables we have three objectives. Explain what these objectives are, and how we attempt to meet them in converting a conceptual model into relational tables. Do any of these objectives contradict each other, and if so, to which do we give precedence? When creating relational table there are three objectives that you need to following. The first one is referential integrity and it states that a value for a foreign key attribute must either be null or match one of the data values in the table in which the attribute is a primary key. The Second objective is called entity integrity which states that a primary key of a relational table must not contain a null value. This guarantees the uniqueness of entities and enables proper referencing of primary key values. The third and last objective is to follow the one-fact, one-place rule which can most likely be avoided all together if you follow the 5 steps for converting a conceptual entity-relationship model into relational tables. D3. Explain the rule used to create relational database table from a conceptual model
Background image of page 1

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

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

This note was uploaded on 09/27/2010 for the course ACCT 425 taught by Professor Terawooten-tanner during the Summer '10 term at Franklin.

Page1 / 2

Bear, Acct 425, Assignment 5-1 - Bear, ACCT 425, 5-1 D2. In...

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