{"id":13777,"date":"2025-03-20T04:18:49","date_gmt":"2025-03-20T04:18:49","guid":{"rendered":"https:\/\/bvcoend.ac.in\/?page_id=13777"},"modified":"2026-04-02T06:35:00","modified_gmt":"2026-04-02T06:35:00","slug":"dbms-labece","status":"publish","type":"page","link":"https:\/\/bvcoend.ac.in\/index.php\/dbms-labece\/","title":{"rendered":"DBMS Lab(ECE)"},"content":{"rendered":"[vc_row][vc_column width=”1\/4″][vc_wp_custommenu title=”Imp Links” nav_menu=”73″][\/vc_column][vc_column width=”3\/4″][vc_column_text]Introduction<\/strong><\/span><\/p>\n

The requirement of modern days is to have an\u00a0automated system that manages, modifies, and updates data accurately<\/strong>. This is achieved by a DBMS in robust, correct, and non-redundant way. DBMS lab aims at practicing and achieving this aim by using various software’s such as MYSQL, SQL PLUS. Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database.<\/span><\/p>\n

Course Objectives <\/strong><\/span><\/p>\n\n\n\n\n\n\n
COB-1<\/span><\/td>\nTo introduce basic concepts, architecture and characteristics of database systems.<\/span><\/td>\n<\/tr>\n
COB-2<\/span><\/td>\nTo introduce relational model concepts and PL\/SQL programming.<\/span><\/td>\n<\/tr>\n
COB-3<\/span><\/td>\nTo introduce relational database design and Normal forms based on functional dependencies.<\/span><\/td>\n<\/tr>\n
COB-4<\/span><\/td>\nTo introduce concepts of object oriented & distributed databases.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/strong><\/span><\/p>\n

Course Outcomes <\/strong><\/span><\/p>\n\n\n\n\n\n\n\n
CO<\/strong><\/span><\/td>\nStatement<\/strong><\/span><\/td>\nBloom\u2019s Level<\/strong><\/span><\/td>\n<\/tr>\n
OCSE 407.1<\/span><\/td>\nAbility to understand advantages of database systems..<\/span><\/td>\nRemembering,<\/span><\/p>\n

Understanding<\/span><\/td>\n<\/tr>\n

OCSE407.2<\/span><\/td>\nAbility to use SQL as DDL, DCL and DML.<\/span><\/td>\nApplying<\/span><\/td>\n<\/tr>\n
OCSE407.3<\/span><\/td>\n\u00a0Ability to design database and manage transaction processing<\/span><\/td>\nEvaluating<\/span><\/p>\n

Create<\/span><\/td>\n<\/tr>\n

OCSE407.4<\/span><\/td>\nUnderstand object oriented & distributed databases systems and use them.<\/span><\/td>\nAnalysing<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

CO-PO-PSO Mapping <\/strong><\/span><\/p>\n\n\n\n\n\n\n\n
CO\/PO<\/strong><\/span><\/td>\nPO1<\/strong><\/span><\/td>\nPO2<\/strong><\/span><\/td>\nPO3<\/strong><\/span><\/td>\nPO4<\/strong><\/span><\/td>\nPO5<\/strong><\/span><\/td>\nPO6<\/strong><\/span><\/td>\nPO7<\/strong><\/span><\/td>\nPO8<\/strong><\/span><\/td>\nPO9<\/strong><\/span><\/td>\nPO10<\/strong><\/span><\/td>\nPO11<\/strong><\/span><\/td>\nPO12<\/strong><\/span><\/td>\nPSO1<\/strong><\/span><\/td>\nPSO2<\/strong><\/span><\/td>\n<\/tr>\n
OCSE 407.1<\/span><\/td>\n2<\/span><\/td>\n<\/td>\n3<\/span><\/td>\n<\/td>\n2<\/span><\/td>\n<\/td>\n<\/td>\n<\/td>\n2<\/span><\/td>\n2<\/span><\/td>\n<\/td>\n2<\/span><\/td>\n2<\/span><\/td>\n1<\/span><\/td>\n<\/tr>\n
OCSE407.2<\/span><\/td>\n2<\/span><\/td>\n<\/td>\n<\/td>\n<\/td>\n2<\/span><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n2<\/span><\/td>\n<\/td>\n2<\/span><\/td>\n2<\/span><\/td>\n2<\/span><\/td>\n<\/tr>\n
OCSE407.3<\/span><\/td>\n2<\/span><\/td>\n3<\/span><\/td>\n<\/td>\n<\/td>\n2<\/span><\/td>\n2<\/span><\/td>\n<\/td>\n<\/td>\n<\/td>\n2<\/span><\/td>\n<\/td>\n3<\/span><\/td>\n2<\/span><\/td>\n1<\/span><\/td>\n<\/tr>\n
OCSE407.4<\/span><\/td>\n2<\/span><\/td>\n<\/td>\n<\/td>\n<\/td>\n2<\/span><\/td>\n<\/td>\n<\/td>\n<\/td>\n<\/td>\n2<\/span><\/td>\n<\/td>\n2<\/span><\/td>\n2<\/span><\/td>\n1<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\"\"<\/strong><\/span><\/p>\n

Facilities<\/strong><\/span><\/p>\n\n\n\n\n\n\n
Operating System \/Software <\/strong><\/span><\/td>\n<\/tr>\n
Sr. No.<\/span><\/td>\nName<\/strong><\/span><\/td>\nVersion<\/strong><\/span><\/td>\n<\/tr>\n
1.<\/span><\/td>\nWindows<\/span><\/td>\n10 pro<\/span><\/td>\n<\/tr>\n
2.<\/span><\/td>\nMYSQL<\/span><\/td>\nOpen source<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n\n\n\n\n\n\n
Hardware <\/strong><\/span><\/td>\n<\/tr>\n
Sr.No.<\/strong><\/span><\/td>\nEquipment Name<\/strong><\/span><\/td>\nSpecification<\/strong><\/span><\/td>\nQuantity<\/strong><\/span><\/td>\n<\/tr>\n
1.<\/span><\/td>\nComputer<\/span><\/td>\n13th<\/sup>\u00a0 Ge intel core i9,32 GB RAM<\/span><\/td>\n24<\/span><\/td>\n<\/tr>\n
2.<\/span><\/td>\nPrinter<\/span><\/td>\nHP Laser jet, M1005MFP<\/span><\/td>\n01<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\u00a0<\/strong><\/span><\/p>\n

Staff<\/strong><\/span><\/p>\n