ER Diagram with Assumptions and Explanation

-

 Introduction for ER diagram

ER Diagram means Entity Relationship Diagram in DBMS. Entity Relationship model describes the structure of the database from the help of this diagram. ER diagram uses for data modelling and relational database. There are some components of an entity relationship diagram such as entities, attributes, relationships and connecting lines.

The Entity-Relationship Diagram of the academic institution system shows all the  instrument of the database table and the relational between students, faculties, registrations, staff, teachers and etc.



In this diagram,
   There are 4 entities, they are 
  • Institude,
  • Department
  • DepatHead 
  • Staff


Comments

Post a Comment

Popular posts from this blog

Relational Database Schema

-
Image
  Introduction for relational database schema A relational schema is a plan used in database design to represent the data to be entered into the database and describe how that is structured in tables. It describes how those table relate with each tables.  
Read more

Non- Functional Requirements of the System

-
Introduction about NON Functional Requirements Non functional requirements is the genera; properties of a system. They also known as quality attributes.        Non- Functional requirements of the system Non-functional requirements are requirements that do not directly interfere with the operation of a system but are useful if present. * Students can be accessed the student details within 5 seconds. * Improve performance by using computers that have higher processor speed and RAM. * The system should available at any time of the day. *Instructional messages should be displayed to guide the user. * In addition to internal security, external security should be applied to the login authentication.
Read more

SQL Database

-
Image
    Introduction for SQL SQL stands for Structured Query Language. It is   a standard language for Relational database system. SQL used to create, remove, update, retrieve and alter the data in database. SQL access manipulate database. Academic Institution has a wide variety database system. Such as student registrations application, students assessments application, tuition payment methods, E-learning system are them. So that they want a cost effective solution for handle these situations. SQL is cost-effective database most of the academic institution used in the world.    
Read more