Scribd
Upload
128 views

Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi

The document outlines the syllabus for a course on Relational Database Management Systems. It includes 5 units that will cover database concepts, structured query language, functions and subqueries, PL/SQL, and forms and reports. Students will learn how to interpret database basics, utilize SQL queries, analyze PL/SQL concepts, evaluate interactive blocks and reports, and develop real-time applications. Course outcomes are mapped to program outcomes to indicate how the course contributes to different skills.

Uploaded by

Raja Ram
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
128 views

Ayya Nadar Janaki Ammal College (Autonomous), Sivakasi

The document outlines the syllabus for a course on Relational Database Management Systems. It includes 5 units that will cover database concepts, structured query language, functions and subqueries, PL/SQL, and forms and reports. Students will learn how to interpret database basics, utilize SQL queries, analyze PL/SQL concepts, evaluate interactive blocks and reports, and develop real-time applications. Course outcomes are mapped to program outcomes to indicate how the course contributes to different skills.

Uploaded by

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

AYYA NADAR JANAKI AMMAL COLLEGE (Autonomous), SIVAKASI

UNDER GRADUATE DEPARTMENT OF COMPUTER SCIENCE


B.Sc. Degree Course in Computer Science
PART - III SEMESTER - III CORE PAPER - VII
S3C07 RELATIONAL DATA BASE MANAGEMENT SYSTEMS
(For those admitted in June 2016 and later)
Contact hours per week: 05 Contact hours Per semester: 75

5 CREDITS
SYLLABUS
Course Outcomes
Upon Completion of the course the students will be able to
CO1: interpret the basics of database, SQL, PL/SQL, forms and reports
CO2: utilize tables and execute different SQL queries
CO3: analyze the various PL/SQL concepts
CO4: evaluate interactive PL/SQL blocks, forms and reports
CO5: develop real time database applications

CO- PO Mapping (Course Articulation Matrix)

PO
PO1 PO2 PO3 PO4 PO5 PO6 PO7
CO

CO1 3 3 3
CO2 9 3 9 3
CO3 3 3 9 3
CO4 9 9 9 3
CO5 3 3 9 9 9
Weightage 27 18 39 21 9
Weighted
percentage
of Course
contribution
to POs
CHOOSE THE BEST ANSWER 3
FILL IN THE BLANKS 3
STATE TRUE OR FALSE 2
MATCH THE FOLLOWING 2

UNIT - I DATABASE CONCEPTS


Database: Definition - definition of database management system - benefits of DBMS
- meaning of RDBMS - difference between DBMS and RDBMS. Normalization: First
normal form - second normal form - third normal form. Introduction to Oracle: Features of
SQL - features of SQL * plus- difference between SQL and SQL * plus- rules for sql- SQL
delimiters
(15 Hours)
UNIT - II STRUCTURED QUERY LANGUAGE
Interactive SQL: Table fundamentals – oracle data types- basic data types- create
table – inserting data into tables – viewing data in the tables-filtering table data – eliminating
duplicate rows – sorting data in a table – inserting data into a table from another table – delete
operations – updating the contents of a table - modifying the structure of tables – renaming
tables – truncating tables – destroying tables – creating synonyms – * dropping synonyms-
examining objects created by a user. Data Constraints: Types of constraints – primary key –
foreign key – unique key – business rule constraints – null value concepts – not null
constraints – check constraints
(15 Hours)

UNIT - III FUNCTIONS AND SUBQUERIES


Operators: Arithmetic operators – logical operators - range searching - pattern
matching. Oracle functions: Data conversion functions- date functions. Grouping data from
tables in SQL: Group by clause – sub queries – joins. Indexes: Creating index- simple index
– composite index – reverse key index – bitmap index – function based index – key
compressed index – multiple indexes on a table. Views: Creating a view – updateable view –
clusters – sequences.
(15 Hours)
UNIT - IV PL/SQL
Introduction to PL/SQL: PL/SQL block- advantages of PL/SQL – PL/SQL execution
environment – character set – literals – PL/SQL data types – variables – constants – LOB
types – logical comparisons – displaying a message – comments - control structure – oracle
transactions. Cursor: Types of cursor – implicit cursor – explicit cursor –cursor for loops –
parameterized cursors - cursor within cursors. Procedures and Functions: Creating a
procedure – creating a stored procedure – keywords and parameters - creating a function –
creating a packages – invoking a package – package objects – overloading procedures and
functions – benefits of overloading - Database triggers: Types of triggers – row triggers –
statement triggers – before and after trigger – combinations trigger- deleting a trigger.

(15 Hours)

UNIT - V FORMS AND REPORTS


Forms and reports: Creating data entry form – Master/ Details form – working with
menus – data model for a report – layout of a report – report interface - creating master/
detail report.

(15 Hours)
* SELF STUDY

TEXT BOOKS
1. Bayross I., 2014, “SQL, PL/SQL: The Programming Language of Oracle”, Fourth
Edition, BPB Publications, New Delhi. (pp. 1-12, 114-228, 254-278,338-375,404-437)
2. Bayross I., 2005, “Commercial Application Development using Oracle Developer 2000
Forms 6i”, Second Edition, BPB Publications, New Delhi (Chapters 7 – 9, 11,12).
RERERENCE BOOKS
1. Chatterjee, R.C., 2014, “Learning SQL and PL/SQL: A Simplified Guide”, Prentice Hall
India Private Ltd., New Delhi.
2. Feuerstein, S., 2007, “Oracle PL/SQL Best Practices”, Second Edition, O’Reilly Media,
Sebastopal.
3. Koletzke, P. and P. Dorsey., 1999, “Oracle Developer Advanced Forms and Reports”,
First Edition, Tata McGraw-Hill Publishing Company Ltd., New Delhi.
4. Loney, K., 2009, “Oracle Database 11g: The complete Reference”, Third Edition, Tata
McGraw-Hill Publishing Company Ltd., New Delhi.
5. Urman, S., 2006, “Oracle 9i PL/SQL Programming”, Twelfth Reprint, Tata McGraw-
Hill Publishing Company Ltd., New Delhi.

WEBLIOGRAPHY
1. www.tutorialspoint.com/listtutorials/oracle/1
2. plsql-tutorial.com/
3. www.oracle-dba-online.com/sql/oracle_sql_tutorial.htm
4. www.oracle.com/technetwork/tutorials
5. www.plsqltutorial.com/

You might also like