« previous next »

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

Before a vaccine is licensed in the USA, the Food and Drug Administration (FDA) reviews it for safety and effectiveness. The CDC then reviews all studies again, as well as the American Academy of Pediatrics and the American Academy of Family Physicians. Every lot of vaccine is tested before administration to the public, and the FDA regularly inspects vaccine manufacturers' facilities.

Did you know?

According to the American College of Allergy, Asthma & Immunology, more than 50 million Americans have some kind of food allergy. Food allergies affect between 4 and 6% of children, and 4% of adults, according to the CDC. The most common food allergies include shellfish, peanuts, walnuts, fish, eggs, milk, and soy.

Did you know?

Bisphosphonates were first developed in the nineteenth century. They were first investigated for use in disorders of bone metabolism in the 1960s. They are now used clinically for the treatment of osteoporosis, Paget's disease, bone metastasis, multiple myeloma, and other conditions that feature bone fragility.

Did you know?

The calories found in one piece of cherry cheesecake could light a 60-watt light bulb for 1.5 hours.

Did you know?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Physical assessment is one component of the nursing database Physical assessment is one component of the nursing database
A Subtitle C Landfill Design A Subtitle C Landfill Design
A horizontally opposed engine design helps to lower the vehicle’s center of gravity. A horizontally opposed engine design helps to lower the vehicle’s center of gravity.
Importance of Considering Gestalt Principles in Product Design (1 of 2) Importance of Considering Gestalt Principles in Product Design (1 of 2)
Glands and Cell Types of the Colon Glands and Cell Types of the Colon
The 4 Tissue Types The 4 Tissue Types
Video: Carbohydrate Metabolism: Introduction to renal processes and filtrate formation and composition

For a complete list of videos, visit our video library