preview

Database Processing Ch 1 and Part of Ch 2

Better Essays

Chapter 1 – Review Questions
1.1 What is the purpose of a database? - The purpose of a database is to help people keep track of things.
1.2 What is the most commonly used type of database? - The relational database is the most commonly used type of database. 1.7 Define the terms data and information. Explain how the two terms differ. - Data are facts and figures. Information is defined as knowledge derived from data, or as data presented in a meaningful context. Data is simply recorded in the database, but the data must be manipulated in some way to produce information.

1.12 What is the purpose of the largest databases used by e-commerce companies such as Amazon.com? - The largest databases used by e-commerce companies …show more content…

- Structured Query Language (SQL) is an internationally recognized standard language used and understood by all commercial database management systems.
1.19 What does DBMS stand for? - DBMS stands for database management system.
1.20 What is the function of the DBMS? - A DBMS creates, processes and administers databases under the control of the DBMS.
1.21 Name three vendors of DBMS products. - Three vendors of DBMS products are Microsoft (Microsoft Access and SQL Server), Oracle Corporation (Oracle Database and MySQL), and IBM (DB2).
1.22 Define the term database. - A database is a self-describing collection of integrated tables, which means that the tables store both data and the relationships between the data.
1.23 Why is a database considered to be self-describing? - A database is considered to be self-describing because it contains a description of itself – such as what tables are in the database, which columns are in each table and what kind of data is stored in each column.
1.24 What is metadata? How does this term pertain to a database? - Metadata is data about data. Metadata in databases allow them to be self-describing.
1.25 What advantage is there in storing metadata in tables? - The advantage of storing metadata in tables is that we can query the metadata to determine the structure of the database – for example, what tables, columns, indexes and data types exist in the database.
1.26 List the components of a

Get Access