BCA Semester 5 2019
BCA Semester 5 2019
BCA Semester 5 2019
1
Index
Course Name of the Course Page
Code No.
CC301 Web Applications Development – I 3
Using C#
CC302 Python Programming 9
CC303 Computer Networks 12
CC304 Web Application Development – I 15
Using C# Practical
CC305 Python Programming Practicals 23
CC306 Software Development Project – I 28
SEC301(A) Software Project Management 31
SEC301(B) Information Security 34
SEC301(C) Mobile Applications Development 37
FC301(A) Operation Research 40
FC301(B) Management Information System 42
FC301(C) Computer Graphics 46
2
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE CREDIT 3
INTRODUCTION TO ASP.NET 10
Introduction to .NET Platform and Web
Introduction to ASP (Server-side Technology)
.NET Framework (FCL and CLR)
Overview of IIS
Processing of ASP.NET page (Execution model)
Features of .NET IDE
1 Features of ASP.NET
Working with ASP.NET
Coding Model (Inline and Code-behind)
Introduction to Web-Forms and its Events
ASP.NET Built-in directory structure
App_data
App_code
Bin
3
Application Configuration
Global.asax file
Web.config
Common properties
AccessKey
BackColor
BorderWidth
BorderStyle
CSSClass
Enabled
Font (Bold, Italic, Name, Overline, Size, Strikeout,
Underline etc)
ForeColor
Height
TabIndex
Tooltip
Width
ID
Runat
Text
Label
EnableViewState
AssociatedControlID
TextBox
AutoCompleteType
AutoPostBack
Columns
MaxLength
ReadOnly
TextMode
Literal
Mode
Panel
Use of Panel
Adding controls at runtime in panel
INFORMATION PASSING AND STANDARD CONTROLS 10
Passing Information from one page to another
Previouspage. FindControl Method
QueryString
Cookies
Session variables
2 Application variables
HttpRequest and HttpResponse Objects
Web server controls Button, Image Button, Link Button
PostBackUrl
ImageUrl (Image Button)
AlternateText (Image Button)
Events:OnClick, OnClientClick
4
Hyperlink
NavigateUrl
Target
ImageMap control (Creating Hotspots)
CheckBox and RadioButton
Properties
AutoPostBack
Text
TextAlign
Checked
6
GroupName (RadioButton)
Event
OnCheckedChange
CheckBoxList, RadioButtonList
Properties
AutoPostBack
DataSource
RepeateColumns
RepeateDirection
TextAlign
Items
SelectedIndex
SelectedItem
SelectedItems
Event
OnSelectedIndexChanged
ListBox, DropdownList
Properties
AutoPostBack
DataSource
Items
SelectionMode (ListBox)
Event
OnSelectedIndexChanged
Rich Controls:
Calendar
Properties
NextMonthText
PrevMonthText
SelectedDate
SelectedDates
4
SelectionMode
Event
DayRender
Adrotator control (showing advertisement from XML file and
Database)
FileUpload control
3 Master page, Navigation, Validation, Login controls 10
5
Designing Master page
Using Navigation Controls
TreeView
SiteMapPath
Menu
Creating sitemap file for navigation
Validation controls 5
Required Field Validator
Range validator
Regular Expression validator
Compare validator
Custom validator
Validation summary
Login Controls
Login
LoginView
PasswordRecovery
LoginStatus
LoginName 5
CreateUserWizard
ChangePassword
Creating and Managing Roles
Creating and Managing Access Rules
Creating and Managing Profile
Authentication, Authorization and Data controls 10
Membership class
Methods
CreateUser
DeleteUser
FindUserByName and FindUserByEmail
GeneratePassword
GetAllUsers
GetUser
Role class
Methods
AddUsresToRole
4 AddUserToRole
CreateRole
DeleteRole
FindUserInRole
GetUsersInRole
IsUserInRole
RemoveUserFromRole(s)
ProfileManager class
Methods
DeleteInactiveProfiles
DeleteProfile
DeleteProfiles
FindProfileByUserName
6
GetAllProfiles
GetNumberofProfile
Data controls
GridView
DataList
FormView
DetailsView
Repeater
ADO.NET
Connection
Properties
ConnectionString
State
Methods
Open
Close
Command
Properties
CommandText
Connection
Methods
ExecuteNonQuery
ExecuteReader
ExecuteScalar
DataReader
Property
Items
Method
Read
DataAdapter
Properties
SelectCommand
InsertCommand
UpdateCommand
DeleteCommand
Methods
Fill
Update
DataSet
CommandBuilder
TEXT BOOK/S:
1. Professional ASP.NET 3.5 (Sp1) In C# and VB by Bill Evjen, Scot
Hanselman and David Rader (Wrox)
REFERENCE BOOKS:
1. ASP.NET 4 UNLEASED by Stephen Walther (Pearson)
7
WEB RESOURCES:
REQUIRED SOFTWARE/S
8
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE TITLE
CC302 Python Programming
COURSE CODE CC-302
COURSE CREDIT 3
SESSIONS PER WEEK 4
TOTAL TEACHING HOURS 40 HOURS
AIM
This course introduces students the fundamentals of core python programming
language and to use it for different applications development.
LEARNING OUTCOMES
On the completion of the course students will:
1. To recognize why python is extensively used by developers in the industry.
2. To study and employ different datatypes, operators, I/O and control
statements.
3. To define & implement class and different levels of inheritance.
4. To learn creating modules and data structures like List, Tuples and
Dictionaries
5. To handle exceptions and work with the built in standard libraries.
6. To create a virtual environment.
7. To implement python database connectivity.
DETAIL SYLLABUS
UNIT TOPIC/SUB TOPIC TEACHING
HOURS
Beginning with Python, Datatypes, Operators, I/O and 10
Control statements
Introduction to Python
Python, Features of Python, Viewing of Byte Code, Flavours
of Python, PVM, Memory Management in Python, Garbage 3
collection in python, Comparisons between C-Java-Python,
Writing first Python program, Execution of a Python program
1 (using command line, IDLE window and system prompt).
Datatypes in Python
Built-in datatypes, None types, Numeric types, Explicit
conversion of datatypes, Sequences in Python, str, bytes, 4
bytearray, List, Tuple, range, Sets, set datatype, frozenset,
mapping types, Determining the datatype of a variable,
Identifiers and reserved words, Naming conventions in
Python.
Operators, I/O and control statements
Membership operators, Identity operators, Output
statements, Input statements, Command line arguments, A 3
word on Indentation, The if-elif-else statement, Infinite loops,
Nested Loops, The else Suite, break, continue, pass, assert
and return statements.
9
Modules, Arrays, Functions, List, Tuples and 10
Dictionaries
Modules, Arrays and Functions
Creating our own modules in python, Advantages of Array,
2 Creating an Array, Importing the array module, Indexing-
Slicing and Processing the arrays, Difference between a 4
function and a method, Defining-calling and returning(single
and multiple) results from a function, Pass by Object
Reference, Positional arguments, Keyword arguments,
Default arguments, Variable length arguments, Anonymous
Functions, Function Decorators.
List and Tuples
Exploring List, Creating lists using range() function, Updating 4
the elements of the list, Concatenation of two lists, Repetition
of lists, Membership in lists, Aliasing and Cloning lists,
Methods to process List, Nested Lists, Tuples, Creating and
accessing Tuple elements, Basic operations on Tuples,
Functions to process tuples, Nested Tuples and its sorting.
Dictionaries
Introduction to Dictionaries, Operations on Dictionaries, 2
Dictionary methods, Converting List into Dictionary, Passing
dictionaries to functions.
Classes, Inheritance and Polymorphism 10
Classes
Creating a class, The Self variable, Constructor, Types of 3
variables, Types of methods, Passing members of one class to
3 another.
Inheritance
Implementing inheritance, Constructors in inheritance,
Overriding Super class constructors and methods, The 4
super() method, Types of Inheritance, Single and multiple,
problems in multiple inheritance, Method resolution
order(MRO).
Polymorphism
Introduction to polymorphism, Duck Typing Philosophy of 3
Python, Operator overloading, method overloading, method
overriding.
Exception Handling, Standard Library, Creating 10
Virtual Environment and Python Database
connectivity
Exception Handling and Standard Library
Exceptions, Exception handling, Types of exceptions,
Operating System Interface, File wildcards, Command line 4
4 arguments, String pattern matching, mathematics , internet
access, dates and times, data compression, performance
measurement.
Creating virtual environment
Introduction, generating virtual environments, managing 1
packages with pip( Python Package Index).
Python and MySQL
Installing MySQL Connector, Verifying the Connector
Installation, Using MySQL from Python, Retrieving all rows 5
from a table, Inserting rows into a table, Deleting rows from
10
table, Updating rows in a table, Creating database tables
through Python.
TEXT BOOK:
1) Core Python Programming
By, Dr. R. Nageswara Rao, 2017 edition
2) Python Tutorial (Release 3.6.4)
By, Guido van Rossum and the Python development team
REFERENCE BOOK:
1) A Byte of Python,
By Swaroop C H
2) Python Cookbook, Recipes of Mastering Python 3,
By David Beazely & Brian K. Jones
WEB RESOURCES:
https://www.python.org/about/apps/
https://www.w3schools.com/python/default.asp
https://www.tutorialspoint.com/python3/index.htm
https://www.programiz.com/python-programming/tutorial
REQUIRED SOFTWARES:
Python 3.4.1 or higher
IDE: IDLE
Database: MySQL
11
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE CREDIT 3
12
Asynchronous, Synchronous communication
Simplex, half duplex and full-duplex communication
13
Introduction 4
Protocols in computer communications
OSI model and layer functions
TCP/IP
Introduction
TCP/IP basics
LAN and WAN 4
Introduction
LAN
Ethernet
Introduction
Properties of Ethernet
CSMA/CD
Introduction to VLAN, Fast and Gigabit Ethernet
Token ring
Basics of Token ring
FDDI
Introduction
Properties
Operation
Self healing mechanism
Introduction to WAN
Introduction (Note: Overview of this topics should be 2
covered)
ISDN, Architecture, Channel types, interfaces
Bluetooth
Infrared communication
Wireless LAN
Internetworking devices
Repeaters
Bridges
Routers
Gateway
Textbook
Data Communications and Networks, 2nd Edition
Publisher: McGraw Hill
By Achyut S Godbole, Atul Kahate
REFERENCE BOOKS:
1. Business data communication
Publisher: Cengage publications
By Selly Cashman
2. Data communications and networking
Publisher: McGraw Hill
By Behrouz Forouzan
3. Computer networks
Publisher: Pearson
By Andrew S. Tanenbaum
14
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE CREDIT 3
15
2. Design two different css class in the web page having
different formatting features like border size, border
style, border color, font color, background color etc.
Place two buttons and a label on the .aspx page. On
the click event of the first button one css class will be
applied to the label and on the click event of the second
button apply second css class to the label. (Changing
appearance of the label at run time using CSSClass
property).
3. Design a class file having two methods to do sum and
multiplication, which takes two arguments. Design a
web page having two textboxes to take integer number
from the user. Place two buttons to invoke sum and
multiplication method. Print the resultant value in the
label control placed on the web page. (Use of App_code
directory).
4. Create .dll class library file having 2 classes and each
class has at least two methods. Add the .dll file into
the ASP.NET website. Design a web page to invoke the
methods of .dll files. Use appropriate textboxes, label
and button controls. (Use of Bin directory).
5. Create a page which will show number of visitors of a
page in label (using global.asax).
6. Design a webpage which has textbox and a button.
User will enter his/her name in the textbox. On the
click event of the button name of the user and current
date time will be displayed on the titlebar of the web
page. (Using Literal control).
7. Create an application Hit counter, which count the
total number of users visited the page. (Using
global.asax).
8. Take to linkbuttons showing ‘New Member’ and
‘Existing Member’. When user clicks on the ‘New
Member’ link button panel1 becomes visible, having
user name, password, confirm password and email as
inputs. When user clicks on ‘Existing Member’ link
button then only panel2 becomes visible having user
name and password as inputs). Set proper property of
the textbox to mask the password.
9. Design .aspx web page which prints “Gujarat
University” for 5 times, each in a new row with
increasing font size by 1 each time. (Use loop in c#
using code render block).
10. Create web page which will ask the employee
personal detail, education detail, work experience
16
detail with use of different panel for each part. Allow
user to click on submit button and display a message
“Data is successfully submitted” in a new label by
adding it at runtime in a panel.
11. Create web page which will ask payment detail
of customer purchase, this detail either in Cash or
Credit/Debit card or by Cheque. According to the
payment mode panel control will display and accept
payment detail and display all that detail in next page
using label control.
12. Write a program to set the following properties of
Label control using internal css class.
Background-color as green,
Border style as solid
Border color as blue
Border width as 2px
Text as “Hello!”
When user moves mouse over the label, its
background color should change it to yellow. Add
one more web form which contains button. When
user clicks on it change its fore color as pink using
external css.
• A DropDownList
• A Button
• A Label
The DropDownList is used to list items available in a store.
When the user clicks on an item in the DropDownList, the
cost of the selected item is displayed in the label control.
The Form title must be ASP.NET. A button must be in the
2 center of a form.
Add the following more controls:
• Two labels
• A TextBox
• A Button
One of the labels is displayed adjacent to the textbox,
displaying the message “Enter the quantity:” When the
user enters the quantity in the textbox and clicks the
button, the total cost is evaluated and displayed in another
label.
17
2. Create a RadioButtonList that displays the names of some
colors in two columns. Add a button to the Web Form which
when clicked changes the color of the Form to the color
selected from the list.
3. Create a web page having checkboxlist control shows
different products. Web page should have a button and a
label. On the click event of the button shows the message
“Thank You for placing the order of following items” and
then list of all products selected by the user in the
checkboxlist server control. Each selected product should
be displayed in the new line.
4. Write a simple Web application which keeps track of the
number of times a user has visited the page from the same
machine. The application keeps track of this information by
storing this counter value in a persistent cookie at the
client’s machine.
5. Display name of country in dropdown list when page is
loaded. Allow the user to select the country and display the
name of states of that country selected by user in another
dropdown list. (Also perform through datareader)
6. Write code to upload only image files (.bmp, .jpg, .gif) and
less than 1 kb in folder “Image-Folder”. Also display
uploaded image files on the same web page using datalist
control.
7. Accept Item No, Item Name, Item Price, Item Quantity. Store
information in cookie. Display stored information in next
page.
8. Take single image having 3 rectangle shapes horizontally
having text “Home”, “Product” and “Services” written in the
boxes. When user clicks on the first rectangle Home.aspx
page should be opened. Similarly, when user clicks on the
Product rectangle the product.aspx and Service rectangle
then service.aspx should be opened. Use ImageMap control.
9. Using AdRotator control, display 3 images of car and when
user click on it, open website of it. Load the advertisement
details from the XML file as well as database.
10. Using calendar control, allow user to select date from
that. Display students whose birthday falls on that date
(use database).
18
1. Design a site for “Gujarat University”. Design master page
having header, sidebar, footer and content section. Put
copywrite warning in the footer and university name in the
header. In the sidebar put Treeview control, filled from
sitemap. Create following hierarchy in the sitemap and
provide links to various pages.
2. Design a web site which allows user to register, login,
changer password and forgot password features. Create a
page which can be opened only by authenticated users, also
create a page which can be opened on by the that user who
belongs to ‘Admin’ role. On the home page display Welcome
message base on the type of user. For example, for
anonymous user show “Welcome Visitor”, for User show
“Welcome <UserName>” and for any user belongs to admin
role, show “Welcome Administrator”.
3. Design a web form and perform the following validations:
10
19
7. Design a website in which use all login controls. Also create
Role and apply role-based access rule, anonymous user-
based access rules. Also demonstrate profile
implementation.
8. Design a website which based on user role, user will be
redirected to specific page. Create at least 2 roles, and web
pages for each role. Both pages must use different master
pages. (For example, user belongs ‘Admin’ role will
automatically redirected to ‘Admin.aspx’ which uses
‘Admin.master’ master page, and user belongs to
‘Customer’ role, automatically gets redirected (after login) to
customer.aspx page which uses master page
customer.master).
20
Authentication, Authorization and Data controls 10
1. Create a database with two tables as StudentInfo, which
contain rollno, name and year of a student and
StudentScore which contain marks of three subjects for
each student. Display name of all the students in a
DropDownList and according to user’s choice, particular
student’s score record should display in a
FormView/DetailView control.
2. Develop a web application to reserve online in a hotel. The
user should enter date of arrival, number of days, room
type, number of persons etc. He would be able to confirm
booking and allowed to pay advance on confirmation.
3. Create an application to display all records from an
Employee table with proper formatting. (Use Repeater
Control).
4. Create a product table having field (ProductCode, Name,
Price, Description, CategoryName, ProductURL etc.). Design
a web page which shows hyperlink for each unique
category. When user click on specific hyperlink pass that
category to another page called ProductList.aspx. This page
list all the product which belongs to the category selected
by the user on the previous page. The page has small image
of the product and price only. When user clicks on small
product image then user will be redirected to
4 ProductDetails.aspx page. Which shows all the details of the
product with larger image.
5. Create a product table having field (ProductCode, Name,
Price, Description, CategoryName, ProductURL etc.). Design
a webpage so the Admin can enter the new product details.
Use file upload control for the ProductURL field which also
upload the product picture to some specific folder called
‘ProductImages’. After successful insertion redirect user to
the ‘ProductList’ page where all product details displayed in
the GridView with small product image.
6. Create two tables Doctor and Patient. Display details of
doctor in first grid view. When user selects doctor from the
first grid view, display the details of all patients of that
doctor in second grid view.
7. Write C#.NET code for following using membership and
role and other ACL classes:
Registration page
Login Form
Page to add user in the specific role
List all user details in the GridView
8. Design a webpage which allow user to perform Select,
Insert, Update and Delete record operation to the database
table using ADO.NET code.
9. Design a webform to enter new Employee details includes
EmpCode, Name, Address, DeptCode, StateCode and
21
CityCode. EmpCode should be automatically generated like
E001, E002, … E010 and so on. When user press insert
button. Use DropDownList for to View State, City and
Department from the respective tables, and fetch codes
based on user selection. On the click of the insert button
store these details in the Employee table.
10. Create four tables as given:
Customer (CustomerCode, Name, Address)
Product (ProductCode, ProductName, Price, Qty)
SalesMaster (InvoiceNumber, CustomerCode,
DateofInvoice)
SalesDetails (InvoiceNumber, ProductCode, Qty,
UnitPrice)
Design a webpage to generate Invoice details in which
Customer name, Product name, and Line total (Unit price *
Quantity) is shown using FormView and GridView.
TEXT BOOK:
1. Professional ASP.NET 3.5 (Sp1) In C# and VB by Bill Evjen, Scot
Hanselman and David Rader (Wrox)
REFERENCE BOOKS:
2. ASP.NET 4 unleased by Stephen Walter (PEARSON)
22
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE TITLE
CC305 Python Programming Practicals
COURSE CODE CC-305
COURSE CREDIT 3
Sessions Per Week 3
Total Teaching Hours 40 Hours
AIM
To train the students from the basics of coding and executing Python scripts to
the more advanced features of using libraries, handling errors and connecting to
databases.
LEARNING OUTCOMES
On the completion of the course students will:
1. To learn how to design and implement efficient programming using python.
2. To learn working with the new datatypes in python.
3. To understand and use object based software concepts.
4. To work with the built in libraries and also prepare your own customised
libraries.
5. Learning the importance of using different versions of python in a single
system.
6. To connect python applications with database.
Note
The list in each unit is indicative only and may or may not be asked in the
examination. The programs given below are only sample example for practice in
lab.
DETAIL SYLLABUS
UNIT TOPIC/SUB TOPIC TEACHING
HOURS
Beginning with Python, Datatypes, Operators, I/O and 10
Control statements
1. Write a program to swap two numbers without taking a
temporary variable.
2. Write a program to display sum of two complex numbers.
3. Write a program to create a byte type array, read, modify,
and display the elements of the array
4. Create a sequence of numbers using range datatype to
display 1 to 30, with an increment of 2.
1
5. Write a program to find out and display the common and
the non common elements in the list using membership
operators
6. Create a program to display memory locations of two
variables using id() function, and then use identity
operators two compare whether two objects are same or
not.
7. Write a program that evaluates an expression given by
the user at run time using eval() function. Example:
23
Enter and expression: 10+8-9*2-(10*2)
Result: -20
8. Write a python program to find the sum of even numbers
using command line arguments.
9. Write a menu driven python program which perform the
following:
Find area of circle
Find area of triangle
Find area of square and rectangle
Find Simple Interest
Exit.( Hint: Use infinite while loop for Menu)
10 Write a program to assert the user enters a number
greater than zero.
11. Write a program to search an element in the list using
for loop and also demonstrate the use of “else” with for
loop.
12. Write a python program that asks the user to enter a
length in centimeters. If the user enters a negative
length, the program should tell the user that the entry is
invalid. Otherwise, the program should convert the
length to inches and print out the result. (2.54 = 1 inch).
Modules, Arrays, Functions, List, Tuples and Dictionaries 10
1. Write a program to create one array from another array.
2. Create a program to retrieve, display and update only a
range of elements from an array using indexing and
slicing in arrays.
3. Write a program to understand various methods of array
class mentioned: append, insert, remove, pop, index,
tolist and count.
4. Write a program to sort the array elements using bubble
sort technique.
5. Create a program to search the position of an element in
an array using index() method of array class.
6. Write a program to generate prime numbers with the
help of a function to test prime or not.
7. Write a python program that removes any repeated items
from a list so that each item appears at most once. For
2
instance, the list [1,1,2,3,4,3,0,0] would become
[1,2,3,4,0].
8. Write a program to pass a list to a function and display
it.
9. Write a program to demonstrate the use of Positional
argument, keyword argument and default arguments.
10. Write a program to show variable length argument and
its use.
11. Write a lambda/Anonymous function to find bigger
number in two given numbers.
12. Create a decorator function to increase the value of a
function by 3.
13. Create a program name “employee.py” and implement
the functions DA, HRA, PF, and ITAX. Create another
program that uses the function of employee module and
calculates gross and net salaries of an employee.
24
14. Write a program to create a list using range functions
and perform append, update and delete elements
operations in it.
15. Write a program to combine two List, perform repetition
of lists and create cloning of lists.
16. Create a sample list of 7 elements and implement the
List methods mentioned: append, insert, copy, extend,
count, remove, pop, sort, reverse and clear.
17. Write a program to create nested list and display its
elements.
18. Write a program to accept elements in the form of a tuple
and display its minimum, maximum, sum and average.
19. Create a program to sort tuple with nested tuples.
20. Write a program to create a dictionary from the user and
display the elements.
21. Create a dictionary that will accept cricket players name
and scores in a match. Also we are retrieving runs by
entering the player’s name.
22. Write a program to convert the elements of two lists into
key-value pairs of a dictionary.
23. Create a python function to accept python function as a
dictionary and display its elements.
Classes, Inheritance and Polymorphism 10
1. Write a program to create a Student class with name,
age and marks as data members. Also create a method
named display() to view the student details. Create an
object to Student class and call the method using the
object.
2. Write a program to create Student class with a
constructor having more than one parameter.
3. Write a program to demonstrate the use of instance and
class/static variables.
4. Write a program to store data into instances using
mutator methods and to retrieve data from the instances
using accessor methods.
5. Write a program to use class method to handle the
common features of all the instance of Student class.
3 6. Write a program to create a static method that counts
the number of instances created for a class.
7. Create a Bank class with two variables name and
balance. Implement a constructor to initialize the
variables. Also implement deposit and withdrawals
using instance methods.
8. Write a program to create a Emp class and make all the
members of the Emp class available to another class
(Myclass). [By passing members of one class to another]
9. Create a Student class to with the methods set_id,
get_id, set_name, get_name, set_marks and get_marks
where the method name starting with set are used to
assign the values and method name starting with get are
returning the values. Save the program by student.py.
Create another program to use the Student class which
is already available in student.py.
25
10. Write a program to access the base class constructor
from a sub class by using super() method and also
without using super() method.
11. Write a program to override super class constructor and
method in sub class.
12. Write a program to implement single inheritance in
which two sub classes are derived from a single base
class.
13. Write a program to implement multiple inheritance
using two base classes.
14. Write a program to understand the order of execution of
methods in several base classes according to method
resolution order (MRO).
15. Write a program to check the object type to know
whether the method exists in the object or not.
16 Write a program to overload the addition operator (+) to
make it act on the class objects.
17. Write a program to show method overloading to find sum
of two or three numbers.
18. Write a program to override the super class method in
subclass.
Exception Handling, Standard Library, Creating Virtual 10
Environment and Python Database connectivity
1. Write a program to handle some built in exceptions like
ZeroDivisionError.
2. Write a program to handle multiple exceptions like
SyntaxError and TypeError
3. Write a program to import “os” module and to print the
current working directory and returns a list of all module
functions
4. Write a program to provide a function for making file lists
from directory wildcard searches.
5. Write a program to import datetime module and format
the date as required. Also use the same module to
calculate the difference between your birthday and today
in days.
6. Write a program to create a database named
4
“Sample_DB” in MySQL(). [First ensure connection is
made or not and then check if the database Sample_DB
already exists or not, if yes then print appropriate
message]
7. Write a program to retrieve and display all the rows in
the employee table. [First create an employee table in the
Sample_DB with the fields as eid, name, sal . Also enter
some valid records]
8. Write a program to insert several rows into employee
table from the keyboard.
9. Write a program to delete a row from an employee table
by accepting the employee identity number (eid) from the
user.
10. Write a program to increase the salary (sal) of an
employee in the employee table by accepting the
employee identity number (eid) from the user.
26
11. Write a program to create a table named
new_employee_tbl with the fields eno , ename , gender
and salary in Sample_DB database. The datatypes of the
fields are eno-int, ename-char(30), gender-char(1) and
salary-float.
TEXT BOOK:
1) Core Python Programming
By, Dr. R. Nageswara Rao, 2017 edition
2) Python Tutorial (Release 3.6.4)
By, Guido van Rossum and the Python development team
REFERENCE BOOK:
1) A Byte of Python,
By Swaroop C H
2) Python Cookbook, Recipes of Mastering Python 3,
By David Beazely & Brian K. Jones
WEB RESOURCES:
https://www.python.org/about/apps/
https://www.w3schools.com/python/default.asp
https://www.tutorialspoint.com/python3/index.htm
https://www.programiz.com/python-programming/tutorial
REQUIRED SOFTWARES:
Python 3.4.1 or higher
IDE: IDLE
Database: MySQL
27
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE CREDIT 5
28
Trading/Business houses
Private Organizations
Software Consultancy companies (only if the project work
seem to be original and beneficial)
A challenging in-house software project.
The location of the organization is immaterial. It can be
Local in the city
In the vicinity of the city
Mostly the work will have to be done at home or the
institute.
Which Project to Avoid?
The project of system study
Involves only modification in existing software, such as
porting of software or few updates
Involves only data storage and retrieval without any
processing.
Conventional small applications such as
Library Management
Examination (conduct or Results)
Educational Institute Management
Payroll
Accounting system or inventory
Human Resource
Note: Students can take up any of the above only if the
application would handle real volume and will have substantial
complexities.
Preferred Projects:
Will be such as that caters to Innovative areas/ideas
Use of emerging technology –
RFID
GPS
Biometrics
Bioinformatics, GIS etc.
Challenging uses of Communication and Internet
Scientific applications
Graphics applications
Systems software and utilities
Embedded software
o ERP modules
Preferred Tools:
Students should feel free to use the tools of their choice
subject to permission of the organization.
Working on any acceptable project would give good
exposure to use of analytical tools, programming skills and
development tools. Hence, any programming or development
environment should be acceptable.
Deliverables by the students:
At the end of the semester, the student should be able
29
to work on the identified the project and submit the
documentation (hard copy) and the presentation.
Documentation:
A hard copy of the documentation should consist of the
following:
Cover Page
Company Certificate
College Certificate
Acknowledgement
Index (with page nos.)
Organization / Company Profile
Project Profile
Existing System
Proposed System
Development Tools and Technology used
System Flow Diagram (if applicable)
UML Diagram/Data Flow Diagram *
Entity Relationship Diagram *
Data Dictionary/Table Design *
In applications which uses database.
Presentation:
Presentations can be prepared through slides using any
Open Source / PowerPoint /Flash or any other
multimedia tool, covering the work shown in the
documentation.
During viva examination, students will be expected to
satisfactorily answer questions pertaining to the project
profile, diagrams and tables/data dictionary prepared
by them.
30
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE CREDIT 3
31
Introduction
Select Project
Identify Project Scope and Objectives
Identify Project Infrastructure
Analyze Project Characteristics
Identify Project Product and Activities
Estimate Effort for Each Activity
Identify Activity Risks
Allocate Resources
Review/ Publicize Plan
Execute Plan, Lower level of Planning
Selection of an Appropriate Project Approach, Software
Effort Estimation 10
Selection of an Appropriate Project Approach
Introduction
The Waterfall Model
The Spiral Model
Software Prototyping
Incremental Delivery
Atern/Dynamic Systems Development Method
Software Effort Estimation
2
Introduction
Where are Estimates Done?
Problems with Over-and-Under-Estimates
The Basis for Software Estimating
Software Effort Estimation Techniques
Bottom-Up Estimating
The Top-down Approach and Parametric Models
Expert Judgment
Estimating by Analogy
Albrecht Function Point Analysis
32
Risk Management
Introduction
Risk
Categories of Risk 3
A Framework for Dealing with Risk
Risk Identification
Risk Assessment
Risk Planning
Resource Allocation, Monitoring and Control, Managing
Contracts, Software Quality 10
Resource Allocation
Introduction
The Nature of Resources Cost Schedules
Monitoring and Control
Introduction
Visualizing Progress
4
Earned Value Analysis
Managing Contracts
Introduction
Types of Contracts
Stages in Contract Placement
Software Quality
Introduction
Defining Software Quality
Textbook
Software Project Management (5th Edition)
Publisher: Mc Graw Hill
By Bob Hughes, Mike Cotterell, Rajib Mall
REFERENCE BOOKS:
33
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE
TITLE SEC301 Information Security
COURSE CODE SEC-301
COURSE CREDIT 3
34
Computer Forensics
The Information Security Professional’s Code
of Ethics
Other Ethics Standards
Physical Security Control and Operations
Security 10
Physical Security Control 5
Introduction
Understanding the Physical Security Domain
Physical Security Threats
2 Providing Physical Security
Operations Security 5
Introduction
Operation Security Principles
Operations Security Process and Controls
Operations Security Controls in Action
Access Control System and Methodology and
Cryptography 10
Access Control Systems Methodology 4
Introduction
Terms and Concepts
Principles of Authentication
Biometrics
Single Sign-On
3 Remote User Access and Authentication
Cryptography
6
Introduction
Applying Cryptography to Information
Systems
Basic Terms and Concepts
Strength of Cryptosystems
Putting the Pieces to Work
Examining Digital Cryptography
Telecommunications , Network and Internet
Security and hours Application Development
Security 10
Telecommunications , Network and Internet 6
Security
Introduction
4 Network and Telecommunications Security
Feet Up
Network Security in Context
The OSI Reference Model 6 hrs
Data Network Types
Protecting TCP/IP Networks
Basic Security Infrastructures
Firewalls
35
Intrusion Detection Systems
VPNs 6
Application Development Security
Introduction
The Practice of Software Engineering
SDLC 4 hrs
Distributed Systems
Malware
Antivirus Software
Improving Security Across the SDLC
o Textbook
REFERENCE BOOKS:
1. Information Security Theory and Practice
Publisher: PHI
By Dhiren R. Patel
2. Computer Security Fundamentals
Publisher: Pearson
By Chuck Eastiom
36
GUJARAT UNIVERSITY
BCA SEM-V SYLLABUS
COURSE CREDIT 3
AIM
To develop the skill about the basic mobile application development using
Android
To create android apps with different features and basic functionalities
LEARNING OUTCOMES
On the completion of the course students will:
1.Understand the meaning and syntax of android programming
3.Understand the basic android terminology and technology
4.To design activities using simple and advanced controls of android
5.To understand the fundamental concepts of mobile app development
DETAIL SYLLABUS
TEACHING
UNIT TOPIC / SUB TOPIC HOURS
Introduction to Android 10
37
Android Terminology
Context, Activity, Services, Intents
Application tasks with activities
Activity Life cycle 6
Managing activity transitions with intents
Working with services
Receiving and Broadcasting intents
4 Fragment Lifecyle
List Fragment
WebView Fragment
Working with Dialogs 4
Types of Dialogs
Lifecycle of a Dialog
TEXT BOOK/S:
38
Lauren Darcey and Shane Conder, “Android Wireless Application
Development”, Pearson Education
REFERENCE BOOKS:
Reto Meier, “Professional Android 2 Application Development”, Wiley
India Pvt Ltd (2011)
Mark L Murphy, “Beginning Android”, Wiley India Pvt Ltd (2009)
Sayed Y Hashimi and Satya Komatineni, “Pro Android”, Wiley India Pvt
Ltd (2009)
WEB RESOURCES:
https://developer.android.com/training/index.html
http://www.androidhive.info/2011/
https://developer.android.com/guide/components/index.html
REQUIRED SOFTWARE/S
Android Studio 2.3 ( https://developer.android.com/studio/index.html)
Java version 1.8
39
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE CREDIT 2
40
Transportation Problems
Transportation Problem and Its Solution
Northwest Corner Rule
Least Cost Method
Assignment Problem
Assignment problem and its solution
Sequencing Problems 10
Methods to Solve Single Machine Scheduling
Problems
Johnson’s Algorithm for Solving N jobs and
3 Two/Three Machine Problem
Three Machine And N Jobs Scheduling Problems
using Johnson’s Algorithm Extension
Job Shop Scheduling: Two Jobs and M Machines
Text Book
Operations Research
Publisher: Cengage Learning
By M.V.Durga Prasad
41
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE CREDIT 2
43
ERP system and Customer Relationship
Management 10
ERP system
Introduction
Sales and Distribution
Finance
Materials Management
Manufacturing
Human Resource
Quality Management
Customer Relationship Management
Overview
Electronic customer Relationship Management
3 system
e-CRM versus CRM
Key e-CRM features
Evolving to e-CRM
Technological and business issues involved in e-
CRM
E-CRM business drivers
E-CRM assessment
Issues on Implementing e-CRM system
E-CRM Architecture
eCRM components
The five Engines of e-CRM
Implementing of E-CRM
Challenges in delivering true E-CRM
Knowledge Management System and Decision
support system 10
Knowledge Management System
Knowledge Management
Knowledge Management system
Types of Knowledge Management System
Knowledge Network System
Knowledge work system
4
Artificial intelligence Management System
Expert system
Decision support system
Introduction
Decision making and MIS
Decision support system
Group decision Support System
Textbook
Management Information System: An Insight
Publisher: International Book House Pvt. Ltd.
By Hitesh Gupta
44
REFERENCE BOOKS:
1. Management Information Systems(4th Edition)
Publisher: Mc Graw Hill
By Waman S Jawadekar
2. Management Information System
Publisher: PHI
By Indrajit Chatterjee
45
GUJARAT UNIVERSITY
BCA V SYLLABUS
COURSE CREDIT 3
46
Flat-Panel Displays
Three Dimensional Viewing Devices.
Stereoscopic and Virtual-Reality Systems
Raster-Scan Display Processor
Random-Scan Systems
Input Devices
Keyboards
Mouse
Trackball and Spaceball
Joysticks
Data Glove
Digitizers
Image Scanners
Touch Panels
Light Pens
Voice Systems
Coordinate Representations
Graphics Functions
Software Standards
PHIGS Workstations
Output Primitives 10
Points and Lines
Line-Drawing Algorithms, DDA Algorithm, Bresenham’s
Line Algorithm
Loading the Frame Buffer
2 Circle-Generating Algorithm, Properties of Circles,
Midpoint Circle Algorithm
Filled-Area Primitives, Scan-Line Polygon Fill Algorithm,
Inside-Outside Tests, Scan-Line Fill of Curved Boundary
Areas, Boundary-Fill Algorithm, Flood-fill Algorithm
47
The Viewing Pipeline
Viewing Coordinate Reference Frame
Window-to-Viewport Coordinate Transformation
Clipping Operations
Point Clipping
Line Clipping, Cohen-Sutherland Line Clipping,
Liang-Barsky Line Clipping, Nicholl-Lee-Nicholl Line
Clipping, Line Clipping Using Nonrectangular Clip
Windows, Splitting Concave Polygons
Polygon Clipping, Sutherland-Hodgeman Polygon
Clipping, Weiler-Atherton Polygon Clipping, Other
Polygon-Clipping Algorithm
Textbook
Computer Graphics C Version,
Second Edition
Donald Hearn, M. Pauline Baker
48