I am having trouble understanding how to put my database RSD design into BCNF. I

Question

I am having trouble understanding how to put my database RSD design into BCNF. I need help/guidance in putting the RSD below into Boyce-Codd normal form (BCNF)... please list steps/explanantion in answer. Thank you... I get the concept, but I am having trouble actually following the steps to get it to BCNF (I have a feeling that I am way overcomplicating it).

Course Book ISBN: NUMERIC NOT NULL IPK Course Num: NUMERIC NOT NULL PFK Architect ID: VARCHAR NOT NULL PFK COURSE Book Title: VARCHAR NOT NULL Course Num: NUMERIC NOT NULL IPK Book Author: VARCHAR Architect ID: VARCHAR NOT NULL (PK Publisher Supplier: CHAR Required for Course: VARCHAR(3) NOT NULL Course Name: VARCHAR (9) NOT NULL CourseName: VARCHAR NOT NULL Course Schedule: VARCHAR (50) Book Update: CHAR(1) Semester Taught: VARCHAR Reason For Update: VARCHAR Prerequisite: VARCHAR(50) NOT NULL Update Date: DATE NOT NULL Course Book: VARCHAR (5) Program Outcome: VARCHAR NOT NULL ram Outcome Course Outcome In Pass Fail: CHAR NOT NULL IPK Pass Fail: CHAR NOT NULL [PFK J Course Program INTL Course Num: NUMERIC NOT NULL IPFK Course Num: NUMERIC NOT NULL [PFK Architect ID: VARCHAR NOT NULL [PFK Course Num: NUMERIC NOT NULL PFK Architect ID: VARCHAR NOT NULL PFK Architect ID: VARCHAR NOT NULL [PFK J Learning objective: VARCHAR Course Architect Architect Outcome INT Course Outcome Architect ID: VARCHAR NOT NULL [PFK Architect D: VARCHAR NOT NULL IPFK Course Num: VARCHAR(1) NOT NULL [PFK Course Num: NUMERIC NOT NULL [PFK Course Num: NUMERIC NOT NULL [PFK Architect ID: V NOT NULL [PFK Architect Name: VARCHAR Architect Outcome Course Num: NUMERIC NOT NULL [PFK Architect Phone: NUMERIC(10) Pass Fail: CHAR NOT NULL [PFK Architect Email: VARCHAR Course Grade: NUMERIC Archi Update INT Architect RoomNum: VARCHAR Architect ID: VARCHAR NOT NULL [PFK Course Num: NUMERIC NOT NULL [PFK Course Update Architect ID: VARCHAR NOT NULL PFK Course Num: NUMERIC NOT NULL IPFK Course Overview Update DATE: DATE NOT NULL Course Num: NUMERIC NOT NULL [PFK j Reason for Change: VARCHAR Architect ID: VARCHAR NOT NULL PFK Overview: VARCHAR(10) NOT NULL Semester Taught: CHAR(3)

Explanation / Answer

As per the above database design i am explaning the database design diagram in below steps.

1) In Course table ther is many attributes but only one attribute is Course-num which is primary key, so using this key we can understand the all diagram.

2) The Course table distributes into two sub tables which is Course_Program_Int and Course_Architect. So in Course_architect we can get all the values related to Course Architecture and from table Course_program we can get Course Id and Architect Id.

3) Course table further devided to course_book which will provide's the information about cous=rse book details.

4) Course_Program_Int has an foreign key reference to Program_outcome.

5) In Program_outcome table one foreign key is ther that is pass_fail which is refences to Prog_Course_Outcome_intersection.

6) Course architec has an foreign key which refences by Achitect_Outcome_int,course_outcome,architect_update,course_update and Course_Overview.

7) Each table has an refencial foreign key so that these tables can join with one another and can get the output.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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