UNIQUE SERIES AKTU Syllabus
BCS551BCS551H

Database Management Systems Lab

L-T-P0-0-2 Credits1 Session2024-25 TypeLab / Practical
Appears in 12 semesters · 12 branches

B.Tech Computer Science & Engineering · Sem 5 (Lab, code BCS551) · B.Tech Information Technology · Sem 5 (Lab, code BCS551) · B.Tech Artificial Intelligence & Machine Learning · Sem 5 (Lab, code BCS551) · B.Tech Artificial Intelligence & Data Science · Sem 5 (Lab, code BCS551) · B.Tech CSE (Artificial Intelligence) · Sem 5 (Lab, code BCS551) · B.Tech CSE (AI & ML) · Sem 5 (Lab, code BCS551) · B.Tech CSE (Data Science) · Sem 5 (Lab, code BCS551) · B.Tech CSE (Cyber Security) · Sem 5 (Lab, code BCS551) · B.Tech CSE (Internet of Things) · Sem 5 (Lab, code BCS551) · B.Tech Computer Science & Design · Sem 5 (Lab, code BCS551) · B.Tech Computer Science (Hindi) · Sem 5 (Lab, code BCS551H) · B.Tech Electronics & Computer Engineering · Sem 5 (Lab, code BCS551)

Download PDF

List of Experiments / Activities

  1. 1Installing oracle/ MYSQL
  2. 2Creating Entity-Relationship Diagram using case tools.
  3. 3Writing SQL statements Using ORACLE /MYSQL: a) Writing basic SQL SELECT statements. b) Restricting and sorting data. c)Displaying data from multiple tables. d)Aggregating data using group function. e)Manipulating data. e)Creating and managing tables.
  4. 4Normalization
  5. 5Creating cursor
  6. 6Creating procedure and functions
  7. 7Creating packages and triggers
  8. 8Design and implementation of payroll processing system
  9. 9Design and implementation of Library Information System
  10. 10Design and implementation of Student Information System
  11. 11Automatic Backup of Files and Recovery of Files
  12. 12Mini project (Design & Development of Data and Application ) for following : a) Inventory Control System. b) Material Requirement Processing. c) Hospital Management System. d) Railway Reservation System. e) Personal Information System. f) Web Based User Identification System. g) Timetable Management System. h) Hotel Management System
  13. Note: The Instructor may add/delete/modify/tune experiments, wherever he/she feels in a justified manner It is also suggested that open source tools should be preferred to conduct the lab (MySQL , SQL server , Oracle ,MongoDB ,Cubrid ,MariaDBetc) Database Management Systems Lab (BCS-551): Mapping with Virtual Lab Name of the Lab Name of the Experiment Data Definition Language(DDL) Statements: (Create table, Alter table, Drop table) Data Manipulation Language(DML) Statements Data Query Language(DQL) Statements: (Select statement with operations like Where clause, Order by, Logical operators, Scalar functions and Aggregate functions) Transaction Control Language(TCL) statements: (Commit(make changes permanent), Rollback (undo) Describe statement: To view the structure of the table created
Course Outcomes (COs)5 outcomes

After completion of the course student will be able to:

  1. CO1Understand and apply oracle 11 g products for creating tables, views, indexes, sequences and other database objects.K2, K4
  2. CO2Design and implement a database schema for company data base, banking data base, library information system, payroll processing system, student information system.K3, K5
  3. CO3Write and execute simple and complex queries using DDL, DML, DCL and TCL.K4, K5
  4. CO4Write and execute PL/SQL blocks, procedure functions, packages and triggers, cursors.K4, K5
  5. CO5Enforce entity integrity, referential integrity, key constraints, and domain constraints on database.K3, K4

Note: The AKTU syllabus PDF of some branches prints this subject with small differences in the course outcomes (AI & ML, AI & Data Science, CSE (AI), CSE (AI & ML), CSE (Data Science), CSE (Cyber Security), CSE (IoT), CS & Design). Please also check the official AKTU PDF of your branch, linked at the end of your semester page.

Official AKTU syllabus

This subject is on page 18, 19 of the original AKTU PDF.

Official AKTU syllabus PDF ↗