BuyFindarrow_forward

Principles of Information Systems ...

12th Edition
Ralph Stair + 1 other
Publisher: Cengage Learning
ISBN: 9781285867168

Solutions

Chapter
Section
BuyFindarrow_forward

Principles of Information Systems ...

12th Edition
Ralph Stair + 1 other
Publisher: Cengage Learning
ISBN: 9781285867168
Chapter 5, Problem 7SAT
Textbook Problem
1 views

______ involves eliminating columns in a table.

  1. a. Projecting
  2. b. Joining
  3. c. Selecting
  4. d. Linking

Program Description Answer

Projecting is the process of eliminating columns in a table.

Hence, the correct answer is option “A”.

Explanation of Solution

Projecting:

  • It is one of the types of manipulating data by eliminating columns in a table.
  • If the user want to create new table by eliminating certain columns of old table then the user can use projection concept.

For example:

If the student table has student number, student name, and grade of the student and if the teacher want to create a new table that contains only the student number and grade of the student. The teacher can use projection to eliminate student name and create a new table containing only student number and grade.

Explanation for incorrect options:

Joining:

  • It is one of the types of manipulating data by combining two or more tables...

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 5 Solutions

Principles of Information Systems (MindTap Course List)
Show all chapter solutions
add
Ch. 5 - Multiple records can have the same primary key....Ch. 5 - A(n) ______ is a field or set of fields that...Ch. 5 - A(n) ___________ is a diagram of entities and...Ch. 5 - The ______ is a simple but highly useful way to...Ch. 5 - ______ involves eliminating columns in a table. a....Ch. 5 - Because the DBMS is responsible for providing...Ch. 5 - ______ is a special-purpose programming language...Ch. 5 - SQL databases conform to ACID properties that...Ch. 5 - A(n) _______ is a collection of instructions and...Ch. 5 - The _______ is a nontechnical, but important...Ch. 5 - A trend in database management, known as Database...Ch. 5 - _________ is a term used to describe data...Ch. 5 - An in-memory database (IMDB) is a database...Ch. 5 - A(n) ______ is a database that holds business...Ch. 5 - An information-analysis process that involves the...Ch. 5 - ______ allows users to explore data from a number...Ch. 5 - ______ is a form of data mining that combines...Ch. 5 - ___________ is a data visualization technique in...Ch. 5 - Identify all the components in the data hierarchy...Ch. 5 - What is the difference between a data attribute...Ch. 5 - What is the purpose of a primary key? What field...Ch. 5 - What is enterprise data modeling?Ch. 5 - What is an entity-relationship model and what is...Ch. 5 - What is data cleansing?Ch. 5 - What is SQL and how is it used?Ch. 5 - What are the essential differences between an SQL...Ch. 5 - What is database as a service (DaaS)? What are the...Ch. 5 - What is Hadoop?Ch. 5 - What is a schema, and how is it used?Ch. 5 - What is concurrency control? Why is it important?Ch. 5 - What is in-memory database processing, and what...Ch. 5 - What is the difference between projecting and...Ch. 5 - What is big data? Identify three characteristics...Ch. 5 - What is a data warehouse, and how is it different...Ch. 5 - What is meant by the front end and the back end of...Ch. 5 - What is the relationship between the Internet and...Ch. 5 - What is data mining? What is OLAP? How are they...Ch. 5 - What is business intelligence? Identify five...Ch. 5 - What is predictive analysis? Give an example where...Ch. 5 - When building a database, an organization must...Ch. 5 - Outline some specific steps an organization might...Ch. 5 - Briefly describe the ACID properties to which an...Ch. 5 - Briefly describe how a NoSQL database operates.Ch. 5 - Identify and briefly describe some of the...Ch. 5 - Identify and briefly describe the steps in the ETL...Ch. 5 - You are the vice president of information...Ch. 5 - What counterintelligence strategy might a large...Ch. 5 - Your luxury car dealership wants to identify...Ch. 5 - Make a list of the databases in which data about...Ch. 5 - If you were the database administrator for the...Ch. 5 - Identity theft, where people steal personal...Ch. 5 - You have been hired to set up a database for a...Ch. 5 - Develop a simple data model for the music you have...Ch. 5 - An online video movie rental store is using a...Ch. 5 - Using a graphics program, develop an...Ch. 5 - Use a Web search engine to find information on...Ch. 5 - Do research to find what career opportunities are...Ch. 5 - How could you use business intelligence (BI) to do...Ch. 5 - How did Medihelps use of a traditional database...Ch. 5 - How does Medihelps salesforce now use the...Ch. 5 - How did B.I. Practice improve the efficiency of...Ch. 5 - How does the new query system help Medihelp make...Ch. 5 - From the user side, Mr. Kim said that HanaTour...Ch. 5 - How does HanaTour use the data it collects from...Ch. 5 - HanaTour chose Wizbase as its implementation...Ch. 5 - Think of the data that your universitys database...Ch. 5 - What work is involved in merging multiple...Ch. 5 - Why do you think Altitude Online found it...Ch. 5 - In a major move such as this, what opportunities...Ch. 5 - Why do you think Altitude Online is beginning work...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is a partial dependency? With what normal form is it associated?

Database Systems: Design, Implementation, & Management

What is a Tier I ERP software vendor?

Principles of Information Systems (MindTap Course List)

What is incident classification?

Management Of Information Security

What two types of shanks are commonly found on twist drills?

Precision Machining Technology (MindTap Course List)

What do radians represent?

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Explain what occurs during thrashing, and list steps to prevent it.

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

What is the last weld bead on a multipass weld called?

Welding: Principles and Applications (MindTap Course List)