Chapter 6 - Chapter 6 1. In a relational database table,...

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

View Full Document Right Arrow Icon
Chapter 6 1. In a relational database table, the table's intension consists of its A) Cells B ) Rows C ) Columns D ) Relationships E ) Referential integrity 2. In relational database design, a primary key of one table that is also included in another table A) Usually indicates that someone made a mistake in deriving the tables and has added undesirable data redundancy into the database. B) Usually results in null values being introduced into the database. C) Usually ensures that we can get all the information we need to make a decision by querying only one table or the other (i.e., we would not need both tables in the same query). D ) Usually uniquely and universally identifies each instance in both tables in which it is included. E ) Usually establishes a connection between the tables so they can be linked to generate useful information. 3. When converting entity-relationship models into relational tables, A) One to one (maximum cardinalities) relationships should always be implemented with a separate table. B) Every relationship should be implemented with a separate table. C) A one to many (maximum cardinalities) relationship should be implemented by posting the key of the one entity table into the many entity table. D)A one to many (maximum cardinalities) relationship should be implemented by posting the key of the many entity table into the one entity table. E ) Both B and D above are true.
Background image of page 1

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

View Full DocumentRight Arrow Icon
4. Given the following conceptual model, which would be the most appropriate relational table implementation choice? A ) Implementation Choice #1 B ) Implementation Choice #2 C) Implementation Choice #3 D) Implementation Choice #4 E ) Implementation Choice #5 5. When creating a new database in Microsoft Access, at what point is the user REQUIRED (i.e., the latest possible time) to name the database file within the Access software program? A)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the 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 / 8

Chapter 6 - Chapter 6 1. In a relational database table,...

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

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