This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: • Chapters 6 & 7 o Quiz: • Which item represents an accuracy problem? 42x-1029 (there is a typographical error) • Which represents a completeness problem? 801-442-391 • Which item above represents a consistency problem? Frank & Linda Linda (it's where the names are listed together, and then by themselves) • Which item represents an uniqueness problem Peggy Morrill (her name is in their twice) • Why do relational database use primary keys and foreign keys? To create logical relationships (this is how you link sets of tables together. ER diagrams are Entity Related Diagrams) • What is one of the biggest pitfalls associated with real-time information? I t continually changes. (2 seconds from now it's not up to date from now) • Which of the following is correct in reference to a database? A database can support many logical views • Which of the following is not t rue about information redundancy?...
View Full Document
- Winter '09
- Relational model, Wikipedia, information integri ty, Integri ty constraint