FREE
AKTU Database Management Systems Lab (BCS551H) Syllabus PDF – B.Tech 3rd Year
Database Management Systems Lab BCS551H
All syllabus, notes, question bank & PYQ for this subject
Free
Download now
- English
- Semester 5
- 0 downloads
- 0 views
Official AKTU syllabus of Database Management Systems Lab (BCS551H) for B.Tech 3rd Year – 1 credits, L-T-P 0-0-2. Read the unit-wise course content, course outcomes, evaluation pattern and recommended books online, or download the PDF.
Syllabus — Database Management Systems Lab
Download PDFBCS551H · 1 credits · L-T-P 0-0-2
Course Outcomes
At the end of course , the student will be able to:
| CO 1 | Understand and apply oracle 11 g products for creating tables, views, indexes, sequences and other database objects. | K , K 2 4 |
| CO 2 | Design and implement a database schema for company data base, banking data base, library information system, payroll processing system, student information system. | K , K 3 5 |
| CO 3 | Write and execute simple and complex queries using DDL, DML, DCL and TCL. | K , K 4 5 |
| CO 4 | Write and execute PL/SQL blocks, procedure functions, packages and triggers, cursors. | K , K 4 5 |
| CO 5 | Enforce entity integrity, referential integrity, key constraints, and domain constraints on database. | K , K 3 4 |
Course Content
- Installing oracle/ MYSQL
- Creating Entity-Relationship Diagram using case tools.
- Writing SQL statements Using ORACLE /MYSQL:
- Writing basic SQL SELECT statements.
- Restricting and sorting data. c)Displaying data from multiple tables. d)Aggregating data using group function. e)Manipulating data. e)Creating and managing tables.
- Normalization
- Creating cursor
- Creating procedure and functions
- Creating packages and triggers
- Design and implementation of payroll processing system
- Design and implementation of Library Information System
- Design and implementation of Student Information System
- Automatic Backup of Files and Recovery of Files
- Mini project (Design & Development of Data and Application ) for following :
- Inventory Control System.
- Material Requirement Processing.
- Hospital Management System.
- Railway Reservation System.
- Personal Information System.
- Web Based User Identification System.
- Timetable Management System.
- Hotel Management System 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-551H): Mapping with Virtual Lab
| Name of the Lab | Name of the Experiment |
| Database Management Lab( KCS-551) | 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 |
Ratings & Reviews
No reviews yet — share your experience with this item.