top-rated free essay

PT2520 Unit4 Assignment1 Homework

By Lajamerr Dec 02, 2014 313 Words
Unit 4True/False Questions
Indicate whether the following statements are true or false on the student answer sheet.

1 T | Normalization is the process of removing anomalies from database design. 2 T | Not being able to insert data because other data is required is an example of an insertion anomaly. 3 F | An insertion anomaly occurs when you enter data inaccurately. 4 T | An update anomaly occurs when you have to update the same data in multiple places. 5 F | A deletion anomaly occurs when you are unable to delete data in a primary key table because a foreign key table contains records related to that data. 6 T | Normal forms are sets of rules designed to remove anomalies and redundancy from database design. 7 T | The First Normal Form removes all repeating groups and arrays. 8 T | Rather than put several values in a single column, you should create several columns and number them like column1, column2, etc. 9 T | Second Normal Form removes functional dependencies.

10 T | Functional dependencies consist of groups of related attributes that form subsets within an entity. 11 T | Failure to normalize a database can lead to numerous problems. 12 T | Third Normal Form removes transient dependencies.

13 T | A transient dependency is where an attribute depends on another attribute for its meaning and not on the key. 14 F | If you know you are going to denormalize your database, you don't need to normalize it in the first place. 15 T | Denormalization should never be done lightly.

16 F | You should limit repetition of attributes to the repetition of the primary key as a foreign key in a related table. 17 T | Each individual attribute should represent only one type of value. 18 F | There are only three normal forms.

19 T | One way to think of functional dependencies is as separate themes in the same table or entity. 20 F | Normalization is about designing databases so they work well on the computer, not about readability.

Cite This Document

Related Documents

  • homework

    ...TCO 1) What is the purpose behind the five primary activities in the value chain? First, info flow diagrams and flowcharts argon the two most much utilize development and musical accompaniment tools employ today. Second, since systems developme nt is super complex, DFDs and flowcharts ar! e tools that are used to fix order from sanatorium and c...

    Read More
  • PT2520

    ...Lab 10 Course Project Purpose In this final lab, you will apply the knowledge acquired from Units 4-9 of this course to completing a project, which will require the following skills: Creating tables Creating a composite key Adding columns to an existing table Creating a stored procedure to guard against a SQL injection attack Granting permiss...

    Read More
  • Assignment1

    ...Individual Assignment 1: The Marketing Environment Nokia used to be the market leader in the mobile phone industry. What environmental factors do you think affected the viability of Nokia? Nokia used to be the market leader in the mobile phone industry. Its Symbian Series 60 was one of the smart phone pioneers. However after the intro...

    Read More
  • Assignment1

    ...customers will be charged the same meal price, Billy must determine what price to charge for a meal ($12, $15, $18). 1. Use an Excel feature in cell B13 to allow a user of this model to click on cell B13 and select (or set) one of the three buffet meal price options from a dropdown list. 2. In the Weekly Budget Forecast section of the spreadshee...

    Read More
  • Assignment1

    ...ITC6000 – Assignment 1 Please answer the following questions: Question- 1 Use the table in the data file below to answer these questions regarding file structure: 1. 2. 3. 4. 5. How many records does this file contain? How many fields are there per record? What problem would you encounter if you tried to create a listing by last name? What a...

    Read More
  • homework

    ...Claire Drexler P2 Characteristics Used To Identify a Substance 1. We use chemical and physical properties to identify a substance. 2. Examples of physical properties: color, smell, freezing point, and viscosity 3. Examples of chemical properties: heat of combustion, PH, and electromotive force Physical Properties vs. Chemical Prop...

    Read More
  • Homework

    ...Facts you need to know to pass the Living Environment Regents Exam Cellular biology 1. The ability of an organism to maintain internal stability is known as______________________. 2. ________________-the sum of all the chemical reactions that occur within the cells of an organism. 3. Organic molecules contain both________________ and ___...

    Read More
  • Homework

    ...Viet Nguyen Professor Hinojosa Essentials of Accounting March 2, 2012 Week 1 Assignment Chapter 1 E1-3 Accounts payable and accrued liabilities | ___L__ | __O___ | Accounts receivable | ___A__ | ___O__ | Property, plant, and equipment | __A___ | ___I__ | Food and beverage operations revenue | ___R__ | __O___ | Golf course operatio...

    Read More

Discover the Best Free Essays on StudyMode

Conquer writer's block once and for all.

High Quality Essays

Our library contains thousands of carefully selected free research papers and essays.

Popular Topics

No matter the topic you're researching, chances are we have it covered.