Explore BrainMass
Share

Designing a sample relational database

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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

© BrainMass Inc. brainmass.com October 16, 2018, 11:58 pm ad1c9bdddf
https://brainmass.com/computer-science/databases/designing-a-sample-relational-database-276004

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.

$2.19
Similar Posting

Real world examples of relational database types

Would you help me to find examples in every day life of a one-to-one relationship, a one-to-many relationship and a many-to-many relationship?

View Full Posting Details