Database Processing Ch 1 and Part of Ch 2 Essay example
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.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