Author Question: A(n) ________ is a working demonstration of selected portions of the future system. Fill in the ... (Read 68 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?

Aspirin is the most widely used drug in the world. It has even been recognized as such by the Guinness Book of World Records.

Did you know?

In 2006, a generic antinausea drug named ondansetron was approved. It is used to stop nausea and vomiting associated with surgery, chemotherapy, and radiation therapy.

Did you know?

Drug abusers experience the following scenario: The pleasure given by their drug (or drugs) of choice is so strong that it is difficult to eradicate even after years of staying away from the substances involved. Certain triggers may cause a drug abuser to relapse. Research shows that long-term drug abuse results in significant changes in brain function that persist long after an individual stops using drugs. It is most important to realize that the same is true of not just illegal substances but alcohol and tobacco as well.

Did you know?

Human stomach acid is strong enough to dissolve small pieces of metal such as razor blades or staples.

Did you know?

Serum cholesterol testing in adults is recommended every 1 to 5 years. People with diabetes and a family history of high cholesterol should be tested even more frequently.

For a complete list of videos, visit our video library