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 121 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
Great answer, keep it coming :)

raenoj

  • Member
  • Posts: 340
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Each year in the United States, there are approximately six million pregnancies. This means that at any one time, about 4% of women in the United States are pregnant.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Did you know?

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

Did you know?

Your heart beats over 36 million times a year.

Did you know?

Not getting enough sleep can greatly weaken the immune system. Lack of sleep makes you more likely to catch a cold, or more difficult to fight off an infection.

Female Reproductive Anatomy Model Female Reproductive Anatomy Model
Eye Model Eye Model
International Management: Managing Across Borders and Cultures International Management: Managing Across Borders and Cultures
Phrenology model showing areas of the head overlaying brain regions that control different traits. I Phrenology model showing areas of the head overlaying brain regions that control different traits. I
The attenuation model regulating the tryptophan operon The attenuation model regulating the tryptophan operon
The karyotype and phenotypic description of an infant with Patau syndrome The karyotype and phenotypic description of an infant with Patau syndrome
Video: hGH (protein synthesis, growth and development)

For a complete list of videos, visit our video library