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_IDCOURSE_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