For any business to be successful, fast access to information is critical. Important decisions are based on the information available at any point in time. In order to get, correct information at any instant of time, data can be stored about the business on a computer system which facilitates fast and easy access to the information. Data can be stored in any form of text, numbers, pictures, and audio. Besides enabling data access, a computerized system also helps to manage data efficiently. To store and manage data, there is a need for specialized computer program known as Database Management System (DBMS).
In B. S. Anangpuria Institute of Technology & Management at our department of Computer Science & Engineering, we make our students understand the role of a database management system in an organization. They will learn basic database concepts including the structure and operation of the relational data model.
First of all, in order to interact with the database, an interface is needed in the form of SQL. Structured Query Language (SQL) is the set of statements with which all programs and users access data in an Oracle database. Application programs and Oracle tools often allow users access to the database without using SQL directly, but these applications, in turn, must use SQL when executing the user’s request.
Initially, we start with the basic Data Definition Language statements like Create, Alter, Drop, Truncate and also Data Manipulation Language statements like Insert, Select, Update, Delete, Like’%, Relational Operator. Beside above, to enhance the security of a database, there is a requirement of controlling the access to the table. Thus, Data Control Languages is used to provide certain privileges to a particular user like Commit, Rollback, Savepoint etc.
After gaining the basic knowledge, they will learn how to apply various constraints on the table such as Primary key, Foreign Key, Check, Unique, Null, Not null, Default, Enable Constraints, Disable Constraints, Drop Constraints etc which is necessary to maintain the accurate and consistent data.
In order to make tasks simpler, they will implement functions like aggregate functions, group functions (avg, count, max, min, sum). Moreover, set operations like union, intersection so on are also used here.
If any user wants to fetch the data from multiple locations in the database, the concept of Nested Queries & Join Queries can be used such as Inner join, Left join, Right join and Full join.
Every user has a different view. In order to extract the relevant information according to a particular user, Views in the database can be learned to fulfill the need.
We at Department of Computer Science & Engineering make sure that at the completion of this lab, they will be able to design and implement a small menu driven database projects like Library information System, Inventory control system, Student Information System, Time Table Development System etc.