Vocalist vocalistID INT vocaType VARCHAR(45) H+------- Musician musicianID INT I

Question

Vocalist vocalistID INT vocaType VARCHAR(45) H+------- Musician musicianID INT Indexes Guitarist guitaristID INT Musician Band -K guitar Brand VARCHAR(45 -1-H--- musician ID INT bandID INT Musician musicianID INT song ID INT firstName VARCHAR (45) bandName VARCHAR (45) --The songTitle VARCHAR(45) ocalist vocaistD INT HI-- --toE song Gen VARCHAR(45 lastName VARCHAR (45 Gender VARCHAR (45) Guitarist guitarist ID INT Band band ID INT Birthday DATE Bassist bassistID INT Bassist Performance performanceID INT bassistID INT ----t Drummer drummer ID INT --kE bass Brand VARCHAR(45 HH t-- Musician musicianID INT l Instructor instructor ID INT Drummer firstName VARCHAR (45) drummerID INT Performance lastName VARCHAR(45) drum VARCHAR(45) HI Brand perform anceID INT Gender VARCHAR (45) Musician musicianID INT Tim VARCHAR(45 Birthday DATE Date DATE Band bandID INT

Explanation / Answer

There are some probelm in this diagram:

1) Song: Song is connected with band but this is also intergrated with guitarist, drummer and basisit. becuase these people can also sing a song.

2) Instructor: Instructor is connected with band only but is has to be connected with drummer, basisit,guitarist as well.

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.