Hello, I have a database question. What Normal Form is this databse in? (1NF, 2N

Question

Hello, I have a database question. What Normal Form is this databse in? (1NF, 2NF BCNF etc.) Any errors?

Musician

Band

BandMember

Instructor

Song

Performance

Band Member Musician bandMemID INT musicianID INT instrument VARCHAR (45) firstName VARCHAR(45) musicianID INT lastName VARCHAR(45) band ID INT o gender VARCHAR(2) ------tea birthday DATE Indexes experience VARCHAR(45) PRIMARY Indexes fk and Member Musician id PRIMARY fk BandMember Band idx Band band ID INT band Name VARCHAR (45) totalMembers INT instrutorID INT Indexes PRIMARY fk Band Instructor1 idx Instructor instrudonID INT ame VARCHAR 45) lastName VARCHAR(45) gender VARCHAR(2) o specialty VARCHAR(45) Indexes PRIMARY Performance v time (0) date DATE Song ID INT t bandID INT Indexes fk Performance Song1 idx PRIMARY fk Performance Bandi idx Song song ID INT title VARCHAR(45) genre VARCHAR (45) Indexes PRIMARY

Explanation / Answer

Database looks perfect. No error is there. Your data is in normalized form

Talking about the normal form, it's BCNF

Concerning Band_Member , musician , band Table

Functional dependencies:
band_id -> band detail
musician_id -> musician details

Candidate keys:
For first table: band_id
For second table: musician_id
For third table: {band_id, musician_id}

/*Feel free to post any query in comments*/

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

---

---

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