« previous next »

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

Although the Roman numeral for the number 4 has always been taught to have been "IV," according to historians, the ancient Romans probably used "IIII" most of the time. This is partially backed up by the fact that early grandfather clocks displayed IIII for the number 4 instead of IV. Early clockmakers apparently thought that the IIII balanced out the VIII (used for the number 8) on the clock face and that it just looked better.

Did you know?

The liver is the only organ that has the ability to regenerate itself after certain types of damage. As much as 25% of the liver can be removed, and it will still regenerate back to its original shape and size. However, the liver cannot regenerate after severe damage caused by alcohol.

Did you know?

Signs and symptoms that may signify an eye tumor include general blurred vision, bulging eye(s), double vision, a sensation of a foreign body in the eye(s), iris defects, limited ability to move the eyelid(s), limited ability to move the eye(s), pain or discomfort in or around the eyes or eyelids, red or pink eyes, white or cloud spots on the eye(s), colored spots on the eyelid(s), swelling around the eyes, swollen eyelid(s), and general vision loss.

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?

Glaucoma is a leading cause of blindness. As of yet, there is no cure. Everyone is at risk, and there may be no warning signs. It is six to eight times more common in African Americans than in whites. The best and most effective way to detect glaucoma is to receive a dilated eye examination.

Each experimental organism used in cell biology has advantages for certain types Each experimental organism used in cell biology has advantages for certain types
Cloud Types: Vertical Development Cloud Types: Vertical Development
Importance of Considering Gestalt Principles in Product Design Importance of Considering Gestalt Principles in Product Design
Modern house door design Modern house door design
Types of Mutations in the HBB Gene That Cause p-Thalassemia Types of Mutations in the HBB Gene That Cause p-Thalassemia
Three Types of Neurons Three Types of Neurons
Video: Cell mediated immune response to a viral infection Animation

For a complete list of videos, visit our video library