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
FACILITIES AVAILABLE:
HARDWARE:
Computer with Intel core i3 processor, 500GB Hard Disk, 2 GB RAM
SOFTWARE:
Windows 7 OS, MYSQL Server5.1, Command Prompt