« previous next »

Author Question: What are the three types of database design situations? What will be an ideal ... (Read 99 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?

The most common treatment options for addiction include psychotherapy, support groups, and individual counseling.

Did you know?

Warfarin was developed as a consequence of the study of a strange bleeding disorder that suddenly occurred in cattle on the northern prairies of the United States in the early 1900s.

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?

During the twentieth century, a variant of the metric system was used in Russia and France in which the base unit of mass was the tonne. Instead of kilograms, this system used millitonnes (mt).

Did you know?

People with alcoholism are at a much greater risk of malnutrition than are other people and usually exhibit low levels of most vitamins (especially folic acid). This is because alcohol often takes the place of 50% of their daily intake of calories, with little nutritional value contained in it.

The three types of cytoskeletal filaments The three types of cytoskeletal filaments
Types of Neurons and Neuron Anatomy Types of Neurons and Neuron Anatomy
Cloud Types: Vertical Development Cloud Types: Vertical Development
Three types of “end feel” in normal joints. Three types of “end feel” in normal joints.
Types of wind deposits Types of wind deposits
Three types of muscle tissue Three types of muscle tissue
Video: The Vestibular System

For a complete list of videos, visit our video library