Entity Relationship Diagram for the Case Study

Running head: DATABASE FUNDAMENTAL ASSESSMENT
DATABASE FUNDAMENTAL ASSESSMENT
Name of the Student
Name of the University
Author Note

DATABASE FUNDAMENTAL ASSESSMENT1
Table of Contents
Entity relationship Diagram for the case study................................................................................2
Dependency diagram for the tables.................................................................................................4
Tables along with keys and primary data fields..............................................................................5
Form.................................................................................................................................................7
Queries.............................................................................................................................................7
Report..............................................................................................................................................9
Bibliography..................................................................................................................................10

DATABASE FUNDAMENTAL ASSESSMENT2
Entity relationship Diagram for the case study
Relational database
Module (Code_Module (pk), Title, Credits, Code_Degree (FK), DepartmentID(FK),
CordinatorID(FK))
Student_Enrollement (EnrollID(PK), Code_Degree (fk), Code_STD (FK), Enroll_date)
ClassesDetails (Code_Class(pk), Code_module(FK), Time_class)

DATABASE FUNDAMENTAL ASSESSMENT3
StudentData (Code_STD (PK), Name_Student, Student_Address, Age)
Attendance (Attendance (pk), Code_STD (fk), Code_Class (fk), Status)
Department (DepartmentID (pk), DepartmentName)
Unit_cordinator (CordinatorID (PK), Employee_ID (pk))
Lecture_data (Employee_ID(pk), Emp_name, Qualifictaions, Department ID (FK),
Emp_address, Emp_phno)
Degree ( Code_degree (pk), Duration, Title, Elective)