Weekly Lecture Planner (2015-16)BSc-III

Class: BSc – III (Computer Science)Subject: Computer Science

Paper:A and B (Businessdata processing and data base management and Web Programming)

Month and Week / Topics
20 July – 25 July 2015 / Internet:Evolution of Internet, Future of Internet, Services provided on the Internet, Internet Access Methods. Database vs File Oriented Approach
27 July – 01 Aug 2015 / Advantages and Disadvantages of DBMS, Data models: Hierarchical, Network and Relational models
03 Aug – 08 Aug 2015 / World Wide Web:Evolution of www, Future of www, Fundamentals of web. Entity Relationship model.Test
10 Aug – 14 Aug 2015 / Client-Server Architecture, Distributed databases, Data Independence.
Assignment
17 Aug – 21 Aug 2015 / Installing Netscape Communicator :Browsing Internet using Netscape, Netscape Messenger
24 Aug – 31 Aug 2015 / Relational Algebra,Operations - union, intersection, difference,, Calculus.. Assignment
01 Sep – 04 Sep 2015 / Hypertext MarkupLanguage:Introduction to HTML, Building Blocks of HTML,HTML Lists, HTML Links
07 Sep – 12 Sep 2015 / Normalization, Storage Organization for Relations,Images in HTML.
14 Sep – 19 Sep 2015 / Advanced HTML:HTML Tables, Frames, Layers, Forms, and Editors. Assignment
21 Sep – 24 Sep 2015 / Cartesian product, projection, selection, division and relational algebra queries; House Test
05 Oct – 10 Oct 2015 / Cascading Style Sheets:Introduction to CSS, Limitation of HTML, CSS Positioning.
12 Oct – 17 Oct 2015 / Relational Calculus: Tuple oriented and domain oriented relational calculus and its operations, Normalization,
02 Nov – 07 Nov 2015 / Front Page:Installing Front Page, Front Page Editor, Create aSample Website, Frames in Front Page, Front Page Components, Forms, Database pages.
9 Nov – 14 Nov 2015 / Database Integrity, Security, Concurrency, Recovery.
Data Definition Language (DDL): Create, rename, truncate, alter and drop tables.
16 Nov – 21 Nov 2015 / Moving elements and images, changing colours and hiding elements, moving between layers, mouse rollovers.
23 Nov – 28 Nov 2015 / Data manipulation Language (DML): Insert, update and delete commands. Various forms of SELECT- simple, using special operators
6 Jan –10 Jan / Presentations. Java Scripting :Features, tokens, data types, variables, operators
11 Jan – 16 Jan 2016 / Control structs, strings, arrays, functions, core language objects, client side objects,event handling, application related to client side from validation.
18 Jan – 23 Jan 2016 / Aggregate functions, arithmetic functions, character functions, date functions, group by clause, Nested Queries, Joins.
25 Jan – 30 Jan 2016 / Fundamentals of Java Programming Language :Java vs. C++, bytecode, java virtual machine, constants, variables, data types, operators, expressions
01 Feb – 06 Feb 2016 / Introduction to VIEWs, Manipulating the Base table(s) through VIEWs, Rules of DML Statements on Join Views, Dropping a VIEW, Inline Views
08 Feb 13 Feb 2016 / Control structures, defining class, creatingobjects, accessing class members, constructors, method overloading.
15 Feb – 20 Feb 2016 / Materialized Views. Database Security and Privileges, GRANT Command, REVOKE Command, Application Privileges Management. Test
22 Feb – 27 Feb 2016 / Sequences, Introduction to INDEXES, Creating simple, unique and composite INDEX, dropping INDEX, COMMIT and ROLLBACK,
29 Feb – 6March 2016 / Backup and Recovery of the database. Revision , Test .