ER Diagram, Relational Data Logical Model, Data Dictionary

BIT358
Advanc
e
Databa
ses
May 4
2019
Student ID:
Student Name:
Assessment
2 –
Semester 1

Task1: ER Diagram
(CS Odessa Corp. 2019)
(Cinergix Pty Ltd. 2011)
Assumptions
1. The course is the major of the student.
2. A student will enroll for only one course.
3. There will be number of subjects in a course.

Task2: Relational Data Logical Model
Course (courseCode, course, description)
Primary Key (courseCode)
Student (studentId, studentName, address, phone, email, fatherName, motherName, DOB,
courseCode)
Primary Key (studentId)
Foreign Key (courseCode) References Course (courseCode)
Subject (subjectCode, title, description, courseCode, lecturer, campus, room)
Primary Key (subjectCode)
Foreign Key (courseCode) References Course (courseCode)
Grade (grade, description, range)
Primary Key (grade)
Result (studentId, courseCode , semester, subjectCode, grade)
Primary Key (studentId , courseCode, semester, subjectCode)
Foreign Key (studentId) References Student (studentId)
Foreign Key (courseCode) References Course (courseCode)
Foreign Key (subjectCode) References Subject (subjectCode)
Foreign Key (grade) References Grade (grade)
(1keydata.com 2015)
Task3: Data Dictionary