Database Processing Ch 1 and Part of Ch 2 Essay example

1404 Words Jun 19th, 2014 6 Pages
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…
1.33 Name the components of an enterprise-class database system. * The four components of an enterprise-class database system are: * Users – The people who interact with database applications created in MS Access * Database applications – These are the programs or applications that the users actually use as an interface to the underlying databases. * The DBMS – The DBMS creates, processes and administers databases. * Databases – Each database application is run against one or more DBMS created and maintained database.
1.35 How do database applications get and put database data? - All database applications get and put database data by sending SQL statements to a DBMS.
1.37 List several consequences of a poorly designed database. - Poorly designed databases have poor performance. As a result, the databases may require application developers to write overly complex SQL statements, or they may be difficult to revise and adapt to changing circumstances, or they may fail in some other manner.
1.38 Explain two ways that a database can be designed from existing data. * A database can be designed from existing data by: * Using data from non-database sources such as spreadsheets and text files; or * Using data extracts from existing databases.
1.39 What is a data warehouse? What

Related Documents

Mahou Tsukai no Yome - Hoshi Matsu Hito | Letitia Brookes | Guardians