Skip to content

The project employed Oracle PL/SQL Developer; an RDBMS was engineered for streamlined university course enrolment. It commenced with precise ERD and DFD design using Lucidchart, enforcing data integrity via constraints, triggers, and sequences. Graphical reports showcased student performance and faculty acclaim, revolutionizing enrolment procedures

Notifications You must be signed in to change notification settings

gauribhale12/Course-Management-System-

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Course-Management-System

The project involved the creation of an RDBMS in Oracle PL/SQL Developer, aimed at optimizing the university course enrolment process. It was designed to streamline and enhance the course registration procedures.

The initial phase of the project focused on establishing a solid foundation by developing an Entity-Relationship Diagram (ERD) and four Data Flow Diagrams (DFDs) using Lucidchart. These visual tools were instrumental in defining entities, attributes, data types, and constraints, providing a clear roadmap for database development.

To maintain data accuracy and minimize redundancy, the project incorporated various data management techniques, including constraints, triggers, and sequences. These elements played a critical role in ensuring data integrity and efficiency.

A user role system was implemented to control data access, enhancing security and confidentiality. This feature ensured that users had appropriate privileges while safeguarding sensitive information.

Furthermore, the project introduced a graphical reporting system, utilizing views and report tables to generate five informative graphs. These graphs offered valuable insights into student grades, fees, professor popularity, and more, providing a holistic view of the enrolment process and academic performance.

In summary, the project successfully integrated database management and reporting, revolutionizing the university's course enrolment system for the better.

About

The project employed Oracle PL/SQL Developer; an RDBMS was engineered for streamlined university course enrolment. It commenced with precise ERD and DFD design using Lucidchart, enforcing data integrity via constraints, triggers, and sequences. Graphical reports showcased student performance and faculty acclaim, revolutionizing enrolment procedures

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages