Page 230 -

Key termS anD ConCeptS Using Your Knowledge 229

Access 204 Entity-relationship (E-R) diagrams 214 Normal forms 217
ACID 222 Fields 199 Normalization 216
Attributes 213 File 199 NoSQL databases 161
Byte 199 Foreign keys 201 NoSQL DBMS 222
Columns 199 Graphical queries 210 One-to-many (1:N) relationships 214
Crow’s feet 214 Identifier 213 Oracle Database 204
Crow’s-foot diagram 215 In-memory DBMS 222 Primary key 200
Data integrity problem 216 Key 200 Records 199
Data model 212 Lost-update problem 211 Relation 201
Database 199 Many-to-many (N:M) Relational databases 201
Database administration 206 relationships 214 Relationships 213
Database application 206 Maximum cardinality 215 Rows 199
Database management system Metadata 201 SQL server 204
(DBMS) 204 Minimum cardinality 215 Structured Query Language
DB2 204 MongoDB 221 (SQL) 205
Entity 213 Multi-user processing 211 Table 199
Entity-relationship (E-R) MySQL 204 Unified Modeling Language (UML) 213
data model 212 NewSQL DBMS 222

MyMISLab ™

To complete the problems with the , go to EOC Discussion Questions in the MyLab.

USinG y oUr KnowleDGe

5-1. What are the steps involved in creating a database? b. Make a list of 10 different products that Acxiom
Which step is the most crucial and why? provides.
c. Describe Acxiom’s top customers.
5-2. A professor teaches many courses in a university. How- d. Examine your answers in parts b and c and describe,
ever, some professors who are the administrative heads in general terms, the kinds of data that Acxiom must
(such as Department heads) may not teach a course. be collecting to be able to provide those products to
Some courses are taught jointly by more than one pro- those customers.
fessor. Identify the entities and their relationship in the e. What is the function of InfoBase?
above scenario. What is the maximum cardinality of f. What is the function of PersonicX?
this relationship? Can this relationship be implemented g. In what ways might companies like Acxiom need to
in a database? Why or Why not? limit their marketing so as to avoid a privacy outcry
5-3. Identify two entities in the data entry form in Figure 5-29. from the public?
What attributes are shown for each? What do you h. Should there be laws that govern companies like
think are the identifiers? Acxiom? Why or why not?
i. Should there be laws that govern the types of data
5-4. Visit www.acxiom.com. Navigate the site to answer the services that governmental agencies can buy from
following questions. companies like Acxiom? Why or why not?
a. According to the Web site, what is Acxiom’s pri-
vacy policy? Are you reassured by its policy? Why
or why not?