test prep - Normalization is an analytical process that is...

Info iconThis preview shows pages 1–4. 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

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: Normalization is an analytical process that is used to verify that the entities, and the attributes that are assigned to those entities, follow certain design rules for relational databases. TRUE When normalization requires that a table be separated into two tables it must be accomplished so that no information is lost.- TRUE The tables that we need to test for 2NF are those with a composite primary key If the normalization rules for database design are not enforced, excess data redundancy can occur affecting the efficient use of the database. TRUE The First Normal Form Method states that, to convert a table to first normal form identity repeating groups move them to a separate table. Which anomaly states, if a product exists on only one order line item and that line item is deleted, the information about that products name and price is lost?- deletion anomaly A table is in 3NF if it is in 2NF and every determinant is a candidate key? is the rule for: - boyce codd normal form If data designers to not follow normalization rules, problems can occur with adding new data, changing data, or deleting data from the database. These problems are called anomalies . A composite key is a primary key that consists of two or more attributes. The combination of these two attributes identifies only one row in the table. A transitive dependency occurs if a primary-key attribute can be determined by another primary-key attribute. False *A transitive dependency occurs if a "non"-key attribute can be determined by another "non"-key attribute. Composite keys are required in tables that implement one-to-many relationships True, Many to Many A relation is in normal form if it is in 1NF and every non-key attribute is fully functionally dependent on the primary key- 2 nd normal form A transitive dependency occurs if a non-key attribute can be determined by another non-key attribute. A table is in first normal form (1NF) if all attributes are atomic True An example of a redundancy might be if a customer address is stored in more that one place. TOPIC ONE Importance of Data Few careers that do not require either entering data, using data, or analyzing data to make decisions Data design is a major component of every new systems project Data is a corporate asset Data pervades our everyday lives Information Systems Components Hardware Software Data Data is central. Other components used to collect, store, analyze, or share the data People Procedures Networks Data uses To influence and persuade people...
View Full Document

This note was uploaded on 03/17/2008 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Spring '08 term at Pennsylvania State University, University Park.

Page1 / 17

test prep - Normalization is an analytical process that is...

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

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