[go: up one dir, main page]
Scribd
Upload
52 views2 pages

Rdbms

Uploaded by

Romela Preena
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
52 views2 pages

Rdbms

Uploaded by

Romela Preena
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 2

B. C. A. 2022-23 onwards - Affiliated Colleges - Annexure No.

28(a)(2)

Course code RDBMS & Oracle L T P C


Core/Elective/
Core : 8 0 4 6
Supportive 0
Basic knowledge about the data, table and Syllabus 2021-22
Pre-requisite
database in computers Version Onwards
Course Objectives:
The main objectives of this course are to:
1. The course describes the data, organizing the data in database, database administration.
2. To grasp the different issues involved in the design of a database system.
3. To study the physical and logical database designs and database modeling like relational,
Hierarchical, network models, database security, integrity and normalization.
4. It also gives introduction to SQL language to retrieve the data from the database with suitable
application development.
5. Provide strong foundation of database concepts and to introduce students to application
development in DBMS.

Expected Course Outcomes:


On the successful completion of the course, student will be able to:
1 Understand the basic concepts of Relational Data Model, Entity- K1-K2
Relationship Model and process of Normalization
2 Understand and construct database using Structured Query Language K1-K3
(SQL) in Oracle9i environment.
3 Learn basics of PL/SQL and develop programs using Cursors, K1-K4
Exceptions, Procedures and Functions.
4 Understand and use built-in functions and enhance the knowledge of K1-K3
handling multiple tables
5 Attain a good practical skill of managing and retrieving of data using K2-K4
Data Manipulation Language (DML)
K1 – Remember; K2 – Understand; K3 – Apply; K4 – Analyze; K5 – Evaluate; K6 – Create

Unit:1 DATABASE CONCEPTS 15 hours


Database Concepts: A Relational approach: Database – Relationships – DBMS – Relational Data
Model – Integrity Rules – Theoretical Relational Languages. Database Design: Data Modeling and
Normalization: Data Modeling – Dependency – Database Design – Normal forms – Dependency
Diagrams – De –normalization – Another Example of Normalization.

Unit:2 ORACLE9i 15 hours


Oracle9i: Overview: Personal Databases – Client/Server Databases – Oracle9i an introduction –
SQL *Plus Environment – SQL – Logging into SQL *Plus – SQL *Plus Commands – Errors &
Help – Alternate Text Editors – SQL *Plus Worksheet – iSQL *Plus. Oracle Tables: DDL:
Naming Rules and conventions – Data Types – Constraints – Creating Oracle Table – Displaying
Table Information – Altering an Existing Table – Dropping, Renaming, Truncating Table – Table
Types – Spooling – Error codes.

Unit:3 WORKING WITH TABLE 15 hours


Working with Table: Data Management and Retrieval: DML – adding a new Row/Record –
Customized Prompts – Updating and Deleting an Existing Rows/Records – retrieving Data from

Page 43 of 77
B. C. A. 2022-23 onwards - Affiliated Colleges - Annexure No.28(a)(2)

Table – Arithmetic Operations – restricting Data with WHERE clause – Sorting – Revisiting
Substitution Variables – DEFINE command – CASE structure. Functions and Grouping: Built-in
functions –Grouping Data. Multiple Tables: Joins and Set operations: Join – Set operations.

Unit:4 PL/SQL 15 hours


PL/SQL: A Programming Language: History – Fundamentals – Block Structure – Comments –
Data Types – Other Data Types – Declaration – Assignment operation – Bind variables –
Substitution Variables – Printing – Arithmetic Operators. Control Structures and Embedded SQL:
Control Structures – Nested Blocks – SQ L in PL/SQL – Data Manipulation – Transaction
Control statements. PL/SQL Cursors and Exceptions: Cursors – Implicit & Explicit Cursors and
Attributes – Cursor FOR loops – SELECT…FOR UPDATE – WHERE CURRENT OF clause –
Cursor with Parameters – Cursor Variables – Exceptions – Types of Exceptions.

Unit:5 PL/SQL COMPOSITE DATA TYPES 12 hours


PL/SQL Composite Data Types: Records – Tables – arrays. Named Blocks: Procedures –
Functions – Packages –Triggers –Data Dictionary Views.

Unit:6 Contemporary Issues 3 hours


Expert lectures, online seminars – webinars

Total Lecture hours 75 hours


Text Book(s)
1 Database Systems using Oracle, Nilesh Shah, 2nd edition, PHI.
2 E-Book : Diana Lorentz, “Oracle® Database SQL Reference”, ORACLE, Dec, 2005.
3 E-Book : Bill Pribyl, Steven Feuerstein, “Oracle PL/SQL Programming”, O’Reilly Media, Inc.,
6th Edition, February 2014.

Reference Books
1 Database Management Systems, Majumdar & Bhattacharya, 2007, TMH.
2 Database Management Systems, Gerald V. Post, 3rd edition, TMH.

Related Online Contents [MOOC, SWAYAM, NPTEL, Websites etc.]


1 http://www.digimat.in/nptel/courses/video/106105175/L01.html
2 https://www.tutorialspoint.com/oracle_sql/index.htm

Course Designed By:

Mapping with Programme Outcomes


Cos PO1 PO2 PO3 PO4 PO5 PO6 PO7 PO8 PO9 PO10
CO1 S S S M S M M M M L
CO2 S S S M S M M M M L
CO3 S S S S S S S S M M
CO4 S S S S S M S S M L
CO5 S S S S S M S S M L
*S-Strong; M-Medium; L-Low

Page 44 of 77

You might also like