Database

Table of Contents man A: Convert ERD to Relational instruction Model2 Part B: Normalization3 Part C: ERD and RDM5 Part A: Convert ERD to Relational data Model dubiety A.1 Campus(campus_id ,campus_code, campus_ realize)         primitive name (campus_id) Staff_Member (staff_member_id, first_name, last_name, campus_id_located)         uncomplicated pigment (staff_member_id)         curious recognize campus_id_located References Campus enquire A.2  affirmer (contractor_id, first_name, last_name)         firsthand constitute (contractor_id) Skill(skill_id, skill_description)         Primary come across (skill_id) Employed (contractor_id, skill_id, skill_acquired_date)         Primary Key (contractor_id, skill_id)         contrary Key contractor_id References Contractor         outside(prenominal) Key skill_id References Skill head A.

3 Staff_Member (staff_member_id, first_name, last_name)         Primary Key (staff_member_id) hear (project_id, project_name, staff_supervise_id)         Primary Key (project_id)         Foreign Key staff_supervise_id References Staff_Member Work_On (project_id, staff_member_id, staff_member_work_start_date, staff_member_work_end_date)         Primary Key (project_id, staff_member_id)         Foreign Key project_id References ProjectForeign Key staff_member_id References Staff_Member         Part B: Normalization Question 1: Relation abstract: GRADE_REPORT(Student_ID, Course_ID, Student_Name, Campus_Adress, Major, Course_title, Instructor_Name, Instructor_Location, social class) utilitarian dependencies: Student_ID Student_Name, Campus_Adress, Major Course_ID Course_Title, Instructor_Name, Instructor_Location Student_ID, Course_ID Grade Functional settlement diagram: Student_ID | Course_ID | Student_Name| Campus_Adress| Major| Course_Title| Instructor_Name| Instructor_Location| Grade| Question 2: This recounting is in the...If you want to fall a respectable essay, install it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.