Relational Database Management System Practical

• The Students can able to demonstrate an understanding of the elementary & advanced features of DBMS & RDBMS • To develop a clear understanding of the conceptual frameworks and definitions of specific terms that are integral to the Relational Database Management Systems • Attain a good practical understanding of the SQL • Understanding clear concepts about Relational Model. • Examine techniques pertaining to Database design practices • Students will create database tables and joins them using SQL commands • Understand the basic concepts of Concurrency Control & database security • Understand the basic concept how storage techniques are used to backup data and maintain data access performance in peak hours • Evaluate options to make informed decisions that meet data storage, processing, and retrieval needs. • Able to design and documents data structures incorporating integrity constraints to satisfy business rules by applying the relational mode • Able to build, populate, and document a secure, normalized database that meets business requirements using industry standards and best practices • Able to develop structured query language (SQL) queries to create, read, update, and delete relational database data


HARDWARE: Computer with Intel core i3 processor, 500GB Hard Disk, 2 GB RAM SOFTWARE: Windows 7 OS, MYSQL Server5.1, Command Prompt