logo image

IS chapter 6 part 2

the type of logical database model that treats data as if they were stored in two-dimensional tables is the
relational DBMS
What are the relationships that the relational database is named for?
relationship between entities
A characteristic or quality describing an entity is called
attribute
The most basic business database is comprised of
five tables: for customers, employees, suppliers, parts, and sales
in a table for customers, the information about a single customer would reside in a single
row
in a relational database, a record is also called a
Tuple
A field identified in a record as holding the unique identifier for that record is called the:
Key field
A schematic of the entire database that describes the relationships in a database is called
entity-relationship diagram
A one-to-one relationship between two entities in symbolized in a diagram by a line that ends
in two short marks
A one-to-many relationship between two entities is symbolized in a diagram by a line that ends
with a crow’s foot preceded by a short mark
A table that links two tables that have a many-to-many relationship is often called a
intersection relation
the process of streamlining data to minimize redundancy and awkward many-to-many relationships is called
normalization
A DBMS makes the:
physical database available for different logical views
the logical view of a database
presents data as they would be perceived by end users
Which of the following is not a typical feature of DBMS
Query wizard tool
Access is a
DBMS for desktop PC systems
In clustering, a data mining tool will:
find new groupings within data
MySQL is a
popular open-source DBMS
Data mining is more______ than OLAP
discovery green
in a relational database, the three basic operations used to develop useful sets of data are:
select, project, and join
The select operation
creates a subset consisting of all records in the file that meet stated criteria
all of the following are tools or technologies for extracting information from unstructured data sets except
SQL queries
The project operation
creates a subset consisting of columns in a table
which of the following best describes the importance of creating an accurate data model for your businesses database?
critical, as without one, your data may be inaccurate, incomplete, or difficult to retrieve
An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the.
Data dictionary

Need essay sample on "IS chapter 6 part 2"? We will write a custom essay sample specifically for you for only .90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register
Signup & Access Essays

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy