Introduction - Database Processing: Fundamentals, Design, and Implementation - page 28

1.4 For the tables you created in Review Question 1.3, what are the primary keys of each
table? Do you think that any of these primary keys could be surrogate keys?
1.5 Explain how the two tables you provided in Review Question 1.3 are related. Which
table contains the foreign key, and what is the foreign key?
1.6 Show your two tables from Review Question 1.3 without the columns that represent
the relationships. Explain how the value of your two tables is diminished without the
relationships.
1.7 Define the terms data and information. Explain how the two terms differ.
1.8 Give an example of information that could be determined using the two tables you
provided in your answer to Review Question 1.3.
1.9 Give examples of a single-user database application and a multiuser database applica-
tion other than the ones shown in Figure 1-5.
1.10 What problem can occur when a database is processed by more than one user?
1.11 Give an example of a database application that has hundreds of users and a very large
and complicated database. Use an example other than one in Figure 1-5.
1.12 What is the purpose of the largest databases at e-commerce companies such as
Amazon.com?
1.13 How do the e-commerce companies use the databases discussed in Review Question 1.12?
1.14 How do digital dashboard and data mining applications differ from transaction pro-
cessing applications?
1.15 Explain why a small database is not necessarily simpler than a large one.
1.16 Explain the components in Figure 1-7.
1.17 What are the functions of application programs?
1.18 What is Structured Query Language (SQL), and why is it important?
1.19 What does DBMS stand for?
1.20 What are the functions of the DBMS?
1.21 Name three vendors of DBMS products.
1.22 Define the term database.
1.23 Why is a database considered to be self-describing?
1.24 What is metadata? How does this term pertain to a database?
1.25 What advantage is there in storing metadata in tables?
1.26 List the components of a database other than user tables and metadata.
1.27 Is Microsoft Access a DBMS? Why or why not?
1.28 Describe the components shown in Figure 1-15.
1.29 What is the function of the application generator in Microsoft Access?
1.30 What is the name of the DBMS engine within Microsoft Access? Why do we rarely hear
about that engine?
1.31 Why does Microsoft Access hide important database technology?
1.32 Why would someone choose to replace the native Microsoft Access DBMS engine with
SQL Server?
1.33 Name the components of an enterprise-class database system.
1.34 Name and describe the four categories of database applications that would use an
enterprise-class database system.