Author Question: A(n) ________ is a working demonstration of selected portions of the future system. Fill in the ... (Read 21 times)

notis

  • Hero Member
  • *****
  • Posts: 596
A(n) ________ is a working demonstration of selected portions of the future system.
 
  Fill in the blank(s) with correct word

Question 2

What are the basic steps of the normalization process?
 
  What will be an ideal response?



krakiolit

  • Sr. Member
  • ****
  • Posts: 318
Answer to Question 1

prototype

Answer to Question 2

Before starting the normalization process, the relation must be in first normal form, which means that it meets the basic requirements of being a relation. The first step of the normalization process is to identify all the candidate keys in the relation. The second step is to identify all the functional dependencies in the relation. Third, check to see if all the identified determinants are candidate keys. If all determinants are candidate keys, the relation is well-formed and nothing more needs to be done. On the other hand, if any of the determinants is not a candidate key, the relation is not well-formed, and it is necessary to: (1 ) place the columns of that functional dependency into a new relation, (2 ) make the determinant of that functional dependency the primary key of the new relation, (3 ) leave a copy of the determinant in the original relation as a foreign key, and (4 ) create a referential integrity constraint between the original relation and the new relation. This process should be repeated for every relation until every determinant in a relation is a candidate key of that relation.



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question


 

Did you know?

More than 30% of American adults, and about 12% of children utilize health care approaches that were developed outside of conventional medicine.

Did you know?

Certain chemicals, after ingestion, can be converted by the body into cyanide. Most of these chemicals have been removed from the market, but some old nail polish remover, solvents, and plastics manufacturing solutions can contain these substances.

Did you know?

Hippocrates noted that blood separates into four differently colored liquids when removed from the body and examined: a pure red liquid mixed with white liquid material with a yellow-colored froth at the top and a black substance that settles underneath; he named these the four humors (for blood, phlegm, yellow bile, and black bile).

Did you know?

Vaccines cause herd immunity. If the majority of people in a community have been vaccinated against a disease, an unvaccinated person is less likely to get the disease since others are less likely to become sick from it and spread the disease.

Did you know?

Between 1999 and 2012, American adults with high total cholesterol decreased from 18.3% to 12.9%

For a complete list of videos, visit our video library