CO1 : To define basic functions of DBMS & RDBMS, analyze database models & entity relationship models.
Database System Management
Academic Year : 2019-20 T.E. Semester I
A database management system (DBMS) is a software package designed to define, manipulate, retrieve and manage data in a database. A DBMS generally manipulates the data itself, the data format, field names, record structure and file structure. It also defines rules to validate and manipulate this data.
Educational Opportunities in DBMS :
In any company, database technology is considered as a significant business asset. It is a tool that can help in determining the future direction of a company. In current times, true value of a business can't be realized without using this technology. Businesses have been transformed by embracing database technology which can be used to find a wealth of data and information. It is now being used in monitoring various business functions. One such area is mining customers buying patterns. The scope of careers in database technology has grown immensely. The most commonly pursued professions are as database analysts, administrators and engineers. The analysts are actually the bridge between the unstructured data to structured information. The administrators ensure that systems are operating efficiently, backing up and storing data properly, generating secure information and maximizing database uptime. Database engineers ascertain that the database management systems can discover, integrate, analyze and disseminate the information as intended. The average salary of a database technology practitioner ranges from 20,000 to 120,000 US dollars per annum depending on the career level in the hierarchy.
Unit I : INTRODUCTION TO DBMS
Unit II : DATABASE DESIGN AND SQL
CO2 : To design and implement a database schema for a given problem-domain. Also Populate and query a database using SQL DML/DDL commands
CO3 : To implement PL/SQL programming and basic concepts of transaction, transaction processing and concurrency control.
Unit IV : CONCURRENCY CONTROL AND ADVANCED DATABASES
CO4 : To understand the different types of database architectures and also their benefits.
Unit V : LARGE SCALE DATA MANAGEMENT
CO5 : To understand the impact of analytics and big data on the information industry and the external ecosystem for analytical and data services.
Unit VI : DATA WAREHOUSING AND DATA MINING
CO6 : To understand emerging database technologies. Also study the data warehousing and data mining.
Unit III : QUERY PROCESSING AND DATABASE TRANSACTIONS
CO1 : To define basic functions of DBMS & RDBMS, analyze database models & entity relationship models