Physical Modeling Design & Structured Query Language (SQL)

Running Head: DATABASE 1

DATABASE 3

Database

Student Name

Tutor’s Name

Date

Artist

Artist_ID

Name

Event

Event_ID

Date

Organizers

Organizer_ID

Name

Manager

Manager_ID

Name

Album

Album_ID

Title

Artist_ID

Year

Label_ID

Label

Label_ID

Name

Producer

Producer_ID

Name

Release

Release_ID

Date

1 1

*

*

1

1 *

*

1 1

* *

1

*

Reference

Schmidt & Brodie, M. L. (2018). Relational database systems: Analysis and comparison. Springer Science & Business Media.

Captain, F. A. (2018). Six-step relational database design: A step by step approach to relational database design and development. Fidel A Captain.