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
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…
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…
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…
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).…
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…
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…
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…
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…
Formally, the term "database" refers to the data itself and supporting data structures. Databases are created to operate large quantities of information by inputting, storing, retrieving, and managing that information. Databases are set up so that one set of software programs provides all users with access to all the data. A "database management system" (DBMS) is a suite of computer software providing the interface between users and a database or databases. Because they are so closely related…
Choosing a database is an important task that every company must carefully consider. Two types of databases that a company may consider are open source and proprietary. Both open source and proprietary databases have numerous advantages and disadvantages. In this paper we will discuss some of these advantages and disadvantages. We will also discuss some things that a company should consider when they are choosing a database. There are many different types of open source databases. Some of these…