Database Essay

Submitted By swiss333
Words: 3288
Pages: 14
Open Document
Chapter 03: Database Systems, Data Centers, and Business Intelligence

TRUE/FALSE

1. A database, a database management system, and the application programs that use the data make up a database environment.

ANS: T PTS: 1
REF: Why Learn About Database Systems, Data Centers, And Business Intelligence

2. A database scientist is a skilled and trained IS professional who directs all activities related to an organization’s database, including providing security from intruders.

ANS: F PTS: 1
REF: Why Learn About Database Systems, Data Centers, And Business Intelligence

3. An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

ANS: F PTS: 1 REF: Data Management

4. A collection of fields about a specific object is a record.

ANS: T PTS: 1 REF: Data Management

5. Today, few organizations use the database approach to data management, where multiple information systems share a pool of related data.

ANS: F PTS: 1 REF: Data Management

6. The specific value of an attribute is called a data entity.

ANS: F PTS: 1 REF: Data Management

7. Due to their size, databases must be stored on mainframe computers or other large, powerful computers.

ANS: F PTS: 1 REF: Data Management

8. Climate control is an important component of modern data centers.

ANS: T PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

9. Business and technology vendors are working to develop blue data centers that run more efficiently and require less energy for processing and cooling.

ANS: F PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

10. Microsoft built a data center taking up 16 football fields of space filled with 220 shipping containers packed with servers.

ANS: T PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

11. When organizing a database, key considerations include determining what data to collect, who will have access to it, how they might want to use it, and how to monitor database performance.

ANS: T PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

12. A data model is a diagram of data attributes and their relationships.

ANS: F PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

13. The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

ANS: F PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

14. Oracle is currently the market leader in general purpose databases, with about three-fourths of the multibillion dollar database market.

ANS: F PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

15. In the relational model, each row of a table represents a data entity or row and each column of the table represents an attribute or field.

ANS: T PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

16. Selecting involves combining two or more tables.

ANS: F PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

17. Projecting involves eliminating columns in a table.

ANS: T PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

18. One of the primary advantages of a relational database is that it allows tables to be linked to reduce data redundancy and allow data to be organized more logically.

ANS: T PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

19. The relational database model is by far the most widely used..

ANS: T PTS: 1
REF: Data Centers, Data Modeling, And Database Characteristics

20. One of the final steps in installing and using a large database involves “telling” the DBMS the logical and physical structure of the data and the relationships among the data for each user.

ANS: F PTS: 1 REF: Database Management Systems

21. The DBMS serves as an interface between an application program
Show More

Related Documents: Database Essay

Database: Database and Database Management Systems Essay

A database is a table consisting ofcolumns (fields) and rows (records) where each column contains a specific attribute and each row features a certain value for the corresponding attribute. The number of columns within a single table depends on how many different types/categories of information we need to store within a database, while the number of rows is defined by the quantity of the objects that have to be introduced categorized records for. This kind of simple organization of the data in database…

Words 1052 - Pages 5

Database: Database and Information Essay

Chapter 7 Databases and Data Warehouses 7.1 Databases * <<Introduction>> * The ability to understand, digest, analyze, and filter data and information is key to success for any professional in any industry. * Data are raw facts that describe the characteristics of an event. * E.g., characteristics for a sales event can include a date, item number, item description, quantity ordered, customer name, or shipping details. * Information is data converted into a meaningful…

Words 2716 - Pages 11

The Use Of Databases And Database Management Systems

storing and converting raw data bits into useful information. This complex process can only be achieved through the use of databases and database management systems (DBMS), where information is logically placed, arranged, and related enabling information to be accessed at some point in the future. It’s important to note that although it’s not completely obvious, databases are utilized in nearly any organization in the modern world. They are crucial in many parts of an organization and can assist…

Words 775 - Pages 4

Essay on Databases: Database Normalization and Data

Databases: Concept, Design, and Functionality A relational database is a maintained collection of separate, related tables containing data stored in fields (columns) called attributes and records (rows) called records (Definition Rel DB, 2014). Relationships between the tables are created by utilizing a common field or key. Keys are data points used to identify unique values or records within tables, and provide a logical method to access a record within the table (Gilfillan, 2002).…

Words 1490 - Pages 6

Database: Database and Microsoft Excel Essay

Database Database A database system is defined as a integrated computer structure which stores collections of end user or meta data. In any organization, a database system is very important. Databases can be used to store any information you to collect and store. This information could be a company storing information on all of its employees or a company collecting monthly sales data. The size of the organization or company will determine how you will store this data. Microsoft Access is a great…

Words 412 - Pages 2

Database Essay

Could Cloud Databases Save Your Company Money? When running a company where customers trust their information to that company, that company needs to have a secure way to store the information entrusted to them. This report’s purpose is to inform you of the choices you have in selecting a method to store you information and data. When making your choice you should consider security, availability/reliability, and operational costs. There are two ways to securely store and collect your data, which…

Words 1705 - Pages 7

Databases: Sql and Skills Development Databases Essay

Functional Skills ICT Skills Level 1 Database Learning Resource 2003 Version Task 1 Microsoft product screen shot(s) reprinted with permission from Microsoft Corporation. Excellence in skills development DATABASES LEVEL 1 TASK 1 9 9.1 Edit and sort a database table As you work through, you will find help available in the Database Information Pack, if you need to use it. N.B. Before you begin this section, you may want to do the Level 1 IT Basics module. Introduction There…

Words 915 - Pages 4

Containment: Database and Care Products Database Essay

or more databases created by the “environmental working group” www.ewg.org Relevant databases include: “cosmetics and home care products database” http://www.ewg.org/skindeep/ “Cleaning Products Database” http://www.ewg.org/guides/cleaners Others may be browsed on the EWG website as desired. Use this online database to conduct a small investigation on 6-12 of the household products (e.g. soap, cleaner, shampoo, dishsoap) you have in your home (using the appropriate database for your…

Words 296 - Pages 2

Database Design Essay

Database Design Dustin Brown DBM380 March 23rd, 2015 Debra Martin Database Design Databases are a key elements of today’s business world. Almost every company in the world makes use of databases to help store, process, and utilize information to achieve various tasks and goals. To get the most out of databases companies employ database management systems. In this paper we will be taking a look at what database systems are, as well as the architecture that defines them. Before we begin it is important…

Words 773 - Pages 4

Database and Access Essay

file directly on the Blackboard 2 1.2 mdb files vs. accdb files 2 1.3 Naming Database and Database Objects 2 1.4 Security Alert screen in Access 2007 or 2010: Important 2 & 3 1.5 Compacting and Repairing the database: Important 4 1.6 Access 2010/2007 Environment 5 1.6.1 The Access Main Menu Bar: 6 1.6.2 The Navigation Panel’s Dropdown list and the Shutter Bar 6, 7 1.6.3 Database Objects and The User Views: 7 1.6.4 The Create tab 10 1.6.5 The Access…

Words 1899 - Pages 8