Bachelor of Computer Application (BCA) Semester – 06
BHAKTA KAVI NARSINH MEHTA
UNIVERSITY JUNAGADH
(Gujarat) INDIA
CURRICULUM FOR
(Bachelor of Computer Application)
BCA
(Semester - 6)
Effective from November – 2020
BHAKTA KAVI NARSINH MEHTA
UNIVERSITY
Bachelor of Computer Application – Semester – 6
[3 Years– Six Semester Full Time Program]
Semester – 6
No. Of
Lectures/
Code Course Name Credit
Lab
(Per Week)
CS – 31 Mobile Computing using Android and iPhone 5 5
CS – 32 Data Warehousing with SQL Server 2012 5 5
CS – 33 Programming in Advance Python – 2 5 5
CS – 34 Practical – 1 (based on CS – 31) - 5
CS – 35 Practical – 2 (based On CS – 32 & CS – 33) - 5
CS – 36 Project – Viva - 5
Total Credits of Semester – 5 30
2
CS – 31 Mobile Computing using Android and iPhone
Unit : 1
Introduction to Android & Android Application Design
The Open Handset Alliance
The Android Platform, Android SDK
Building a sample Android application
Anatomy of an Android applications
Android terminologies
Application Context, Activities, Services, Intents
Receiving and Broadcasting Intents
Android Manifest File and its common settings
Using Intent Filter, Permissions
Managing Application resources in a hierarchy
Working with different types of resources
Unit : 2 – Android User Interface Design
User Interface Screen elements
o Button o TimePicker o RadioGroup
o EditText o ProgressBar o ImageButton
o TextView o ListView o Fragement
o DatePicker o GridView
Designing User Interfaces with Layouts
o Relative Layout o Table Layout
o Linear Layout o GridLayout etc
Dialogs
Drawing and Working with Animation
o Frame By Frame Animation
o Twined Animation
Fade In Zoom Out Bounce
Fade Out Rotate Sequential
Cross Fading Move Together
Blink Slide Up
Zoom In Slide Down
Unit : 3 - Database Connectivity Using SQLite and Content Provider
Using Android Data and Storage APIs
Managing data using SQLite and Perform (insert update delete and select operation)
Sharing Data Between Applications with Content Providers
Introduction to rest api
Introduction to Retrofit
3
Unit : 4 – Location Based Services (LBS) Common Android API Notifications Services
Deployment of applications
Using Global Positioning Services (GPS)
Geocoding Locations
Mapping Locations
Generate marker
Many more with location based services
Android networking API
Android web API
Android telephony API
Notifying the user Notifying with the status bar
Vibrating the phone
Blinking the lights
Customizing the notifications Services
Application development using JSON in MySQL
Publish android application
Unit : 5 – Introduction To iPhone
Introduction To X-Code (IDE)
What is Storyboard
Framework Design User Interface for button text view text field etc.
Creating And Building Simple Application
Cocoa Touch And MVC
Notes : Android application must be developed using ANDROID STUDIO.
Reference Books :
1) Android Wireless Application Development By Lauren Darcey and Shane Conder Pearson Education
2nd ed. (2011)
2) Beginning iOS 6 Development By David Mark Jack Nutting Jeff LaMarche Fredrik Olsson Apress
Publication.
3) Using SQLite By Jay A. Kreibich Publisher: O'Reilly Media
4) Mobile Computing using Android & iPhone [ISBN: 978-93-81786-93–2] by Bharat & Company
5) Professional Android 2 Application Development Reto Meier Wiley India Pvt Ltd (2011)
6) Beginning Android Mark L Murphy Wiley India Pvt Ltd
Reference Websites:
1) https://www.tutorialspoint.com/android/
2) https://www.javatpoint.com/android-tutorial
3) https://developer.android.com/guide
4) https://developer.android.com/training/basics/firstapp
5) https://www.studytonight.com/android/
4
CS – 32 Data Warehousing with SQL Server 2012
Unit : 1
Introduction to Data Warehousing
What Is a Data Warehouse?
Data Warehousing Today
o Business intelligence
o Customer Relationship Management
o Data Mining
Future Trends in Data Warehousing.
o Unstructured Data
o Search
o service oriented architecture (SOA)
o Real-time data warehousing
Data Warehouse Architecture
o Data flow architecture
o System architecture
Unit : 2
Designing and Implementation of Data Warehousing
Logical Design for data warehouse
o Data Warehousing Schemas
Star Join (Star Schema) and Snowflake structure
Physical Design for data warehouse
o Physical Design Structures
Tablespaces
Tables and Partitioned Tables
Views
Integrity Constraints
Dimensions
Design dimension table fact table for data warehouse
Design and implement effective physical data structure for data warehouse
Unit : 3
Creating ETL Solutions with SSIS Implementing Control Flow in SSIS
Introduction to ETL with SSIS
Introduction to SQL Server Data Tools
Implementing data flow using SSIS
o Configuring the Data Flow
Sources
Transformations
Derived Column
Conditional Split
5
Destinations
Introduction to Control Flow
o SSIS Tasks
SSIS Containers
o For Loop Container
o Foreach Loop Container
Foreach File enumerator
Foreach Item enumerator
Foreach SMO enumerator
Foreach Nodelist enumerator
Foreach ADO enumerator
Foreach ADO.NET Schema
Foreach From Variable enumerator
o Sequence Container
Create Dynamic Packages Using Containers
Unit : 4
Enforcing Data Quality Extending SQL Server Integration Services
Introduction to Data Quality
o Installing and setting up the DQS
o Creating a Knowledge Base
Using Data Quality Service to cleanse data
Using Data Quality Service to match data
Using Scripts in SSIS
o Script Task
The Script Task Dts Object
o Script Component
Using Custom components in SSIS
Unit : 5
Deploying & Configuring SSIS Packages Consuming Data in Data Warehouse
Overview of SSIS Development
o Packages
o Control Flow vs. Data Flow
o Package Functionality Extension Objects
Deploying SSIS Projects
o Deploying Packages to SQL Server Integration Services Catalog
o Deployment Models In SSIS
Planning SSIS Package Execution
Introduction to Business Intelligence
Introduction to Reporting
o Basic Reports in SQL Reporting Services
o Parameters in Reporting Services
o Charts in SSRS
6
SQL Server Reporting Services Configuration Manager (For Deploy Project in Report Server)
Introduction to Data Analysis
Create Cube and Dimensions Using Data Analysis
Notes : For Lab Practice : Microsoft SQL Server 2012 or Higher version
Reference Books :
1) Implementing a Data Warehouse with Microsoft® SQL Server® 2012 Dejan Sarka Matija Lah Grega
Jerkič
2) Building a Data Warehouse: With Examples in SQL Server – Vincent Rainardi-Apress (2014)
3) Data mining Explained A manager’s guide to customer centric business intelligence by
4) Data mining by Pieter Adriaans Dolf Zantinge
5) Data warehousing in the real world A practical guide for business DSS by Sam Anahory
Reference Websites :
1) https://www.tutorialgateway.org/ssis/
2) https://www.tutorialspoint.com/ms_sql_server/ms_sql_server_integration_services.htm
3) https://www.guru99.com/ssis-tutorial.html
7
CS – 33 : Programming in Advance Python – 2
Unit : 1 – Python Tkinter
Python Tkinter Tkinter Message
Tkinter Button Tkinter Radiobutton
Tkinter Canvas Tkinter Scale
Tkinter Checkbutton Tkinter Scrollbar
Tkinter Entry Tkinter Text
Tkinter Frame Tkinter Toplevel
Tkinter Label Tkinter Spinbox
Tkinter Listbox Tkinter PanedWindow
Tkinter Menubutton Tkinter LabelFrame
Tkinter Menu Tkinter MessageBox
Unit : 2 – Python Numpy
NumPy Introduction NumPy Bitwise Operators
Environment Setup NumPy String Functions
NumPy Ndarray NumPy Mathematical Functions
NumPy Data Types Statistical Functions
NumPy Array Creation Sorting & Searching
Array From Existing Data Copies and Views
Arrays within the numerical range Matrix Library
NumPy Broadcasting NumPy Linear Algebra
NumPy Array Iteration
Unit : 3 – Plotting using PyLab & Multithreading
Plotting using PyLab Threading module
extended examples Synchronizing threads
Thread Multithreaded Priority
Starting a thread
Unit : 4 – Interaction with Database
Configuring database inserting and updating data
defining model selecting objects
basic data access deleting objects
Unit : 5 – Introduction to web Framework Django
Introduction to Django
MVC Design Pattern
8
Django installation
starting project
Django project architecture
HTTP Client-Server Request – Response, concept of web framework and web application.
Reference Books :
1) John V Guttag. “Introduction to Computation and Programming Using Python”, Prentice Hall of India
2) Wesley J Chun, Core Python Applications Programming, 3rd Edition. Pearson
3) Michael Bowles, Machine Leaning in Python, Essential techniques for predictive analysis, Wiley
4) Allen Downey, Jeffrey Elkner and Chris Meyers "How to think like a Computer Scientist, Learning with
Python", Green Tea Press
5) Alex Martelli, Python Cookbook, O’REILLY
Reference Websites :
1) https://www.geeksforgeeks.org/python-gui-tkinter
2) https://www.tutorialspoint.com/python/python
3) https://www.javatpoint.com/python
4) https://www.numpy.org/
5) https://www.djangoproject.com/start/
6) https://www.tutorialspoint.com/django
7) https://www.javatpoint.com/django
9
CS – 34 100 Marks
PRACTICAL – 1 (Based on CS – 31)
CS – 31 – Mobile Computing using Android & iPhone [100 Marks]
Each session is of 3 hours for the purpose of practical Examination.
Practical examination may be arranged before or after theory
exam
CS – 35 100 Marks
PRACTICAL – 2 (Based on CS – 32 & CS – 33)
CS – 32 – Data Warehousing with SQL Server 2012 [50 Marks]
CS – 33 – Programming in Advance Python – 2 [50 Marks]
Each session is of 3 hours for the purpose of practical Examination.
Practical examination may be arranged before or after theory
exam
CS – 36 100 Marks
PROJECT – VIVA
Project must be developed in the computer laboratory of concern
institute under the supervision of faculties of concern institute on
any subject of previous semester or current semester. (At the time
of Project-Viva examination student must show all the Workouts,
SDLC, Documentation, Program codes and project in running
mode)
Note :
Project must be submitted before two week of commencement of theory exam.
Project viva examination may be arranged before or after theory exam.
During the project viva examination project must be run.
10
BHAKTA KAVI NARSINH MEHTA UNIVERSITY
Bachelor of Computer Application
[3 Years - Six Semester Full Time Program]
Semester – 6
Paper Style
Unit : 01
Question : 1 (A) Answer The Following Question (Only Three) 03
Question : 1 (B) Answer The Following Question (Any Two out of Four) 06
Question : 1 (C) Answer The Following Question (Any One out of Two) 05
Unit : 02
Question : 2 (A) Answer The Following Question (Only Three) 03
Question : 2 (B) Answer The Following Question (Any Two out of Four) 06
Question : 2 (C) Answer The Following Question (Any One out of Two) 05
Unit : 03
Question : 3 (A) Answer The Following Question (Only Three) 03
Question : 3 (B) Answer The Following Question (Any Two out of Four) 06
Question : 3 (C) Answer The Following Question (Any One out of Two) 05
Unit : 04
Question : 4 (A) Answer The Following Question (Only Three) 03
Question : 4 (B) Answer The Following Question (Any Two out of Four) 06
Question : 4 (C) Answer The Following Question (Any One out of Two) 05
Unit : 05
Question : 5 (A) Answer The Following Question (Only Three) 03
Question : 5 (B) Answer The Following Question (Any Two out of Four) 06
Question : 5 (C) Answer The Following Question (Any One out of Two) 05
11
