Wiki

Database Design for a University Organization

Abstract

An entity relationship diagram (ERD), also known as an entity relationship model, is a graphical representation that depicts relationships among people, objects, places, concepts or events within an information technology (IT) system. We have to design database design for a university Organization as per the requirement.

Steps to create ERD

SQL to create tables and relationship

Click here for details on SQL or download it from Repository.

ERD Diagram

SQL - Insert data into each table

SQL - Select data to display the record