Question: 1. Discuss the difference between a composite key and a composite attribute. How would each be indicated in an ERD?
2. What two courses of action are available to a designer who encounters a multivalued attribute?
3. What is a derived attribute? Give an example.
4. How is a relationship between entities indicated in an ERD? Give an example using the Crow's Foot notation.