Information Systems And Data Management Case Study

    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.    

  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.  

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.

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.