System Analysis and Designing Assignment 2022

Running head: SYSTEM ANALYSIS AND DESIGNING
SYSTEM ANALYSIS AND DESIGNING- DBFN212/ BIT 208
Name of the Student
Name of the University
Author Note

SYSTEM ANALYSIS AND DESIGNING
1
Introduction:
The database is quite useful for storing and retrieving information from an online
environments. The database is actually an organized collection of data. These data are accessible
electronically from a specific type of computer system. In many of the cases database can be
become very much complex while the database will be using formal modelling and design
techniques.
Here, regarding the case scenario in this report an ERD will be established with having
all the entities and the relationships. This report will be also converting ERD to a relational table
set. In this aspect a new database will be also created and for the creation of database MS Access
will be utilized. Also, form will be created in this assignment for inputting and updating the data.
The above discussed tasks will be performed for this assignment.

SYSTEM ANALYSIS AND DESIGNING
2
ERD diagram based for the case study
In the above section diagram of the whole system has been presented. In the following
section of this report the ERD of is explained.
Relational Database
Degree (Deg_Code (PK), Time_Schedule, Elective_Subject, Degree_Title)
Student_Module (ID_Mod (PK), Cor_ID (FK), mod_title, Department_ID (FK), Deg_Code
(FK))

SYSTEM ANALYSIS AND DESIGNING
3
Department (DeptID (PK), Name_dept, Employee_ID (FK))
ClassDetails (Class_code (PK), ID_Mod (FK), Time_period)
Coordinator (Cor_ID (PK), Coordinator_Name, ID_Enroll (FK))
Enrollment_Details (ID_Enroll (PK), Deg_Code (FK), Student_code (FK), Date_enroll)
Attendance_Details (Overall_attend (PK), Student_code (FK), Class_code (FK))
Lecture Details (Employee_ID (PK), Name_employee, Degree, Dept_ID (FK), Address_Details,
Contactno_emp)
StudentDetails (Student_code (PK), Name, Address_std)
Relational view for the created queries
The abode diagrams is describing the relational view of the queries that has been created.
From the above diagram relationship among the various of classes for the database has been