DBMS Subject Includes Knowledge About Working of a Database Management System and Several Types of databases ...Also the How to Databases Are Created By Data Models .. Sql is Structured Query Language which is used to manipulate,add,delete data from the Databases..
Reference Books:
For More Help/Info Regarding The Subject U can Contact/Mail Us At bscit.cracked999@gmail.com
Reference Books:
1. A Silberschatz, H Korth, S Sudarshan, “Database System and Concepts”, Sixth Edition
2. Database Management Systems Book By Vipul Prakashan For Bsc-IT
Practicals:
1.Design a Database and create required tables. For e.g. Bank, College Database
2. Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables.
3. Write a sql statement for implementing ALTER,UPDATE and DELETE
4. Write the queries to implement the joins
5. Write the query for implementing the following functions:
MAX(),MIN(),AVG(),COUNT()
6. Write the query to implement the concept of Intergrity constrains
7. Write the query to create the views
8. Perform the queries for triggers
9. Perform the following operation for demonstrating the insertion , updation and
deletion using the referential integrity constraints
10. Write the query for creating the users and their role.
1.Design a Database and create required tables. For e.g. Bank, College Database
2. Apply the constraints like Primary Key , Foreign key, NOT NULL to the tables.
3. Write a sql statement for implementing ALTER,UPDATE and DELETE
4. Write the queries to implement the joins
5. Write the query for implementing the following functions:
MAX(),MIN(),AVG(),COUNT()
6. Write the query to implement the concept of Intergrity constrains
7. Write the query to create the views
8. Perform the queries for triggers
9. Perform the following operation for demonstrating the insertion , updation and
deletion using the referential integrity constraints
10. Write the query for creating the users and their role.
For More Help/Info Regarding The Subject U can Contact/Mail Us At bscit.cracked999@gmail.com
No comments:
Post a Comment