Submit a database design in which you address the following

Question

Submit a database design in which you address the following:

• Design a relational database containing the following information about Western classical music:
  • Composers
    • identificationNumber
    • name
    • nationality
    • date of birth
    • date of death
  • Compositions
    • identificationNumber
    • name
    • type
    • year of publication
    • opus
  • Avoid any redundancies in your database design.

Your database design should consist of at least 6 composers and at least 3 of their compositions.