Question

Lab Tasks 1. For the following ER diagram, convert the conceptual design to relational design using the systematic methodology i.e. 7 step algorithm. Map each part of ERD using the steps given. Write down each step of the mapping separately. ERD for Student Record 1 STUDENT PREVIOUS EDUCATION N CourseName Semester Year PartialKey Grade TRANSCRIPT Name ATTENDANCE RECORD N 1 COLLEGE 1 COLLEGE_ ATTENDED StartDate EndDate H ATTENDANCE M Month DEGREES Year N Name DEGREE

          Lab Tasks
1. For the following ER diagram, convert the conceptual design to relational design using
the systematic methodology i.e. 7 step algorithm. Map each part of ERD using the steps
given. Write down each step of the mapping separately.
ERD for Student Record
1
STUDENT
PREVIOUS
EDUCATION
N
CourseName Semester Year
PartialKey
Grade
TRANSCRIPT
Name
ATTENDANCE
RECORD
N
1
COLLEGE
1
COLLEGE_
ATTENDED
StartDate
EndDate
H
ATTENDANCE
M
Month
DEGREES
Year
N
Name
DEGREE

Lab Tasks
1. For the following ER diagram, convert the conceptual design to relational design using
the systematic methodology i.e. 7 step algorithm. Map each part of ERD using the steps
given. Write down each step of the mapping separately.
ERD for Student Record
1
STUDENT
PREVIOUS
EDUCATION
N
CourseName Semester Year
PartialKey
Grade
TRANSCRIPT
Name
ATTENDANCE
RECORD
N
1
COLLEGE
1
COLLEGE
ATTENDED
StartDate
EndDate
H
ATTENDANCE
M
Month
DEGREES
Year
N
Name
DEGREE

Added by Warren V.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Robert Fox

Step 1

Primary keys are underlined. - **COLLEGE**(*CollegeID*, CollegeName, Location) - **STUDENT**(*StudentID*, Name, Ethnicity) - **COURSE**(*CourseCode*, CourseName, Semester) - **DEGREE**(*DegreeID*, DegreeName) Show more…

Show all steps

Thanks for your feedback!

Lab Tasks For the following ER diagram, convert the conceptual design to relational design using the systematic methodology, i.e., the 7-step algorithm: Map each part of the ERD using the steps given. Write down each step of the mapping separately. ERD for Student Record EpI: COLLEGE COLLEGE_ATTENDED StartDate EndDate PREVIOUS_EDUCATION STUDENT ATTENDANCE Month ATTENDANCE_RECORD CourseCode Semester DEGREES Ethnicity TRANSCRIPT DEGREE