MANAGEMENT INFORMATION SYSTEMS
MANAGEMENT INFORMATION SYSTEMS
15th Edition
ISBN: 9780134640037
Author: LAUDON
Publisher: PEARSON
Expert Solution & Answer
Book Icon
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...

Blurred answer
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education