V SEMESTER
COURSE MAX. MARKS
CONTENT
COURSE NAME CREDITS
Ext. Int. Total
BCE-CSC09 - Computer Network@ 4 75 25 100
BCE-CSC10 - Operating System@ 5 75 25 100
BCE-CSC11 - Relational Database Management
4 75 25 100
PART III System@
BCE-CSC12 - Core Practical-V - Operating System
3 60 40 100
Lab@
BCE-CSC13 - Core Practical-VI - PL/SQL Lab@ 3 60 40 100
Elective I-Choose any one from the list 5 75 25 100
PART IV Value Education 2 75 25 100
Total Credits 26
VI SEMESTER
BCE-CSC14 - Software Engineering@ 4 75 25 100
BCE-CSC15 - Introduction to Data Science@ 5 75 25 100
BCE-DSC16 - Introduction to Cloud Computing 4 75 25 100
PART III
BCE-DSC17 - Core Practical-VII - CASE Tools
3 60 40 100
and Testing tools Lab
Elective II- Choose any one from the list 5 75 25 100
BCE-CSC18 - Core Practical-VIII - Mini Project@ 5 60 40 100
PART V Extension Activities 1
Total Credits 27
Total credits ( Core, Elective, SBS) 143
*NME: Choose Any one From the Other Department
Elective I
BCE-DSE1A Artificial Intelligence and Expert System
BCE-DSE1B Graphics and Visualization
BCE-DSE1C Network Security
Elective II
BCE-DSE2A Mobile Computing
BCE-CSE2B IOT and its Applications@
BCE-DSE2C Block Chain Technology
@ - Common subject to other course/s.
UNIVERSITY OF MADRAS
B.Sc. DEGREE COURSE IN COMPUTER SCIENCE
SYLLABUS WITH EFFECT FROM 2020-2021
BCE-CSC11
CORE-XI: RELATIONAL DATABASE MANAGEMENT SYSTEM
(Common paper to B.Sc.Software Applications & B.C.A.)
III YEAR / V SEM
OBJECTIVES:
Gain a good understanding of the architecture and functioning of Database Management Systems
Understand the use of Structured Query Language (SQL) and its syntax.
Apply Normalization techniques to normalize a database.
Understand the need of transaction processing and learn techniques for controlling the
consequences of concurrent data access.
OUTCOMES:
Describe basic concepts of database system
Design a Data model and Schemas in RDBMS
Competent in use of SQL
Analyze functional dependencies for designing robust Database
UNIT - I
Introduction to DBMS– Data and Information - Database – Database Management System – Objectives
- Advantages – Components - Architecture. ER Model: Building blocks of ER Diagram –
Relationship Degree – Classification – ER diagram to Tables – ISA relationship – Constraints –
Aggregation and Composition – Advantages
UNIT - II
Relational Model: CODD’s Rule- Relational Data Model - Key - Integrity – Relational Algebra
Operations – Advantages and limitations – Relational Calculus – Domain Relational Calculus -
QBE.
UNIT - III
Structure of Relational Database. Introduction to Relational Database Design - Objectives – Tools –
Redundancy and Data Anomaly – Functional Dependency - Normalization – 1NF – 2NF – 3NF –
BCNF. Transaction Processing – Database Security.
UNIT - IV
SQL: Commands – Data types – DDL - Selection, Projection, Join and Set Operations – Aggregate
Functions – DML – Modification - Truncation - Constraints – Subquery.
UNIT - V
PL/SQL: Structure - Elements – Operators Precedence – Control Structure – Iterative Control -
Cursors - Procedure - Function - Packages – Exceptional Handling - Triggers.
TEXT BOOK:
1. S. Sumathi, S. Esakkirajan, “Fundamentals of Relational Database Management System”,
Springer International Edition 2007.
UNIVERSITY OF MADRAS
B.Sc. DEGREE COURSE IN COMPUTER SCIENCE
SYLLABUS WITH EFFECT FROM 2020-2021
REFERENCE BOOKS:
1. Abraham Silberchatz, Henry F. Korth, S. Sudarshan, “Database System Concepts”, McGrawHill
2019, 7th Edition.
2. Alexis Leon & Mathews Leon, “Fundamentals of DBMS”, Vijay Nicole Publications 2014, 2nd
Edition.
WEB REFERENCES:
NPTEL & MOOC courses titled Relational Database Management Systems
https://nptel.ac.in/courses/106106093/
https://nptel.ac.in/courses/106106095/
NOVEMBER 2022 50437/SE25C
Time : Three hours Maximum : 75 marks
SECTION A — (10 2 = 20 marks)
Answer any TEN questions.
1. Define DBMS.
2. What is physical data independence?
3. Mention any two advantages of ER model.
4. What is Primary Key?
5. What is QBE?
6. Define normalization.
7. What is Transaction?
8. What is DDL?
9. Differentiate DROP TABLE and TRUNCATE
TABLE in SQL.
10. What is the use of JOIN operation?
11. What is Procedure in PL/SQL?
12. What is an exception?
SECTION B — (5 5 = 25 marks)
Answer any FIVE questions.
13. Explain the objectives of DBMS.
14. Explain the Classification of Entity Sets.
15. What are the types of relational calculus? Briefly
explain.
16. Describe the ACID properties of the DBMS.
17. Explain the need for database security.
18. What are sub queries? How will you classify them?
19. Explain the structure of PL/SQL.
SECTION C — (3 10 = 30 marks)
Answer any THREE questions.
20. Describe the five components of database systems.
21. Explain the various operations on relational
algebra.
22. Discuss the various objectives of database design.
23. Explain the data types in SQL with examples.
24. Explain the looping statements in PL/SQL.
————————
2 50437/SE25C
APRIL 2023 50437/SE25C
Time : Three hours Maximum : 75 marks
PART A — (10 × 2 = 20 marks)
Answer any TEN questions
1. Define: Primary Key?
2. State the use of DDL Compiler.
3. What is Relational Database.
4. Define: Relational Algebra
5. What is SQL?
6. Define: Normalization.
7. What is Integrity Constraints?
8. Write a note on Set Operations.
9. What is partial dependency?
10. Exapnd: DDL.
11. What is mean by DCL?
12. Define: Exception.
PART B — (5 5 = 25 marks)
Answer any FIVE questions
13. Write short note on Building blocks of ER
Diagram.
14. Explain the Mapping Constraints concept.
15. Describe the Structure of Relational Database.
16. Write short note on Tuple relational Calculus.
17. Summarize on Aggregate functions with examples.
18. Elaborate on Second Normal form with example.
19. Describe on Exception Handling in PL/SQL.
PART C — (3 10 = 30 marks)
Answer any THREE questions
20. Explain the purpose of Database Systems.
21. Write the codd’s rule for RDBMS.
22. Give an overview on the Nested Sub Queries.
23. Discuss on E-R Model, Query processor with
suitable example.
24. Write a trigger program to display the appropriate
message for inserting and deleting records in a
database table.
———————
2 50437/SE25C
NOVEMBER 2023 50437/SE25C/TC23A
Time : Three hours Maximum : 75 marks
PART A — (10 × 2 = 20 marks)
Answer any TEN questions.
1. What is the difference between data and
information?
2. What is Database?
3. Define entity with an example.
4. What is candidate key?
5. What is referential integrity?
6. What are ACID properties of the DBMS?
7. Define BCNF.
8. What is DML?
9. What are subqueries?
10. What is a Trigger?
11. What is function in PL/SQL?
12. What are Packages?
PART B — (5 × 5 = 25 marks)
Answer any FIVE questions.
13. What are the advantages of DBMS? Explain.
14. What are the building blocks of ER diagram?
15. What are the advantages of QBE? Briefly explain.
16. Describe the purpose of normalizing the data.
17. Give a brief account on Transaction processing.
18. Explain the set operations of SQL.
19. What is a cursor? Explain the steps to create a
cursor.
PART C — (3 × 10 = 30 marks)
Answer any THREE questions.
20. Explain the various classifications of database
architecture.
21. List and explain Codd’s rules for relational
database.
22. Explain the classification of database security.
23. Discuss the various aggregation functions
supported by SQL.
24. Explain the Exception Handling mechanism in
PL/SQL.
———————
2 50437/SE25C/TC23A
