This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Give a brief description of the relational model of database management. What will be an ideal ... (Read 30 times)

vHAUNG6011

  • Hero Member
  • *****
  • Posts: 514
on: Jul 7, 2018
Give a brief description of the relational model of database management.
 
  What will be an ideal response?

Question 2

Elimination of data redundancy is the major goal and benefit of using data normalization techniques.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

FergA

  • Sr. Member
  • ****
  • Posts: 352
Reply #1 on: Jul 7, 2018
Answer to Question 1

The primary database management system (DBMS) approach, or model, for keeping track of relationships among data entities is the relational model. The most common DBMS approach in use today is the relational database model. A DBMS package using this approach is referred to as a relational DBMS. With this approach, the DBMS views and presents entities as two-dimensional tables, with records as rows and attributes as columns. Tables can be joined when there are common columns in the tables. The uniqueness of the primary key tells the DBMS which records should be joined with others in the corresponding tables. This structure supports very powerful data manipulation capabilities and linking of interrelated data. Database files in the relational model are three-dimensional: a table has rows (one dimension), columns (a second dimension), and can contain rows of attributes in common with another table (a third dimension). This three-dimensional database is potentially much more powerful and useful than traditional, two-dimensional, flat-file databases. A good relational database design eliminates unnecessary data duplications and is easy to maintain.

Answer to Question 2

TRUE


vHAUNG6011

  • Member
  • Posts: 514
Reply 2 on: Jul 7, 2018
:D TYSM

blakcmamba

  • Member
  • Posts: 335
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Approximately 15–25% of recognized pregnancies end in miscarriage. However, many miscarriages often occur before a woman even knows she is pregnant.

Did you know?

The use of salicylates dates back 2,500 years to Hippocrates's recommendation of willow bark (from which a salicylate is derived) as an aid to the pains of childbirth. However, overdosage of salicylates can harm body fluids, electrolytes, the CNS, the GI tract, the ears, the lungs, the blood, the liver, and the kidneys and cause coma or death.

Did you know?

In 1835 it was discovered that a disease of silkworms known as muscardine could be transferred from one silkworm to another, and was caused by a fungus.

Did you know?

More than 2,500 barbiturates have been synthesized. At the height of their popularity, about 50 were marketed for human use.

Did you know?

The most dangerous mercury compound, dimethyl mercury, is so toxic that even a few microliters spilled on the skin can cause death. Mercury has been shown to accumulate in higher amounts in the following types of fish than other types: swordfish, shark, mackerel, tilefish, crab, and tuna.

A model of anxiety in which stressful events or a changing mental condition can produce unfavorable A model of anxiety in which stressful events or a changing mental condition can produce unfavorable
The Biopsychosocial Model The Biopsychosocial Model
Cultures Ideal Body Types Cultures Ideal Body Types
A space-filling model of DNA. A space-filling model of DNA.
Waste Generation and Management Waste Generation and Management
A model for C-to-U RNA editing A model for C-to-U RNA editing
Video: Cerebral Cortex Animation

For a complete list of videos, visit our video library