Give a brief description of the relational model of database management
What will be an ideal response?
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.
You might also like to view...
Which may be considered in choosing a tenant?
a. Marital status b. National ancestry c. Whether the prospective tenant is on welfare d. Tenant's income
The establishment of the EEOC ________ the ability of the federal government to enforce equal employment laws
A) greatly enhanced B) greatly reduced C) hampered D) truncated