b.c.a (bachelor of computer applications) third year- … · assembler: elements of assembly...

21
For Session 2019-20 BCA-III Board of Studies held on 17/07/19 B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- FIFTH SEMESTER EXAMINATIONS For Session 2019-20 Code Title of Paper Hours per Week L T P Semester Examination Internal Assessment Max. Marks Credit BCA-501 *Elective 4 1 0 75 25 100 4 BCA-502 *Foundation Course 4 1 0 75 25 100 4 BCA-503 Operating System 4 1 0 75 25 100 4 BCA-504 Software Engineering 4 1 0 75 25 100 4 BCA-505 Web Designing using ASP .NET 4 1 0 75 25 100 4 BCA-506 Software Lab IX(Based on BCA-501: Elective I) 0 0 5 50 - 50 2.5 BCA-507 Software Lab X (based on paper BCA-505: ASP .NET) 0 0 5 50 - 50 2.5 Total 475 125 600 25 *Elective I: Any one of the following papers: 1. BCA-501 E1 Relational Database Management System 2. BCA-501 E2 Multimedia **Foundation I: 1. BCA-502 F1 Artificial Intelligence 2. BCA-502 F2 System Software The breakup of marks for the continuous assessment for theory paper will be as under i Two tests will be conducted during the semester. Both the tests will be considered for assessment. : 60% of the marks allotted for continuous assessment ii Assignment / Presentations : 20% of the marks allotted for continuous assessment iii Attendance, Class participation & behaviour : 20% of the marks allotted for continuous assessment Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao Ms. Manpreet Kaur Mr.Joga Singh

Upload: others

Post on 24-May-2020

8 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- FIFTH SEMESTER EXAMINATIONS

For Session 2019-20

Code

Title of Paper

Hours

per

Week

L T P

Semester

Examination

Internal

Assessment

Max.

Marks

Credit

BCA-501 *Elective 4 1 0 75 25 100 4

BCA-502 *Foundation Course 4 1 0 75 25 100 4

BCA-503 Operating System 4 1 0 75 25 100 4

BCA-504 Software Engineering 4 1 0 75 25 100 4

BCA-505 Web Designing using ASP .NET 4 1 0 75 25 100 4

BCA-506 Software Lab – IX(Based on

BCA-501: Elective I)

0 0 5 50 - 50 2.5

BCA-507

Software Lab –X (based on

paper BCA-505: ASP .NET)

0 0 5 50 - 50 2.5

Total 475 125 600 25

*Elective I: Any one of the following papers:

1. BCA-501 E1 Relational Database Management System

2. BCA-501 E2 Multimedia

**Foundation I:

1. BCA-502 F1 Artificial Intelligence

2. BCA-502 F2 System Software

The breakup of marks for the continuous assessment for theory paper will be as under

i Two tests will be conducted during the semester.

Both the tests will be considered for assessment.

: 60% of the marks allotted for continuous

assessment

ii Assignment / Presentations : 20% of the marks allotted for continuous

assessment

iii Attendance, Class participation & behaviour : 20% of the marks allotted for continuous

assessment

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 2: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

BCA-501 E1 Relational Database Management System

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

1. To understand basic database concepts, including the structure and operation of the relational data model.

2. To construct simple and moderately advanced database queries using Structured Query Language (SQL).

3. It prepares the student to be in a position to use and design databases for different applications.

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

B) INSTRUCTIONS FOR THE CANDIDATES

1. Candidates are required to attempt two questions each from unit I and II and the entire unit III. 2. Use of Non-Programmable Scientific calculator is allowed.

UNIT-I

Introduction: The Relational Database Model, Components of Relational Model- Definition of Relational Database Management System, Features of RDBMS, CODD 12 rules for a fully RDBMS.

Product and their Features, Difference between DBMS and RDBMS, Relationship among application

programs and RDBMS.

Transaction Management: Transaction Concept, Properties, Transaction States, Concurrent Execution,

Serializability, Conflict Serializability, View Serializability, Recoverability, Recoverable Schedule,

Cascadless Schedule.

Concurrency Control: Lock Based Protocol, Locks, Granting of Locks, Two Phase Locking Protocol,

Timestamp Based Protocol, Timestamp, Timestamp ordering protocol, Thomas Write Rule, Validation

Based Protocol,

Recovery System: Failure Classification, Transaction Failure, System Crash, Disk Failure, Storage Structures, Storage Types, Data Access, Recovery & Atomicity, Log based Recovery, Deferred Database

