« previous next »

Author Question: What are the three types of database design situations? What will be an ideal ... (Read 82 times)

mwit1967

  • Hero Member
  • *****
  • Posts: 501
on: Jul 7, 2018
What are the three types of database design situations?
 
  What will be an ideal response?

Question 2

If a DEFAULT constraint is included when a new column is added to a table, the default value is only applied to new rows and not to the existing rows at the time the new column is added.
 
  Indicate whether the statement is true or false


JCABRERA33

  • Sr. Member
  • ****
  • Posts: 344
Reply #1 on: Jul 7, 2018
Answer to Question 1

Database designs can be based on (1 ) existing data, (2 ) new systems development and (3 ) database redesign. Database designs from existing data may be based on data in spreadsheets or other data tables, or on data extracted from other databases. New systems development gathers user requirements for needed applications and designs a database to meet those requirements. Database redesign may be needed to migrate existing databases to a newer DBMS, or to integrate multiple existing databases.

Answer to Question 2

TRUE


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
« previous next »
 

Did you know?

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

Did you know?

About 600,000 particles of skin are shed every hour by each human. If you live to age 70 years, you have shed 105 pounds of dead skin.

Did you know?

Astigmatism is the most common vision problem. It may accompany nearsightedness or farsightedness. It is usually caused by an irregularly shaped cornea, but sometimes it is the result of an irregularly shaped lens. Either type can be corrected by eyeglasses, contact lenses, or refractive surgery.

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Thyroid conditions cause a higher risk of fibromyalgia and chronic fatigue syndrome.

Physical assessment is one component of the nursing database Physical assessment is one component of the nursing database
Different types of Snellen eye charts. Different types of Snellen eye charts.
Various types of integumentary conditions. (D) Psoriasis Various types of integumentary conditions. (D) Psoriasis
Structures of the major types of asparagine-linked (N-linked) oligosaccharides Structures of the major types of asparagine-linked (N-linked) oligosaccharides
Speciation produces new types of organisms Speciation produces new types of organisms
Codominance in ABO Blood Types Codominance in ABO Blood Types
Video: Heart sounds

For a complete list of videos, visit our video library