BCA
BCA
-
BCA-NEP-Examination-Scheme 1/1
-
Semester-1 8/8
-
Lecture 2.1B23-CAP-101 Problem Solving through CPreview
-
Lecture 2.2B23-CAP-102 Foundations of Computer SciencePreview
-
Lecture 2.3B23-CAP-103 Logical Organization of ComputerPreview
-
Lecture 2.4B23-CAP-104 Mathematical Foundations for Computer Science-IPreview
-
Lecture 2.5B23-BBA-MDC-102 Social Media MarketingPreview
-
Lecture 2.6B23-AEC-111 English Language and Communication Skills: Level 1Preview
-
Lecture 2.7B23-SEC-101 Office and spreadsheet Tools LearningPreview
-
Lecture 2.8B- VAC 101 Human Values and EthicsPreview
-
-
Semester-2 8/8
-
Lecture 3.1B23-CAP-201 Object Oriented Programming using C++Preview
-
Lecture 3.2B23-CAP-202 Introduction to Web TechnologiesPreview
-
Lecture 3.3B23-CAP-203 Concepts of Operating SystemsPreview
-
Lecture 3.4B23-CAP-204 Mathematical Foundations for Computer Science-IIPreview
-
Lecture 3.5B23-BBA-MDC-204 Entrepreneurship & Start-upsPreview
-
Lecture 3.6B23-SEC-207 Soft SkillsPreview
-
Lecture 3.7B23-VAC-201 Environmental StudiesPreview
-
Lecture 3.8B23-AEC-211 English Language and Communication Skills: Level 2Preview
-
-
Semester-3 7/7
-
Lecture 4.1B23-CAP-301 Java OOP FoundationsPreview
-
Lecture 4.2B23-CAP-302 Linux and Shell ProgrammingPreview
-
Lecture 4.3B23-CAP-303 Data Base TechnologiesPreview
-
Lecture 4.4B23-CAP-304 Basics of Data Science using ExcelPreview
-
Lecture 4.5B23-SEC-310 Communication in Professional LifePreview
-
Lecture 4.6B23-AEC-311 English Language and Communication Skills: Level 3Preview
-
Lecture 4.7B23-BBA-MDC-302 Fundamentals of InvestingPreview
-
-
Semester-4 4/4
-
Semester-5 3/3
-
Semester-6 6/6
BCA-NEP Semester-6 syllabus uploaded soon. This is the old syllabus of BCA.
-
Lecture 7.1BCA-361: Web Designing Using Advanced ToolsPreview
-
Lecture 7.2BCA-362: Operating System-IIPreview
-
Lecture 7.3BCA-363: Computer GraphicsPreview
-
Lecture 7.4BCA-364: Internet TechnologiesPreview
-
Lecture 7.5BCA-365: Advanced Programming with Visual BasicPreview
-
Lecture 7.6BCA-366: Programming in Core JavaPreview
-
BCA – 244 RELATIONAL DATABASE MANAGEMENT SYSTEM
| Maximum Marks: 100 | External: 80 |
| Internal: 20 | |
| Minimum Pass Marks: 35 | |
| Time: 3 hours |
Note: Examiner will be required to set Nine Questions in all. First Question will be compulsory, consisting of objective type/short-answer type questions covering the entire syllabus. In addition to that eight more questions will be set, two questions from each Unit. A candidate will be required to answer five questions in all, selecting one question from each unit in addition to compulsory Question No. 1. All questions will carry equal marks.
UNIT – I
Relational Model Concepts, Codd’s Rules for Relational Model, Relational Algebra:-Selection and Projection, Set Operation, Renaming, Join and Division, Relational Calculus: Tuple Relational Calculus and Domain Relational Calculus.
UNIT – II
Functional Dependencies and Normalization:-Purpose, Data Redundancy and Update Anomalies, Functional Dependencies:-Full Functional Dependencies and Transitive Functional Dependencies, Characteristics of Functional Dependencies, Decomposition and Normal Forms (1NF, 2NF, 3NF & BCNF).
UNIT – III
SQL: Data Definition and data types, SQL Operators, Specifying Constraints in SQL, Basic DDL, DML and DCL commands in SQL, Simple Queries, Nested Queries, Tables, Views, Indexes, Aggregate Functions, Clauses
UNIT – IV
PL/SQL architecture, PL/SQL and SQL*Plus, PL/SQL Basics, Advantages of PL/SQL, The Generic PL/SQL Block: PL/SQL Execution Environment, PL/SQL Character set and Data Types, Control Structure in PL/SQL, Cursors in PL/SQL, Triggers in PL/SQL, Programming using PL/SQL.
TEXT BOOKS:
- Elmasri & Navathe, “Fundamentals of Database Systems”, 5th edition, Pearson Education.
- Ivan Bayross, “SQL, PL/SQL-The Programming Language of ORACLE”, BPB Publications 3rd
REFERENCE BOOKS:
- J. Date, “An Introduction to Database Systems”, 8th edition, Addison Wesley N. Delhi.
- Oracle 8 –PL/SQL programming –Scott Urman
- A Guide to the SQL Standard, Data,C. and Darwen, H.3rd Edition, Reading, MA:1994, Addison-Wesley Publications, New Delhi.