Modification, Immediate Database Modification, Checkpoints, Recovery with Concurrent Transaction,

Transaction Rollback, Restart Recovery, Remote Backup System.

UNIT-II

Introduction to Oracle: Oracle as client/server architecture, getting started, creating, modifying,

dropping databases. Inserting, updating, deleting data from databases, SELECT statement, set operators,

managing and manipulating the data, Data constraints - Null values, Default values, primary, unique and foreign key concepts.

Working with SQL: Computing expressions, renaming columns, logical operators, range searching,

pattern matching, Oracle functions, grouping data from tables in SQL, manipulating dates. Triggers, use

of data base triggers, database triggers Vs. SQL* forms, types of triggers, how to apply database triggers, BEFORE vs. AFTER triggers, combinations, syntax for creating and dropping triggers.

Text Books: 1.Elmasry, Navathe, “Fundamentals of Database System”, Pearson Education. 2. Henry F. Korth, A Silberschhatz, “Database Concepts," Tata McGraw Hill.

Reference Books:

1. C.J. Date ," An Introduction to Database Systems”, Pearson Education. 2. Oracle SQL Complete Reference”, Tata McGrawHill.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 3: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

BCA-501 E2 Multimedia

Max Marks: 100 ` Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35%

Objectives of the Subject:

i. To provide students with a basic understanding of multimedia systems

ii. To demonstrate the use of animation, digitized sound, video control, and scanned images

iii. Describe and understand the technical details of JPEG and MPEG families .

UNIT-I

Multimedia: Introduction to multimedia, Components, Uses of multimedia.

Text: Fonts & Faces, Using Text in Multimedia, Font Editing & Design Tools, Hypermedia and

Hypertext. Images: Still Images– Bitmaps, Vector Drawing, 3D Drawing & rendering, Natural Light &

Colors, Computerized Colors, Color Palettes, Image File Formats. Sound: Digital Audio, MIDI Audio,

MIDI vs Digital Audio, Audio File Formats. Video: How Video Works, Analog Video, Digital Video,

Video File Formats, Video Shooting and Editing. Animation: Principle of Animations. Animation

Techniques, Animation File Formats.

Practical exercises based on concepts listed in theory using Flash.

UNIT-II

FLASH: Concept of Frame, Key frames, Frame rate, Timeline, Tween, Layers, Symbols, Embedding

audio/video and embedding on the web page. Draw an animation to show: a bouncing ball, a moving

stick man, a fainting banana, sunrise and sunset, a disappearing house, two boats sailing in river, LIP

SYN., show cartoon with a message.

1. Make a movie showing Shape Tweening.

2. Make a movie showing Motion Tweening.

3. Add sound and button to the movie.

The breakup of marks for the External Examination will be as under

i. Practical file Evolution 15 Marks

ii. Viva Voce 30 Marks

iii. Program Development and Execution 30 Marks

Text Books:

1. Tay Vaughan, “Multimedia: Making it work”, TMH, Eighth edition. 2006

2. Ralf Steinmetz and Klara Nahrstedt, “Multimedia: Computing, Communications Applications”,

Pearson,1995.

Reference Books:

1. Keyes, “Multimedia Handbook”, TMH. 2000.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 4: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

BCA-502 F1 Artificial Intelligence

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

i. To impart basic proficiency in representing difficult real life problems in a state space

representation so as to solve them using AI techniques like searching and game playing.

ii. To create an understanding of the basic issues of knowledge representation and Logic as well as

an understanding of other topics that play an important role in AI programs.

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

(B) INSTRUCTIONS FOR THE CANDIDATES

1. Candidates are required to attempt two questions each from unit I and II and the entire unit III.

2. Use of Non-Programmable Scientific calculator is allowed.

Unit I

Introduction to Artificial Intelligence: Concept and definition, importance of AI, History of AI, Turing

Test, AI related fields.

Problem solving using AI: Introduction: Defining problem as state space, analyzing problem, Finding the

solution, Representation of AI problem, Production system, Nature of AI Problems, Example if AI

Problems: Tic-Tac-Toe, Water-Jug problem, 8- Puzzle problem, 8-Queens problem, Chess problem.

Search Techniques: Breadth-first, Depth-first, Depth-limited, Bidirectional search.

Heuristic Search: Introduction, basic concept of heuristic search, concept of heuristic knowledge, types

of heuristic search techniques, popular games Playing Theories.

Unit-II

Introduction to knowledge: Introduction, Types of Knowledge, Knowledge representation, Knowledge

Storage, knowledge acquisition.

Logic: Introduction, propositional calculus, predicate Logic,resolution, unification, limitation of

logic,logic programming, matching, conflict resolution

Knowledge Representation Techniques: Introduction, Frames, Semantic Network,conceptual graph,

Conceptual Dependencies, Script, CYC, Object Oriented Representation.

Introduction to Expert System and Natural Language Processing.

Text Books:

I. Introduction to Artificial Intelligence and Expert Systems by Dan W. Patterson, Published by Pearson

Education, Inc

II. Artificial Intelligence By Ela Kumar, Published by IK International Publishing House PVT LTD

Page 5: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

Reference Books:

1. Introduction to artificial Intelligence by E. Charnaik and D. McDermott, Addison-Wesley Publishing

Company.

2. Principles of Artificial Intelligence by Nils J. Nilson, Narosa Publishing Co.

3. Expert Systems for Personal Computers by M. Chandwick and J.A. Hannah, Galgotia Publications Pvt.

Ltd.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 6: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

BCA-502 F2 System Software

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

i. Distinguish between Operating Systems software and Application Systems software.

ii. To learn context free grammars, compiler parsing techniques.

iii. To understand the theory and practice of compiler implementation.

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

(B) INSTRUCTIONS FOR THE CANDIDATES

Candidates are required to attempt two questions each from unit I and II and the entire unit III.

Unit I

Introduction: Definition of system software, types of system software, features of system programming,

system programming vs. application programming.

Language Processors: Introduction, Language processing activates, Fundamentals of Language

Processing. Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass

structure of Assemblers, Design of a two pass assembler. A brief overview of single pass assembly and

problem of forward references.

Linkers and Loaders: Definition of linker and loader Design of Absolute Loader, Re-locatable Loader.

Unit II

Compilers: Overview of Compilation Process, Scanning, Parsing (Top down and Bottom Up parsing),

Intermediate code forms (variant I and II) intermediate code form for arithmetic expressions (postfix,

prefix, triples, quadruples – concepts only), Code optimisation transformations (Compile time evaluation,

Elimination of common sub-expression, Dead code elimination, Frequency reduction, strength reduction –

concepts only), compiler vs. interpreter. Software Tools: Software tools for program development,

Editors, Debug monitors, Programming environments, User Interfaces.

Text Books:

1. Dhamdhere D. M. "Systems Programming and Operating system", Tata McGraw-Hill Publishing

Company Limited, New Delhi, Second Edition.

2. Donovan, "System programming". (McGraw-Hill), 1991.

Reference Book:

1. Aho and Ulman, "Principles of Compilers", Narosa Publishing House, 1986.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 7: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

BCA-503 Operating System

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

i. To learn the fundamentals of Operating Systems.

ii. To learn the mechanisms involved in memory management in contemporary OS

iii. To gain knowledge on distributed operating system concepts that includes architecture, Mutual

exclusion algorithms, deadlock detection algorithms and agreement protocols System Software.

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

(B) INSTRUCTIONS FOR THE CANDIDATES

1. Candidates are required to attempt two questions each from unit I and II and the entire unit III. 2. Use of Non-Programmable Scientific calculator is allowed.

Unit I

Operating System – Definition, Need, Services, Types of operating systems: simple batch system, multi

programmed batch system, time sharing system, parallel system, distributed system, real time system,

personal computer system. Operating system components, operating system services, system calls. Process

Management – process definition, process state, process scheduling, operations on processes, Basic

concepts of thread, Difference between process and thread.

CPU Scheduling – Basic concepts, scheduling criteria, scheduling algorithms – FCFS, SJF, Round Robin,

Priority and Multilevel queue scheduling.

Unit II

Deadlocks – Characteristics of deadlocks, methods for handling deadlocks, deadlock prevention, deadlock.

Avoidance. Memory Management – Logical versus Physical address space, swapping, contiguous

allocation, Paging, Concept of Virtual memory, Implementation by Demand Paging, Page replacement

algorithms – FIFO, Optimal, LRU, Concept of thrashing .

File Management – Allocation methods: contiguous allocation, linked allocation and indexed allocation;

Device Management – Disk Scheduling: FCFS, SSTF, SCAN, C-SCAN, LOOK.

Text Books:

1. Abraham Silberschatz, Peter B. Galvin, Operating Sytem Concepts, Addison –Wesley Publishing

Co. Engineering, Third Edition 2005 ,PankajJalote, Narosa Publications. 5th Edition.

2. Andrew S. Tanenbaum, “Modern Operating Systems”, Prentice Hall of India Pvt. Ltd.

3.

Reference Books:

1. William Stallings, “Operating System”, Prentice Hall of India.

2. Pramod Chandra P. Bhatt – “An Introduction to Operating Systems, Concepts and Practice, PHI.

3. Harvey M. Deitel, “Operating Systems”,Pearson Education Pvt. Ltd.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 8: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

BCA-504 Software Engineering

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

i. Knowledge of basic Software engineering methods and practices and their appropriate

application.

ii. Describe software engineering layered technology and Process frame work.

iii. A general understanding of software process models such as the waterfall and evolutionary

models.

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

(B) INSTRUCTIONS FOR THE CANDIDATES

Candidates are required to attempt two questions each from unit I and II and the entire unit III.

Unit I

Introduction: The Problem Domain, Software Engg. Challenges, Software Engg. Approach. Software

development life cycle, its phases, Software development process models :Waterfall, Prototyping,

Iterative; Software Process: Characteristics of software process, Project management process, Software

configuration management process. Project Planning – activities, COCOMO model. Software Metrics –

Definition, Importance, Categories of metrics. Software Quality – Attributes, Cyclomatic complexity

metric. Software Requirements Analysis – Need for SRS, Data flow diagrams, Data Dictionary, entity

relationship diagram, Characteristics and components of SRS, validation, metrics

Unit II

Software Design: Design principles, Module-level concepts, Structure Chart and Structured Design

methodology, verification, metrics : network metrics, information flow metrics. Coding : Programming

Principles and Guidelines, Verification- code inspections, static analysis. Software Testing: testing

fundamentals, Black Box Testing : Equivalence class partitioning, Boundary value analysis, cause-effect

graphing; White Box Testing : Control flow and Data flow based testing, mutation testing; levels of

testing, test plan, test case specification, test case execution and analysis,

Software maintenance: Categories of maintenance. Software Reliability – Definition, uses of reliability

studies.

Text Books:

1. An Integrated approach to Software Engineering, Third Edition ,Pankaj Jalote, Narosa Publications.

2. Software Engineering , Revised Second Edition , K.K. Aggarwal, Yogesh Singh, New Age

International Publishers.

Reference Book:

1. Software Engineering – A Practitioner’s Approach, Fifth Edition, Roger. S. Pressman, McGraw Hill

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 9: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

BCA-505 Web Designing Using ASP .Net

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

i. This course will provide students with the tools and techniques to build dynamic Web sites using

the ASP.Net programming environment.

ii. Develop a data driven web application.

iii. Understand the fundamentals of developing modular application by using object oriented

methodologies

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

(B) INSTRUCTIONS FOR THE CANDIDATES

Candidates are required to attempt two questions each from unit I and II and the entire unit III.

Unit I

Introduction: Introduction to Microsoft ASP.NET, .Net Framework, An overview of .NET including the

Common Language Interface, the Common Type System, the Common Language Runtime, and .NET

class libraries. Language and platform neutrality. An introduction to Web Forms, The ASP.NET

execution model.

ASP.NET Web Application User Interface: Creating an ASP.NET Web application user interface with

various controls, creating and using Master page, Implementing event handlers by using code-behind

files, Explain user input by using validation controls.

Unit II

Managing State: The Various Means to Manage State, Request object, Application object, Cache object,

Session object, Server-side state management, Using session for server-side and client-side state

management.

XML Web Services: Need of XML Web services, Understanding the Web Service Model, Creating an

ASP.NET Web Service. Implementing Navigation for the User Interface: Round Trip and Post back, State

Management for user navigation, Navigation between Pages.

Storing and Retrieving Data with ADO.NET: ADO.NET Overview, Connecting to Data, Executing

SQL with Commands, Accessing Data with ADO.NET, Fast Data Access with DataReaders, DataSet

Basics, Filling DataSets with DataAdapters.

Data Binding: Bind Data to the UI, Transform and Filter Data.

Security: Authenticating and Authorizing Users, Using Windows Authentication, Using Forms

Authentication. Using Caching Page: Output Caching, User Control Caching, Data Caching

Text Books:

1. Matthew MacDonald: ASP.NET: The Complete Reference, Osborne.

2. Jesse Liberty, Dan Hurwitz: Programming ASP.NET, OReilly.

Reference Books:

1. Stephen Walther: ASP.NET 3.5 Unleashed, SAMS.

2. Infosys Campus Connect Foundation Program Volume:1 – 3, Education & Research Department,

Infosys Technologies Ltd , Bangalore.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 10: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/19

BCA-506 Software Lab – IX(Based on BCA-501: Elective I)

Max Marks: 50 Maximum Time: 3 Hrs.

External Examination: 50 Min Pass Marks: 35%

Lectures to be delivered: 45-55 Hrs.

Objectives of the Lab:

1.This practical will enable students to retrieve data from relational databases using SQL. 2. Students will also learn about triggers, cursors, stored procedures etc. Syllabus Contents:

1. Introduction to SQL and installation of SQL Server / Oracle.

2. Data Types, Creating Tables, Retrieval of Rows using Select Statement, Conditional Retrieval of Rows, Alter and Drop Statements.

3. Working with Null Values, Matching a Pattern from a Table, Ordering the Result of a Query, Aggregate Functions, Grouping the Result of a Query, Update and Delete Statements.

4. Set Operators, Nested Queries, Joins, Sequences.

5. Views, Indexes, Database Security and Privileges: Grant and Revoke Commands, Commit and Rollback Commands.

6. PL/SQL Architecture, Assignments and Expressions, Writing PL/SQL Code, Referencing Non-SQL parameters.

7. Stored Procedures and Exception Handling.

8.Triggers and Cursor Management in PL/SQL.

The breakup of marks for the practical will be as under

i. Lab File Record (External Assessment) 10 Marks

ii. Viva Voce (External Evaluation) 20 Marks

iii. Program Development and Execution(External

Evaluation)

20 Marks

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 11: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 11

BCA-507 Software Lab – IX (Based on paper BCA-505: ASP.Net)

Maximum Marks: 50 Maximum Time: 3 Hrs.

External Examination: 50 Minimum Pass Marks: 35%

Lectures to be delivered: 45-55 hrs

Objectives of the Lab:

i. To design web applications using ASP.NET

ii. To use ASP.NET controls in web applications.

iii. To debug and deploy ASP.NET web applications

This laboratory course will comprise as exercises to implement what is learnt under paper BCA-505

ASP.Net.

The breakup of marks for the practical will be as under

i. Lab File Record (External Assessment) 10 Marks

ii. Viva Voce (External Evaluation) 20 Marks

iii. Program Development and Execution(External

Evaluation)

20 Marks

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 12: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 12

B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- SIXTH SEMESTER EXAMINATIONS

For the Session 2019-20

Code

Title of Paper

Hours

per

Week

L T P

Semester

Examination

Internal

Assessment

Max.

Marks

Credit

BCA-601 *Elective -I 4 1 0 75 25 100 4

BCA-602 *Foundation Course 4 1 0 75 25 100 4

BCA-603 Computer Graphics 4 1 0 75 25 100 4

BCA-604 Web Development using PHP 4 1 0 75 25 100 4

BCA-605 Project 4 1 0 75 25 100 4

BCA-606 Software Lab – X (Based on - 603)

0 0 5 50 - 50 2.5

BCA-607

Software Lab – XI (based on

paper BCA-604: PHP)

0 0 5 50 - 50 2.5

Total 475 125 600 25

*Elective I: Any one of the following papers:

1. BCA-601 E1 Writing Skills & Personality Development

2. BCA-601 E2 System Analysis and Design

**Foundation I:

1. BCA-602 F1 Content Management System

2. BCA-602 F2 Date Warehouse

The breakup of marks for the continuous assessment for theory paper will be as under

i Two tests will be conducted during the semester.

Both the tests will be considered for assessment.

: 60% of the marks allotted for continuous

assessment

ii Assignment / Presentations : 20% of the marks allotted for continuous

assessment

iii Attendance, Class participation & behaviour : 20% of the marks allotted for continuous

assessment

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 13: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 13

BCA-601 E1 Writing Skills & Personality Development

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25 Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

1. To meet the specific needs of our clients depending on their personal/organizational requirements.

2. To enhance the writing skills.

Page 14: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 14

BCA-601 E2 System Analysis and Design

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25 Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

i. To introduce the overview of System Analysis & design.

ii. To clear various business system concepts

iii. To study the various system models.

UNIT-I

Systems concepts: Definition and characteristics of a system, Elements of a system, Types of systems.

The system development life cycle: Introduction to various phases.

The role of the Systems Analyst: Qualifications of a systems analyst, various roles of the systems

analyst. Systems analysis: Initial investigation, needs identification, determining the user’s information

requirements, Information-gathering tools.

Structured analysis tools: Data flow diagram, Data dictionary, Decision tree, Structured English,

Decision tables.

Feasibility study: Feasibility considerations, Steps in Feasibility analysis.

UNIT-II

Systems Design: The process and stages of systems design, Input/output and forms design, Database

design.

Implementation and software maintenance: Conversion, Post implementation review.

Software maintenance: maintenance or enhancement, Primary activities of a maintenance procedure.

Hardware and software selection: Procedure and major phases in selection.

Text Books:

1. E. M. Awad: Systems Analysis and Design, Galgotia Publications (P) Ltd

2. Kenneth E. Kendall, Systems Analysis and Design ,Pearson , 9th Edition .

Reference Books:

1. Alan Dennis, Systems Analysis and Design: An Object-Oriented Approach with UML ,5th Edition

,Wiley

2. Kenneth Kendall, Julie Kendall, Systems Analysis and Design, Global Edition, Pearson Education.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 15: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 15

BCA-602 F2 Data Warehouse

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject: The objective of this course is to get students familiar with the data mining

techniques, software and tools being used in Industries.

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

(B) INSTRUCTIONS FOR THE CANDIDATES

Candidates are required to attempt two questions each from unit I and II and the entire unit III.

UNIT-I Introduction to Data Warehousing, Need of Data Warehousing, Operational Data Stores, Data Warehouse

Characteristics, Data Warehouse role, Cost of warehousing data. Introduction to Online Analytical

Processing, OLAP Operations, Categorization of OLAP Tools.

Building a Data Warehouse, Data Warehouse Design, Data Pre-processing steps, Data Summarization,

Data Transformation, Concept Hierarchy, Structure, Patterns & Models Multidimensional Data Model,

Data Mart, Schemas for Multidimensional Data Model (Star Schema, Snowflake Schema, Fact

Constellation), DataWarehouse Architecture, , OLAP Three-tier Architecture.

UNIT-II

Introduction to Data Mining and Knowledge Discovery, Data Mining Primitives, Languages : Data

Cleaning, Data Integration and Transformation, Data Reduction, Discretization and concept of Hierarchy

Generation, Classification of Data Mining Systems, Overview of Data Mining Techniques, Classification

and Prediction, Overview of Cluster Analysis and Outlier Analysis.

Text Books:

1.DataWarehousing, DataMining, andOLAP, AlexBerson, First Edition,Tata McGraw Hill

2. Data Mining Concepts & Techniques, JiaweiHan &Micheline Kamber ,Second Edition, Morgan

Kaufmann Publishers.

Reference Books:

1. Data Warehousing, Mining & Visualization Core Concepts,George M Marakas, First Edition, Pearson

Education

2. Data Warehousing, Architecture & Implementation,Hawkin, Prentice Hall

3. Data Mining: Modelling Data for Marketing, Risk and Customer Relationship Mgmt

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 16: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 16

BCA-602 F1 Content Management System

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

i. To understand the different issues involved in the design and implementation of a database system.

ii. To study the physical and logical database designs, database modeling, relational, hierarchical,

and network models iii. To understand and use data manipulation language to query, update, and manage a database.

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

(B) INSTRUCTIONS FOR THE CANDIDATES

Candidates are required to attempt two questions each from unit I and II and the entire unit III.

UNIT-I Open Source vs Closed Source, Examples of OSS. What is Joomla? Features of Joomla Understanding WAMP Installing & Configuring Joomla: Installing WampServer ,Creating a Website Folder , Copy the Joomla Files ,Configuring the Joomla Web Installer Understanding The Frontend and Backend of Joomla, Login as a Super User . The Joomla Control Panel Creating Content: Creating Categories, Creating Categorised or Uncategorised Articles, Inserting Images/Graphics Into Articles, Inserting the Read More Option into Articles, Filtering & Sorting Articles, Featuring Articles on the Home Page, Viewing Your Website, Setting the Options for Articles.

Adding Menu Items: Adding a Single Article Menu Item, Adding a List All Categories Menu Item,

Changing the Layout From Blog Layout, Adding a Category List Menu Item , Changing the Menu Order.

UNIT-II

Joomla Extension Types: What is a Component? What is a Module? What is a Plugin? What is a

Template? What is Language? Adding Modules: Enabling Module Position Viewing, Viewing the

Module Positions, Changing Module Positions, Logging in From the Frontend to Edit Content, Adding

the Search Module. Creating an HTML Module Joomla Templates: Viewing Joomla Templates, Types of Templates, Default

Joomla Templates, Changing the Default Template for a Website, Previewing a Joomla Template,

Installing a Template, Changing the Logo/Header, Installing a Photo Gallery Component Creating Folders for the Photos Uploading the Photos, Adding a

Gallery Menu Item About Akeeba Backup Installing, Akeeba Backup Configuring Akeeba Backup

Creating a Backup, Copy of Your Website, Downloading Your Backup Archives

Text Book: 1..Jennifer Marriott and Elin Waring, The Official Joomla! Book Addison-Wesley Professional, 2010. Reference Books: 1. Ric Shreves, Joomla! Bible Steven M. Schafer, HTML, CSS, JavaScript, Perl, Python and PHP, Wiley India.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 17: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 17

BCA-603 Computer Graphics

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

i. This course will introduce students to all aspects of computer graphics including hardware,

software and applications.

ii. It will help students to apply graphics programming techniques to design, and create computer graphics.

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

(B) INSTRUCTIONS FOR THE CANDIDATES

Candidates are required to attempt two questions each from unit I and II and the entire unit III.

UNIT-I Functioning of Input devices: Keyboard, Touch panel, Light pens, Graphic tablets, Joysticks, Data

glove, Image scanner, Mouse.

Functioning of Output devices: Impact and non impact printers, such as line printer, dot matrix, laser,

ink-jet, electrostatic, flatbed and drum plotters.

Functioning of Video Display Devices: Refresh cathode ray tube, raster scan displays, random scan

displays, color CRT monitors, DVST, flat-panel displays, virtual reality, raster scan systems, Frame

buffer and video controller. Scan conversion algorithms for line, circle and ellipse, Bresenham’s

algorithms, area filling techniques.

UNIT-II

2-d Graphics: 2-dimensional Geometric transformations(translation, Scaling, Rotation, Reflection,

Shearing), Viewing transformation, 2D clipping algorithms (Cohen Sutherland and Liang Barsky’s line

clipping algorithms), polygon and text clipping. 3-dimensional Graphics: Geometric transformations (translation, Scaling, Rotation, Reflection,

Shearing),Composite transformations, Mathematics of Projections (parallel & perspective),3-D viewing

transformations and clipping.

Text Books:

1. D. Hearn and M.P. Baker, “Computer Graphics”, PHI New Delhi; Second Edition.

2. J.D. Foley, A.V. Dam, S.K. Feiner, J.F. Hughes,. R.L Phillips, ”Introduction to Computer Graphics”,

Addison-Wesley Publishing company, N.Y.; Second Edition.

Reference Book:

1. R.A. Plastock and G. Kalley, “Computer Graphics”, McGraw Hill.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 18: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 18

BCA-604 Web Development Using PHP

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 75 Internal Assessment: 25

Min Pass Marks: 35% Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

i.Gain the PHP Programming skills needed to successfully build interactive, data driven sites.

ii.Use THE MVC Pattern to organize code

iii. Test and debug a PHP application

(A) INSTRUCTION FOR THE PAPER SETTER

The question paper will consist of three units I, II and III. Each of units I and II will have four questions

from the respective sections of the syllabus and each question carry 12 marks. Unit-III will have 9 short

answer type questions which will cover the entire syllabus uniformly and will carry 3 marks in all.

(B) INSTRUCTIONS FOR THE CANDIDATES

Candidates are required to attempt two questions each from unit I and II and the entire unit III.

UNIT-I

Introduction to Web Technology: Introduction to WebPages, Introduction to Web Applications,

Introduction to Websites, Client Server Architecture, Introduction to Web Languages, Difference between

Client Side and Server Side Scripting languages. Introduction of PHP, use of PHP, difference b/w php4

and php5, Output – (echo, print , print , print_r)

Control Structures : (for, for each, switch,require,include,require_once,include_once)

Classes and Objects: (Class Constants, Constructors and Destructors, Operators in php –( Arithmetic

Operators, Assignment Operators, Comparison Operators, Incrementing/Decrementing Operators, Logical

Operators, Type Operators), Session, Cookies, Sending data using Get & Post methods.

UNIT-II

Database connectivity with PHP: Fetching data from database in PHP. Ajax: Introduction of Ajax.

States of Ajax. Ajax Variables( Google Chrome, Firefox, internet explorer)Response text, inner HTML

property. Introduction of phpMyAdmin(Mysql), Connection – (mysql_connect, mysql_select_db). Queries: (mysql_query, mysql_fetch_array , mysql_fetch_assoc ,mysql_fetch_row ,mysql_fetch _object,

mysql_insert_id(). Database queries: (insert, select, update, delete and if condition in mysql query).

Insert Images, Audios in database.

Text Books:

1. PHP and MYSQL web development (4th Edition).

2. PHP4: A Beginner’s Guide by Bill McCarty.

Reference Books:

1. PHP in action.1. PHP and MYSQL web development

2. PHP for Beginners by Ivan Bross.

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Page 19: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 19

Ms. Manpreet Kaur Mr.Joga Singh

BCA-605 Project

Max Marks: 100 Maximum Time: 3 Hrs.

External Examination: 100 Min Pass Marks: 35%

Lectures to be delivered: 45-55 Hrs.

Objectives of the Subject:

a. 1. To introduce the skills of dissertation writing.

2. To provides a concrete description of the project’s effect at the outcome level.

3. It was developed in a participatory process.

4. It is accepted by the target group.

b. Project Marks Distribution

CODE TITLE OF PAPER MAXIMUM MARKS

B.C.A-605 Project 100

Total 100

1. The evaluation committee will distribute these marks for seminar/viva/project report and for any other

activity, which the committee thinks to be proper.

2. Joint projects will be allowed and individual project reports will be accepted. Individual project reports

will be recognized and the students should highlight their contributions in a joint project report.

Committee for Evaluation of project report/work:

i. Head of the Department

ii. Internal Guide (if any)

iii. External Examiner

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 20: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 20

BCA-606 Software Lab – X (Based on BCA-603 Computer Graphics)

Maximum Marks: 50 Maximum Time: 3 Hrs.

University Examination: 50 Minimum Pass Marks: 35%

Lectures to be delivered: 45-55

Objective of the Lab:

i. To introduce the students with of the components of a graphics system and become familiar with building approach of graphics system components and algorithms related with them.

ii. Provide an understanding of how to scan convert the basic geometrical primitives, how to transform the shapes to fit them as per the picture definition.

iii. Provide an understanding of mapping from a world coordinates to device coordinates, clipping, and projections.

iv. To implement various algorithms to scan, convert the basic geometrical primitives, transformations, Area filling, clipping.

v. To describe the importance of viewing and projections.

This laboratory course will comprise as exercises to supplement what is learnt under paper

Based on – 603(Computer Graphics)

The breakup of marks for the practical will be as under

i. Lab Record (Internal Assessment) 10 Marks

ii. Viva Voce (External Evaluation) 20 Marks

iii. Program Development and Execution(External

Evaluation)

20 Marks

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh

Page 21: B.C.A (BACHELOR OF COMPUTER APPLICATIONS) THIRD YEAR- … · Assembler: Elements of Assembly Language Processing, A simple Assembly scheme, Pass structure of Assemblers, Design of

For Session 2019-20 BCA-III

Board of Studies held on 17/07/2019 21

BCA-607 Software Lab – XI (Based on paper BCA-604: PHP)

Maximum Marks: 50 Maximum Time: 3 Hrs.

University Examination: 50 Minimum Pass Marks: 35%

Lectures to be delivered: 45-55

Objectives of the Lab:

i. Test and debug a PHP application

ii. Use cookies and sessions

iii. Work with regular expressions, handle exceptions and validate data.

This laboratory course will comprise as exercises to implement what is learnt under paper BCA-604

(PHP)

The breakup of marks for the practical will be as under

i. Lab Record (Internal Assessment) 10 Marks

ii. Viva Voce (External Evaluation) 20 Marks

iii. Program Development and Execution(External

Evaluation)

20 Marks

Dr. Harjeet Singh Dr. Neeraj Sharma Dr.Rajesh Bhatia Prof.Harmohan Sharma

Mr. Chitresh Goyal Mr. Mandeep Singh Ms.Rashmi Arora Dr. Navdeep Singh

Mr. Devinder Singh Mr.Mukesh Kumar Ms. HarsimratDeo Ms. RituWalia

Ms. Devinder Kaur Ms. Taranpreet Kaur Dr. Sangeeta Joshi Mr. Birinder Singh Sarao

Ms. Manpreet Kaur Mr.Joga Singh