Posts

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.    

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.  

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.

Functional Requirements of the System

Introduction about Functional Requirements Functional requirements should relate to the tasks that the database system will perform usually in the form of searching and sorting.             Functional Requirements Functional requirements are requirements that directly contribute to the functioning of any system. * Students can be registered to the system using their student ID. * Each student should be recorded with their student ID, Name, Date of Birth, and Telephone number in the system. * Each department records the details of the students and the courses available. * Students can access their information using their registered ID or student ID. * Staff should maintain the student records, course details, and the department details.

Identification of Business Processes

Image
                                   Introduction of Business Process A Business Process means a series of steps performed by a group of stakeholders to achieve a concrete goal. If simply explain, a business process is a process that is focused on achieving a goal for a business. The importance of business processes is a process forms the lifeline for any business and helps it streamline individual activities, making sure that resources are put to optimal use. Example for Business Processes :-   Staff on boarding and time off requests   Student admission and registration  Processing financial aid applications   Curriculum approvals   Scheduling Business Process Management- BPM It is the discipline in which people use various methods to discover, model, analyze, measure, improve, optimize and automate business processes. Business Process Reengineering is a business management strategy, originally Pioneered in the early 1990 (Michael Hammer published an article in the Harvard Busin

Identification of Actors

  Actors of the system Actors are parties that contribute to the well-being of the system. These parties interact with each other to ensure the existence of a system. We can identify the following actors in the selected scenario. Actors * Department head * Students * Staff

ER Diagram with Assumptions and Explanation

Image
  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