Microsoft Office Tutorials and References
In Depth Information
1. What are the formal names for a table, for a row, and for a column? What are the
popular names for a row and for a column?
2. What is a domain?
3. What is an entity?
4. What is the relationship between a primary key and a candidate key?
5. What is a composite key?
6. What is a foreign key?
7. Look for an example of a one-to-one relationship, an example of a one-to-many rela-
tionship, and an example of a many-to-many relationship in a newspaper, magazine,
book, or everyday situation you encounter. For each one, name the entities and select
the primary and foreign keys.
8. When do you use an entity subtype?
9. What is a composite entity in an entity-relationship diagram?
10. What is the entity integrity constraint?
11. What is referential integrity?
12. What does the cascades option, which is used with referential integrity, accomplish?
13. What are partial and transitive dependencies?
14. What three types of anomalies can be exhibited by a table, and what problems do
15. Figure A-24 shows the Employee, Position, and Employment tables with primary keys
EmployeeNum, PositionID, and both EmployeeNum and PositionID, respectively.
Which two integrity constraints do these tables violate and why?