This assignment focuses on database modeling for a university information system. It begins with an introduction to the concept of a centralized database and its advantages, such as data integrity and reduced redundancy. The core of the assignment involves the design of the database, identifying key entities like DEPARTMENT, COURSE, MODULES, STUDENTS, FACULTY, QUALIFICATIONS, and TEACHING. A crucial part of the solution is the normalization process, which is demonstrated through 1NF, 2NF, and 3NF, to eliminate data redundancy and anomalies. An Entity Relationship Diagram (ERD) is provided to visualize the relationships between the entities. The solution also includes a data dictionary detailing table names, field names, data types, sizes, and primary/foreign key constraints. Finally, the assignment concludes with the implementation of the database, including table creation scripts, sequence creation, and the addition of primary and foreign key constraints, along with sample data insertion scripts, all designed to create a functional and normalized university database.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
