« previous next »

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

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

The immune system needs 9.5 hours of sleep in total darkness to recharge completely.

Did you know?

Many people have small pouches in their colons that bulge outward through weak spots. Each pouch is called a diverticulum. About 10% of Americans older than age 40 years have diverticulosis, which, when the pouches become infected or inflamed, is called diverticulitis. The main cause of diverticular disease is a low-fiber diet.

Did you know?

Normal urine is sterile. It contains fluids, salts, and waste products. It is free of bacteria, viruses, and fungi.

Did you know?

If you could remove all of your skin, it would weigh up to 5 pounds.

The theoretical design of nature reserves, based on the tenets of island biogeography. The theoretical design of nature reserves, based on the tenets of island biogeography.
Holland’s six basic types of people based on vocational interests (attitudes, abilities, and ... Holland’s six basic types of people based on vocational interests (attitudes, abilities, and ...
Summary of Viral Hepatitis Types Summary of Viral Hepatitis Types
Cloud Types: Vertical Development Cloud Types: Vertical Development
Types of ecosystem service vs. total global value per year Types of ecosystem service vs. total global value per year
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: Mycobacterium tuberculosis: Drug Resistance and Natural Selection

For a complete list of videos, visit our video library