Author Question: What is the difference between logical database design and the physical table design? What will ... (Read 46 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?

Essential fatty acids have been shown to be effective against ulcers, asthma, dental cavities, and skin disorders such as acne.

Did you know?

The Centers for Disease Control and Prevention (CDC) was originally known as the Communicable Disease Center, which was formed to fight malaria. It was originally headquartered in Atlanta, Georgia, since the Southern states faced the worst threat from malaria.

Did you know?

Green tea is able to stop the scent of garlic or onion from causing bad breath.

Did you know?

Eating food that has been cooked with poppy seeds may cause you to fail a drug screening test, because the seeds contain enough opiate alkaloids to register as a positive.

Did you know?

Multiple sclerosis is a condition wherein the body's nervous system is weakened by an autoimmune reaction that attacks the myelin sheaths of neurons.

For a complete list of videos, visit our video library