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 114 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
Wow, this really help

dreamfighter72

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

« previous next »
 

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Did you know?

The average human gut is home to perhaps 500 to 1,000 different species of bacteria.

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

Did you know?

Sperm cells are so tiny that 400 to 500 million (400,000,000–500,000,000) of them fit onto 1 tsp.

Did you know?

About 80% of major fungal systemic infections are due to Candida albicans. Another form, Candida peritonitis, occurs most often in postoperative patients. A rare disease, Candida meningitis, may follow leukemia, kidney transplant, other immunosuppressed factors, or when suffering from Candida septicemia.

Lab: Amoeba Model Lab: Amoeba Model
The Biopsychosocial Model The Biopsychosocial Model
Better land and water management and appropriate crop selection can help eliminate hunger Better land and water management and appropriate crop selection can help eliminate hunger
Introduction to Management Science, 13th Edition Introduction to Management Science, 13th Edition
The first generation of model organisms in genetic analysis The first generation of model organisms in genetic analysis
A gene map for chromosome 12 from the NCBI database Map Viewer A gene map for chromosome 12 from the NCBI database Map Viewer
Video: Polymerase chain reaction PCR - Animation

For a complete list of videos, visit our video library