Page 227 - Using MIS

Using Your Knowledge 195

Key termS and ConCeptS

Access 170 Entity 179 Multiuser processing 178
Attributes 179 Entity-relationship (E-R) data MySQL 170
BigData 189 model 179 Normal forms 184
Bigtable 188 Entity-relationship (E-R) Normalization 182
Byte 164 diagrams 181 NoSQL databases 188
Cassandra 188 Fields 165 One-to-many (1:N) relationships 181
Columns 164 File 165 Oracle Database 170
Crow’s feet 181 Foreign keys 167 Primary key 166
Crow’s-foot diagram 181 Graphical queries 176 Records 165
Data integrity problem 183 Identifier 179 Relation 167
Data model 179 Key 166 Relational databases 167
Database 164 Lost-update problem 178 Relationships 180
Database administration 172 Many-to-many (N:M) Rows 165
Database application 173 relationships 181 SQL Server 170
Database management system Maximum cardinality 181 Structured Query Language (SQL) 171
(DBMS) 170 Metadata 167 Table 165
DB2 170 Minimum cardinality 194 Unified Modeling Language
Dynamo 188 MongoDB 188 (UML) 179

MyMISLab ™

Go to mymislab.com to complete the problems marked with this icon .

uSinG your KnowledGe

5-1. Draw an entity-relationship diagram that shows the b. Make a list of 10 different products that Acxiom
relationships among a database, database applica- provides.
tions, and users. c. Describe Acxiom’s top customers.
d. Examine your answers in parts b and c and de-
5-2. Consider the relationship between Adviser and
Student in Figure 5-21. Explain what it means if the scribe, in general terms, the kinds of data that
maximum cardinality of this relationship is: Acxiom must be collecting to be able to provide
those products to those customers.
a. N:1 e. What is the function of InfoBase?
b. 1:1 f. What is the function of PersonicX?
c. 5:1 g. In what ways might companies like Acxiom need
d. 1:5
to limit their marketing so as to avoid a privacy
5-3. Identify two entities in the data entry form in Figure outcry from the public?
5-28. 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
5-4. Visit www.acxiom.com. Navigate the site to answer data services that governmental agencies can
the following questions. buy from companies like Acxiom? Why or why
a. According to the Web site, what is Acxiom’s pri- not?
vacy policy? Are you reassured by its policy? Why
or why not?