2. What is a composite entity, and when is it used? 3. What is a recursive...

 

Transcribed Image Text:

2. What is a composite entity, and when is it used? 3. What is a recursive relationship? Give an example. 4. Discuss the difference between a composite key and a composite attribute. 5. What is a derived attribute? Give an example. 6. Discuss the difference between a composite key and a composite attribute. 7. A BOOK must have one or more AUTHORS. Each AUTHOR must write at least one BOOK. This M:N relationship is decomposed to form the bridge entity BOOK_AUTHOR. Fill the tables below with sample data and indicate the primary and foreign keys. BOOK ISBN AUTHOR AID BOOK_AUTHOR AID TITLE FIRST DATE PUB LAST ISBN price CITY 2. What is a composite entity, and when is it used? 3. What is a recursive relationship? Give an example. 4. Discuss the difference between a composite key and a composite attribute. 5. What is a derived attribute? Give an example. 6. Discuss the difference between a composite key and a composite attribute. 7. A BOOK must have one or more AUTHORS. Each AUTHOR must write at least one BOOK. This M:N relationship is decomposed to form the bridge entity BOOK_AUTHOR. Fill the tables below with sample data and indicate the primary and foreign keys. BOOK ISBN AUTHOR AID BOOK_AUTHOR AID TITLE FIRST DATE PUB LAST ISBN price CITY

Answer rating: 100% (QA)

2 A composite entity is an entity that is composed of multiple attributes where each attribute repre... View the full answer