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 77 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
Excellent

Liamb2179

  • Member
  • Posts: 365
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

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?

All adults should have their cholesterol levels checked once every 5 years. During 2009–2010, 69.4% of Americans age 20 and older reported having their cholesterol checked within the last five years.

Did you know?

Asthma cases in Americans are about 75% higher today than they were in 1980.

Did you know?

Side effects from substance abuse include nausea, dehydration, reduced productivitiy, and dependence. Though these effects usually worsen over time, the constant need for the substance often overcomes rational thinking.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Model organisms used to study the genetics of development Model organisms used to study the genetics of development
Oil drop model of protein folding Oil drop model of protein folding
Opioids for Pain Management Opioids for Pain Management
The Bohr model of the atom. The nucleus contains protons and neutrons, and electrons orbit around ... The Bohr model of the atom. The nucleus contains protons and neutrons, and electrons orbit around ...
Breakdown of the Malthusian Model in Western Europe Breakdown of the Malthusian Model in Western Europe
Give the world a reason to remember your name Give the world a reason to remember your name
Video: Optic Nerve and Optic Disk Animation (Part 2 of 2)

For a complete list of videos, visit our video library