Question: When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity? (choose two options) A.

When you normalize a relation by breaking it into two smaller relations,

When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity? (choose two options) A. Remove any functional dependencies from both relations B. Assign both relations the same primary key field(s) C. Create a primary key(s) for the new relation D. Link the relations by a common field.

Step by Step Solution

★★★★★

3.46 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

The two best option are C and D Since when the relation is normalised it ... View full answer

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 Databases Questions!

What must Verizon do to maintain its competitive advantage going forward in the increasingly competitive US wireless telecommunications industry?

What must parents do to foster conscience development in fearless, impulsive children? How does this illustrate the concept of goodness of fit (see pages 259-260 in Chapter 7)?

What must retailers do to improve customer service on the Web?

The Queen Anne Curiosity Shop sells both antiques and current-production household items that complement or are useful with the antiques. For example, the store sells antique dining room tables and...

You are hired as a marketing intern at Green Airport. It's your first week on the job and your boss just walked into your office announcing the recipients of the Air Service Development Fund (Warwick...

General Instructions Create a new notebook named HW_05_YourLastName.ipynb and complete problems 1 - 8 described below. Download the files diamonds_partial.txt and titanic_partial.txt , placing them...

Suppose your wealthy aunt has given you a gift of $25,000. You have come up with three options for spending (or investing) the money. First, youd like (but do not need) a new car to brighten up your...

Jim Watanabe, the project manager, thought that although the customer loyalty project at Petrie Electronics had gone slowly at first, the past few weeks had been fastpaced and busy. He spent much of...

As a result of the population growth at the end of north Jefferson City over the last five years ( 5,000 people and 2,000 new homes), Mayor McClain has asked you to create a cost effective analysis...

The primary features of MySQL is its ability to store data in tables that are organized in a relational format. Each table contains a set of rows, and each row represents a record or a set of related...

Multiple Choice Questions The following questions are adapted from a variety of sources including questions developed by the AICPA Board of Examiners and those used in the Kaplan CPA Review Course to...

If X 1 and X 2 are the means of independent random samples of sizes n 1 and n 2 from a normal population with the mean and the variance 2 , show that the variance of the unbiased estimator Is a...

QUESTION 5 5 . 1 5 . 2 5 . 3 Find the taxicab distance between the following two points: = ( 4 ; 3 ) = ( 2 ; 2 ) ( 2 ) The ambulance call centre receives a report of an accident at = ( 4 ; 1 ) ....

Potassium superoxide,KO 2 , is often used in oxygen masks (such as those used by firefighters) because KO 2 reacts with CO 2 to release molecular oxygen. Experiments indicate that 2 mol of KO 2 (s)...

For several months Lambi repeatedly made offers to Atkins to buy his Santa Fe Apartments. Finally Atkins wrote Lambi a letter containing the following statement: Here is my suggestion. Clearly $4.2...

Name each of the compounds below, using the IUPAC system of nomenclature. 28. Name each of the compounds below, using the IUPAC system of nomenclature. CI OH (a) (b) HO. (c) (d) 3 (e) (f)

Let U = {M, x, #t| NTM M accepts x within t steps on at least one branch}. Note that M isnt required to halt on all branches. Show that U is NP-complete.

Prove that an n-entry multiway search tree has n+1 external nodes.

What is the general goal of the cell cycle for mitosis? What about meiosis? Tip: Consider the end result of both processes. Describe the similarities and differences between the cytokinesis...

Can somebody give me answers for these problems with explanations? thank you! Be sure to show all of your work when completing these questions This is an individual assignment. 1) Consider the...

Be sure to show all of your work when completing these questions This is an individual assignment. 1) Consider the relation R, with key and functional dependencies shown below I. What Normal form is...

show all work when completing these questions for a clear understanding. Thanks. 1) Consider the relation R, with key and functional dependencies shown below I What Normal form is R in right now?...

1] Consider the following relation: CAR_SALE(Car#, Date_sold, Salesman#, Commission%, Discount_amt) The primary key is {Car#,Salesman#} because a car can be sold by multiple salesmen. The...

a) (5p) Suppose, you are given a relation R=(X, Y, Z, W, Q) with the following functional dependencies: {YZ-XWQ, WY, Z-Q) Find the best normal form that R satisfies (1NF, 2NF, 3NF, or BCNF). Explain...