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

vHAUNG6011 · **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

FergA · **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