Managment Information Systems 6 a. Transform the following E-R diagram into a se

Question

Managment Information Systems

6 a. Transform the following E-R diagram into a set of 3NF relations. Make up a primary key and one or more non-key attributes for each entity. (1.5 points)

6. b. For the following relation, indicate which normal form the relation conforms to (if any). Please note that the functional dependencies (FD) that exist in the relation have been provided to you. In your response, please explain why the relation is (or is not) in a particular normal form. Then, show how the relation can be composed into multiple relations each of which conforms to the highest normal form (i.e., 3 NF) (1.5 points)

STUDENT COURSES (STUDENT_ID, COURSE_ID, STUDENT_NAME, CAMPUS_ADDRESS, MAJOR, COURSE_TITLE, INSTR_NAME, INSTR_LOCATION, GRADE)

FD: STUDENT_IDà STUDENT_NAME, CAMPUS_ADDRESS, MAJOR;

FD: COURSE_IDàCOURSE_TITLE, INSTR_NAME, INSTR_LOCATION;

FD: INSTR_NAMEà INSTR_LOCATION;

FD: STUDENT_ID, COURSE_IDà GRADE

Is_placed_by ORDER Contains Places lscontainedin - - Owns CUSTOMER H SHOPPING CART INVENTORY Is_owned_by Contains Is contained in

Explanation / Answer

SOLUTION:-

6(a):-  

CUSTOMER

ORDER

SHOPPING CART

INVENTORY

Note:- In table columns, all bold values are primary keys and all Italic values are foreign keys.

6(b):- The relation mentioned in the question shapes in 1NF having no duplicate rows and every cell consist of single item of knowledge. The Attributes are not only dependent on primary keys values that's why the given relation can not be in 2NF or 3NF.

For Example:- COURSE_TITLE is dependent on COURSE_ID but does not keep faith on STUDENT_ID. Similarly INSTR_NAME, INSTR_LOCATION, and GRADE are not dependent on any primary keys values so these can be constituted into 3NF.

STUDENT

COURSES

INSTRUCTOR

GRADE

======================================================================================

Customer_id Name Address Zip_Code

Related Questions

Navigate

• Browse (All)
• Browse M
• Subjects

---

---

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