ER Modeling I - Q4
AGENT (AgentID, LName, Region…)
CLIENT (ClientID, LName,…)
MUSICIAN (MusicianID, AgentID, Name, DaysAvailable,…)
EVENT (EventID, ClientID, MusicianID, Date, Time, Location…)
INSTRUMENT (InsturmentID, …)
MUSICIAN_INSTRUMENT (MusicianID, InstrumentID, YearsExperience…)
All foreign keys not null.