AC T Y B Sc Applied Component Computer programe System Analysis SemV VI syllabus 2018 19_1 Syllabus Mumbai University by munotes
Page 2
UNIVERSITY OF MUMBAI
Syllabus for Semester V and Semester VI
Program: B.Sc.
Course: Computer Programming and
System Analysis
(APPLIED COMPONENT)
(CBCS)
With effect from 2018 -19
Page 3
Course Code USACCS501
UNIT I RELATIONAL DATA BASE MANAGEMENT SYSTEM –15 Lectures
1.Introduction to Data base Concepts : Database, Overview of data base management
system. Data base Languages -Data Definition Languages (DDL) and Data
Manipulation Languages (DML).
2.Entity Relation Model : Entity, artibutes, keys, relations, Designing ER diagram,
integrity Constraints over relations, conversion of ER to relations with and without
constrains.
3.SQL Commands and functions
a)Creating and altering tables : CREATE statement with constraints like KEY,
CHECK, DEFAULT, ALTER and DROP statement.
b)Handling data using SQL: selecting data using SELECT statement, FROM
clause, WHERE clause, HAVING clause, ORDERBY, GROUP BY,
DISTINCT and ALL predicates, Adding data with INSE RT statement,
changing data with UPDATE statement, removing data with DELETE
statement.
c)Functions: Aggregate functions -AVG, SUM, MIN, MAX and COUNT, Date
functions-ADD_MONTHS() ,CURRENT_DATE(), LAST_DAY(),
MONTHS_BETWEEN(), NEXT_DAY(). String functions -LOWER(),
UPPER(), LTRIN(), RTRIM(), TRIN(), INSERT(), RIGHT(), LEFT(),
LENGTH(), SUBSTR(). Numeric functions: ABS(), EXP(), LOG(), SQRT(),
POWER(), SIGN(), ROUND(number).
d)Joining tables: Inner, outer and cross joins, union.
UNITIIINTRODUCTION TO PL/S QL–15 Lectures
1.Fundamentals of PL/SQL: Defining variables and constants, PL/SQL expressions
and comparisons: Logical Operators, Boolean Expressions, CASE Expressions
Handling, Null Values in Comparisons and Conditional Statements,
2.PL/SQL Data Types: Number Types, Character Types, Boolean Type. Date time and
Interval types.
3.Overview of PL/SQL Control Structures: Conditional Control: IF and CASE
Statements, IF -THEN Statement, IF -THEN-ELSE Statement, IF -THEN-ELSIF
Statement, CASE Statement,
4.Iterative Control: LOOP and EXIT Statements, WHILE -LOOP, FOR -LOOP,
Sequential Control: GOTO and NULL Statements.
UNITIIIINTRODUCTION TO JAVA PROGRAMMING –15 Lectures
Page 4
1.Object-Oriented approach: Features of object -orientations: Abstraction,
Inheritance, Encapsulat ion andPolymorphism.
2.Introduction: History of Java features, different types of Java programs,
Differentiate Java with C. Java Virtual Machine.
3.Java Basics: Variables and data types, declaring variables, literals numeric,
Boolean, character and string literals, keywords, type conversion and casting.
Standard default values. Java Operators, Loops and Controls
4.Classes:Defining a class, creating instance and c lass members: creating
object of a class, accessing instance variables of a class, creating method,
naming method of a class, accessing method of a class, overloading method,
‘this’ keyword, constructor and Finalizer: Basic Constructor, parameterized
constructor, calling another constructor, finalize() method, overloading
constructor.
5.Arrays:one and two –dimensional array, declaring array variables, creating
array objects, accessing array elements.
6.Access control: public access, friendly access, protec ted access, private
access.
UNIT IVInheritance, Exception Handling
a)Inheritance: Various types so finheritance, super and sub classes, keywords -
‘extends’, ‘super’, over riding method, final and abstract class: final variables and
methods, final classes , abstract methods and classes. Concepts of inter face.
b)Exception Handling and Packages: Need for Expectional Hndling, Exception
Handling techniques: try and catch, multiple catch statements, finally block, us age of
throw and throws. Concept of packages. Inter class method: parseInt().
References:
1.Data base management system, RamKrishnam, Gehrke, McGraw -Hill
2.Ivan Bayross, “SQL, PL/SQL –The Programming languages of Oracle” B.P.B.
Publications, 3rdRevised Edition.
3.George Koch and Kevin Loney, ORACLE “The complete Ref erence”, Tata
McGraw Hill, New Delhi.
4.Elsmasri and Navathe, “Fundamentals of Database Systems” Pearson Education.
5.Peter Roband Coronel, “Database System, Design, Implementation and
Management”, Thomson Learning.
6.C.J. Date, Longman, “Introduction database system”, Pearson Education.
7.Jeffrey D. Ullman, Jennifer Widsom, “A Firs t Course in Database Systems”,
Pearson Education.
8.Martin Gruber, “Understanding SQL”, B.P.B. Publications.
9.Michael Abbey, Micheal. Corey, Ian Abramson, Oracle8i -A Beginner’s Guide,
Tata McGraw -Hill.
Page 5
10.Programming with Java: a Primer 4thEdition by E. Balagurusamy, Tata McGraw
Hill.
11.Java the complete Reference, 8thEdition, Herbert Schildt, Tata McGraw Hill.
Additional References:
1.Eric Jend rock, Jennifer Ball, D Carson and others, The Java EE5 Tutorial,
Pearson Education, T hird Editi on 2003.
2.Ivan Bayross, Web Enabled Commercial Applications Development using
Java 2, BPB Publications. Revised Edition, 2006.
3.Joe Wiggles worth and Paula Mc Millan, Java Programming: Advanced
Topics, Thomson Course Technology (SPPD), Third Edition 2004.
TheJavaTutorials ofSunMicrosystems Inc.http://docs.oracle.com/javase/tutorial
Suggested Pr acticals
1.Creatingasingletablewith/without constraints andexecuting queries.Queries
containing aggregate, stringanddatefunctions firedonasingletable.
2.Updating tables,alteringtablestructureanddeletingtableCreatingandalteringasingle
tableandexecuting queries.Joiningtablesandprocessing queries.
3.WritingPL/SQLBlockswithbasicprogramming constructs.
4.WritingPL/SQLBlockswithcontrolstructures.
5.WriteaJavaprogramtocreateaJavaclass:(a)without instancevariablesand
methods,(b)with instancevariablesandwithoutmethods,(c)with outinstancevariables
andwithmethods.(d) withinstancevariables andmethods.
6.WriteaJavaprogramthatillustrates theconcepts ofone,twodimension arrays.
7.WriteaJavaprogramthatillustrates theconceptsofJavaclassthatincludes(a)construct
orwithandwithoutparameters (b)Overloadingmethods.
8.WriteaJavaprogramtodemonstrate inheritance bycreatingsuitableclasses.
9.Writeaprogramthatillustrates theerrorhandlingusingexception handling.
SEMESTER VI
Course code USACCS 601
UNITI JAVAAPPLETSANDGRAPHICSPROGRAMMING -15 LECTURES
1.Applets:Difference of appletandapplication, creatingapplets,appletlifecycle,
passingparameters toapplets.
2.Graphics, FontsandColor:Thegraphicsclass,painting, repainting
andupdatinganapplet,sizinggraphics.Fontclass,drawgraphical
figures‐lines andrectangle, circleandellipse,drawingarcs,drawing
polygons. WorkingwithColors:Colormethods, settingthepaintmode.
3.AWT package: Containers: Frame and Dialog classes, Components: Label;
Button;Checkbox; TextField,TextArea.
Page 6
UNIT II PYTHON 3.x 15 LECTURES
1.Introduction : The Python Programming Language, History, features, Installing
Python.
Running Codein the Interactive Shell, IDLE.Input, Processing, and Output ,
Editing, Saving, and Running a Script, Debugging : Syntax Errors, Runtime Errors,
Semantic Errors, Experimental Debugging.
2.Data types and expressions :Variables and the Assignment Statement , Program
Comments and Docstrings . Data Types -Numericintegers&Floating-pointnumbers.
Boolean, string. Mathematical operators +, -*, ** , %. PEMDAS.Arithmetic
expressions , Mixed-ModeArithmetic and t ype Conversion, type( ). Input( ), print( ) ,
program c omments. id( ), int( ), str( ), float( ).
3.Loops and selection statements : Definite Iterati on: The for Loop, Executing
statementsagivennumber of times , Specifying the stepsusingrange( ), Loopsthat
countdown,Boolean and Comparison operators andExpressions ,Conditional and
alternative statements -Chained and Nested Conditionals: if, if -else, if-elif-else, nested
if, nested if -else.Compound Boolean Expressions , Conditional Iteration: The while
Loop –with True condition, the break Statemen t.Random Numbers . Loop Logic,
errors, and t esting.
Reference Fundamentals of Python First programs 2ndedition by Kenneth A Lambert
chapter 1,2,3
Unit III STRINGS, LIST AND DICTIONARIES. 15 LECTURES
1.Strings, Lists, Tuple, Dictionary : Accessing characters, indexing, slicing,
replacing.C oncatenation (+), Repetition (*).Searching a s ubstring with the ‘in’
Operator, Traversing string using while and for. String methods -find, join, split,
lower, upper. len( ).
2.Lists –Accessing and slicing, BasicOperations (Comparison, +) ,List membership and
for loop.Replacing element (list is mutable). List methods -append, extend, insert,
pop, sort. Max( ), min( ) . Tuples.
Dictionaries -Creating a Dictionary, Addingkeys andreplacing Values , dictionary -
key( ), value( ), get( ), pop( ) , Traversing a Dictionary.
Math module: sin(), cos(),exp(), sqrt(), constants -pi,e.
3.Design with functions : Defining Simple Functions -Parameters and Arguments,
the return Statement , tuple as return value .Boolean Functions .Defining a main
function. Defining and tracing recursive functions.
4.Exception handling : try-except.
Reference Fundamentals of Python First programs 2ndedition by Kenneth A Lambert
chapter 4,5,6.
Page 7
UNIT IV DOING MATH WITH PYTHON 15 LECTURES
1.Working with Numbers: Calculating the Factors of an Integer, Generating
Multiplication Tables , converting units of Measurement ,Finding the roots of a
Quadratic Equation
2.Algebra and Symbolic Math with SymPy: symbolic math using the SymPy
library.
Defining Sy mbols and Symbolic Operations, factorizing and expanding
expressions , Substituting in Values ,Converting strings to mathematical
expressions. Solvingequations, Solving Quadratic equations , Solving for one
variable interms ofothers, Solving a system of linearequations, Plotting using
SymPy , Plotting expressions input by the user, Plotting multiple f unctions .
Reference Doing math with Python by AmitSaha (Internet source) chapter 1, 4
Software –http://continuum.io/ downloads .Anaconda 3.x
References:
1.Programming withJava:APrimer4thEditionbyE.Balagurusamy, TataMcGraw
Hill.
2.JavaTheCompleteReference,8thEdition,HerbertSchildt,TataMcGrawHill
3.Fundamentals of Python First programs 2ndedition-Kenneth A Lambert ,Cengage
Learning India.
4.Doing Math with Python -AmitSaha, No starch ptress,
Additional References:
5.EricJendrock, JenniferBall, DCarsonandothers,TheJavaEE5Tutorial,
PearsonEducation,Third Edition,2003.
6.IvanBayRoss,WebEnabledCommercial Applications Development UsingJava2, BPB
Publications, RevisedEdition, 2006
7.JoeWigglesworth andPaulaMcMillan, JavaProgramming: Advanced Topics,
Thomson Course Technology(SPD),ThirdEdition,2004
8.TheJavaTutorials ofSunMicrosystems Inc.http://docs.oracle.com/javase/tutorial
9.Problem solving and Python programming -E. Balgurusamy, TataMcGrawHill.
Suggested Practical:
1.Writeaprogramthatdemonstrates theuseofinputfromtheuserusingparseInt().
2.WriteaJavaapplet todemonstrate graphics, FontandColorclasses.
3.WriteaJavaprogramtoillustrate AWTpackage.
4.Preparing investment report by calculating compound interest, computing
approximate value of by using the =1−+−+⋯(Gottfried Leibniz)
5.Convert decimal to binary, octal using string, Write the encrypted text of each of the
following words using a Caesar cipher with a distance value of 3.
6.Hexadecimal to binary using dictionary, finding median of list of numbers.
7.Enhanced Multiplication Table Generator, Unit Converter, Fraction Calculator .
8.Factor Finder, Graphical Equation Solver
9.Summing a Series, Solving Single -Variable Inequalities
Page 8
Theory:Attheendofthesemester,examination ofthree hours durationand100marksbasedonthe
fourunitsshallbeheldforeachcourse.
PatternofTheoryquestionpaperattheendofthesemesterforeachcourse: Thereshall
beFivecompulsory Questions of20markseachwithinternaloption. Question1 basedon
UnitI,Question2basedonUnitII,Question3basedonUnitIII, Question 4basedonUnitIV
andQuestion5basedonallfourUnitscombined.
Q1 to Q4 pattern
(a)Attempt a ny one out of two (08 Marks)
(b)Attempt any two out of four (12 Marks)
Q5Attempt any four out of eight (20 Marks)
Semester End Practical Examination (Total 100 marks)
Semester V: Total evaluation is of 100 marks ‐
(a)Question on Unit 1 and Unit 2 -40 Marks
(b)Question on Unit 3 and Unit 4 -40 Marks
(c)Certified Journal -10 Marks
(d)Viva Voce -10 Marks
Semester VI: Total evaluation is of 100 marks ‐
(a)Question on Unit 1 and Unit 2 -40 Marks
(b)Question on Unit 3 and Unit 4 -40 Marks
(c)Certified Journal -10 Marks
(d)Viva Voce -10 Marks
1.The questions to be asked in the practical examinat ion shall be from the list of
practicalexperiments mentioned inthepracticaltopics.Afewsimplemodifications maybe
expectedduringtheexamination.
2.Thesemesterendpracticalexamination onthemachinewillbeofTHREEhours.
3.Studentsshouldcarryacertifiedjournalwithminimumof06practicals(mentione dinthe
practicaltopics)atthetimeofexamination.
4.Numberofstudentsperbatchfortheregularpracticalshouldnotexceed20.Notmore
thantwo students areallowedtodopracticalexperiment ononecomputer atatime.
Workload
Theory :4 lectures per week .
Practicals: 2practicals eachof2lectureperiodsperweekperbatch.Twolectureperiodsofthe
practicals shallbeconducted insuccession togetheronasingleday.