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

Info icon This preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
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 product’s 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 . 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 transitive dependency  occurs if a non-key attribute can be determined by another non-key attribute. 
Image of page 1

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

View Full Document Right Arrow Icon
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
Image of page 2
People Procedures Networks Data uses
Image of page 3

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

View Full Document Right Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern