Explore BrainMass

Designing a sample relational database

Design a relational database containing information about music composers, their lives, and their compositions

Solution Preview

A relational database consists of tables that contain data and the
relationships between them. For this solution we need to store
information about composers, their lives, and their compositions. For
the lives of composers we will store their name, date of birth, birth
location, and age at death (0 if they are still alive). The
composition data that ...

Solution Summary

This solution provides a sample relational database. It explains why the tables are created the way they are. It also includes SQL statements to create the database.