Database

Table of Contents
Part A: Convert ERD to Relational information 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_name)
        primitive name (campus_id)
Staff_Member (staff_member_id, first_name, last_name, campus_id_located)
        Primary pigment (staff_member_id)
        unusual Key campus_id_located References Campus

Question A.2 

Contractor (contractor_id, first_name, last_name)
        Primary Key (contractor_id)
Skill(skill_id, skill_description)
        Primary Key (skill_id)
Employed (contractor_id, skill_id, skill_acquired_date)
        Primary Key (contractor_id, skill_id)
        contrary Key contractor_id References Contractor
        Foreign Key skill_id References Skill
Question A.



3
Staff_Member (staff_member_id, first_name, last_name)
        Primary Key (staff_member_id)
Project (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 schema:
GRADE_REPORT(Student_ID, Course_ID, Student_Name, Campus_Adress, Major, Course_title, Instructor_Name, Instructor_Location, Grade)
utilitarian dependencies:
Student_ID Student_Name, Campus_Adress, Major
Course_ID Course_Title, Instructor_Name, Instructor_Location
Student_ID, Course_ID Grade
Functional dependency diagram:

Student_ID | Course_ID | Student_Name| Campus_Adress| Major| Course_Title| Instructor_Name| Instructor_Location| Grade|

Question 2:
This relation is in the...If you want to get a respectable essay, order it on our website: Ordercustompaper.com



If you want to get a full essay, wisit our page: write my paper