« previous next »

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

sheilaspns

  • Hero Member
  • *****
  • Posts: 567
on: Jul 7, 2018
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
Modern Systems Analysis and Design ¦ Valacich, George ¦ 8th Edition
Buy Test-Bank


princessflame2016

  • Sr. Member
  • ****
  • Posts: 298
Reply #1 on: Jul 7, 2018
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
« previous next »
 

Did you know?

Coca-Cola originally used coca leaves and caffeine from the African kola nut. It was advertised as a therapeutic agent and "pickerupper." Eventually, its formulation was changed, and the coca leaves were removed because of the effects of regulation on cocaine-related products.

Did you know?

Nearly all drugs pass into human breast milk. How often a drug is taken influences the amount of drug that will pass into the milk. Medications taken 30 to 60 minutes before breastfeeding are likely to be at peak blood levels when the baby is nursing.

Did you know?

After a vasectomy, it takes about 12 ejaculations to clear out sperm that were already beyond the blocked area.

Did you know?

Addicts to opiates often avoid treatment because they are afraid of withdrawal. Though unpleasant, with proper management, withdrawal is rarely fatal and passes relatively quickly.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates’s recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

A portion of the periodic table of elements A portion of the periodic table of elements
One proposed timeline of the origin of space, from physical cosmology. One proposed timeline of the origin of space, from physical cosmology.
DISTILLATION/ABSORPTION COLUMN DESIGN DISTILLATION/ABSORPTION COLUMN DESIGN
Consumerism and Sustainability: Food from Farm to Table Consumerism and Sustainability: Food from Farm to Table
What's the Difference Between England, Great Britain, and United Kingdom? What's the Difference Between England, Great Britain, and United Kingdom?
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
Video: Calvin cycle (The light-independent reactions )

For a complete list of videos, visit our video library