Management Information Systems: Managing the Digital Firm (15th Edition)
15th Edition
ISBN: 9780134639710
Author: Kenneth C. Laudon, Jane P. Laudon
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Expert Solution & Answer
Chapter 6, Problem 2RQ
Explanation of Solution
- 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...
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionChapter 6 Solutions
Management Information Systems: Managing the Digital Firm (15th Edition)
Knowledge Booster
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education