Author Question: What is the difference between logical database design and the physical table design? What will ... (Read 105 times)

sheilaspns

  • Hero Member
  • *****
  • Posts: 567
What is the difference between logical database design and the physical table design?
 
  What will be an ideal response?

Question 2

In a Master Test Plan, test execution and test failure fall under which category?
 
  A) Overall Plan
  B) Testing Requirements
  C) Procedure Control
  D) Component-Specific Test Plans


princessflame2016

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

In logical database design, you group into a relation those attributes that concern some unifying, normalized business concept, such as a customer, product, or employee. In contrast, a physical table is a named set of rows and columns that specifies the fields in each row of the table. A physical table may or may not correspond to one relation. Whereas normalized relations possess properties of well-structured relations, the design of a physical table has two goals different from those of normalization: efficient use of secondary storage and data processing speed.

Answer to Question 2

C



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Congestive heart failure is a serious disorder that carries a reduced life expectancy. Heart failure is usually a chronic illness, and it may worsen with infection or other physical stressors.

Did you know?

In most climates, 8 to 10 glasses of water per day is recommended for adults. The best indicator for adequate fluid intake is frequent, clear urination.

Did you know?

The Babylonians wrote numbers in a system that used 60 as the base value rather than the number 10. They did not have a symbol for "zero."

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

For a complete list of videos, visit our video library