Chapter 6, Problem 2RQ

Explanation of Solution

Database and database management system

• A database is a collection of data organized to service many applications efficiently.
• It stores and manages data so that they appear to be in one location.
• A database is also used to minimize redundant data.
• A database management system (DBMS) is special software that permits an organization to centralize data, manage them efficiently, and provide access to the stored data by the application programs...

Explanation of Solution

Capabilities of a database management system

• A database management system consists of capabilities and tools for organizing, managing and accessing data in the database.
• The main capabilities of a database management system include data definition language, data dictionary, and data manipulation language.
• The data definition language helps to specify the structure and content of the database...

Explanation of Solution

Relational Database Management System

• The relational database is the method used for organizing and maintaining data in information systems.
• It organizes data in two-dimensional tables with rows and columns called relations...

Explanation of Solution

Operations of a relational database management system

• The relational database is the method used for organizing and maintaining data in information systems.
• The three basic operations of a relational database management system include select, project and join.
• Select operation is used to create a subset consisting of all records in the file that meet stated criteria...

Explanation of Solution

Uses of non-relational databases

• The non-relational database systems uses more flexible data models and are designed for managing large data sets across distributed computing networks.
• They are easy to scale up and down based on computing needs...

Explanation of Solution

Normalization and its contribution to relational database

• Normalization is the process of creating small stable data structures from complex groups of data when designing a relational database.
• Normalization streamlines relational database design by removing redundant data such as repeating data groups.
• A well-designed relational database will be organized around the information needs of the business and will probably be in some normalized form.
• A database that is not normalized will have problems with insertion, deletion, and modification...

Explanation of Solution

Entity relationship diagram and its role in database design

• Relational databases organize data into two-dimensional tables known as relations with columns and rows.
• Each table contains data on an entity and its attributes.
• An entity-relationship diagram graphically depicts the relationship between entities or tables in a relational database...