Question: 21. _____ are important because they help to ensure data integrity. a. Attributes b. Entities c. Relationships d. Constraints 22. A(n) _____ exists when there

21. _____ are important because they help to ensure data integrity.

a.

Attributes

b.

Entities

c.

Relationships

d.

Constraints

22. A(n) _____ exists when there are functional dependencies such that Y is functionally dependent on X, Z is functionally dependent on Y, and X is the primary key.

a.

partial dependency

b.

repeating group

c.

atomic attribute

d.

transitive dependency

23. In a(n) _____ diagram, the arrows above the attributes indicate all desirable dependencies.

a.

Chen

b.

dependency

c.

functionality

d.

ER

24. A table that is in 2NF and contains no transitive dependencies is said to be in _____.

a.

1NF

b.

2NF

c.

3NF

d.

4NF

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

please answer these multiple choices . and please make sure to be correct . Thanks CHAPTER 2: (Multiple Choice) Circle the correct answer (3 each 60 points) 21. A(n) s main function is to help one...

Q:

Introduction Welcome to the final project for CS504 Principles of Data Management and Mining. This project aims to test your understanding of the concepts covered throughout the course, such as...

Q:

CIS 620/B Project Plan For the Global Collaboration Enterprise Information System 1200 12th Avenue, Suite 1200 Seattle, Washington 98114 U.S.A. November 11, 2015 Draft Version 19.0 November 11, 2015...

Q:

U.S. Army Cost Benefit Analysis Guide 12 JANUARY 2010 Prepared by Office of the Deputy Assistant Secretary of the Army (Cost and Economics) Version 1.0 U.S. Army Cost Benefit Analysis Guide - V 1.0 2...

Q:

This is my college Database coursework. I have a problem regarding making the erd diagrams and normalization(UNF, 1NF, 2NF, 3NF). I hope you would help me in making this along with the final erd...

Q:

Pick a case and become familiar with the case requirements. Use what you learned on chapter 19. For formatting, use times new roman 12 pt font and double space your answers. You must include...

Q:

The current issue and full text archive of this journal is available at www.emeraldinsight.com/0957-4093.htm IJLM 17,3 Realities of supply chain collaboration 312 Tilburg University, Tilburg, The...

Q:

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

Q:

The UT system is trying to create and convert their student records into digital form. The idea behind this database is to list all students in UT system colleges/universities with their Name, major,...

Q:

Please help me make an Executive Summary. Explain what you will examine in the case study. Write an overview of the field you are researching. Make a thesis statement and sum up the results of your...

Q:

A refrigerator manufacturer, Zero King, issued a zero coupon bond with 10 years to maturity. What is the yield-to-maturity of this bond if it is sold for $352?

Q:

Consider the following information taken from the stockholders equity section: Required: 1. Calculate the following for 2012 (Note: Round answers to two decimal places): Stockholder Payout...

Q:

Investors in GNMA pass - through securities are exposed to the risk that the originating bank may fail, and the risk that the trustee may mismanage monthly interest and principal payments collected.

Q:

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...