« previous next »

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

Computer programs are available that crosscheck a new drug's possible trade name with all other trade names currently available. These programs detect dangerous similarities between names and alert the manufacturer of the drug.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

Did you know?

Pope Sylvester II tried to introduce Arabic numbers into Europe between the years 999 and 1003, but their use did not catch on for a few more centuries, and Roman numerals continued to be the primary number system.

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

Thyroid conditions may make getting pregnant impossible.

turbine design turbine design
Three Types of Lunar Eclipses Three Types of Lunar Eclipses
Types of suture material. Types of suture material.
The arms can be moved in and out and most pads can be rotated to allow for many different types of ... The arms can be moved in and out and most pads can be rotated to allow for many different types of ...
Types of Respiratory Protection Devices Types of Respiratory Protection Devices
Types of Movement at Synovial Joints Types of Movement at Synovial Joints
Video: Basic rhythm - control centers in medulla oblongata, spirograph and normal tidal cycle

For a complete list of videos, visit our video library