MBNS675

Session NO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

SOFTWARE ENGINEERING AND PROJECT MANAGEMENT

L

T

P

C

2

0

0

2

Topic to be covered

Book Number

Page Number

Software Characteristics Software Engineering Engineering Phases Process Framework Process Models Case analysis -selecting a model Requirements Requirements Analysis Requirements Management modeling SRS Case Design concepts Design model Testing Testing Model The art of debugging Case analysis Web engineering applications Web engg layers Design for web applications Metrics Design metrics for web applications Case analysis Project management CMM Component based development Business process reengineering The economics of reengineeering Case analysis

B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1 B1

2-7 8-9 9-11 22-25 33-48 49,106 60-65 72-81 100-104 127 91-95 179 119-121 127-128 208-213 221-237 260-262 267 507-506 503 507 314 316 411 335-340 364 502 485-488 484 491

Text Book: B1- Rohit Khurana , Software Engineering : Principles & Practices Ed.2, Vikas Publishing House Pvt Ltd, 2011

MBNS681

DATABASE MANAGEMENT SYSTEM

Periods

1,2

1,2 1 1 1 1, 2 1 1 1, 2

L 2

T 0

P 0

Topics

Introduction Data, Information, Data Management, File based Data management, Database System, Comparison between Database System and File Processing System. Database Management System – Benefits, Functions, Components, Data Dictionary – Types, Benefits. Database Users, Administrator, Designer, End-user, System Administrator, Security Officer, Network Administrator. Database Architecture – Meaning of Data Abstraction, Levels of Architecture. Case Study 1 – Mountain view community hospital Data Models – ER Model, Hierarchical Model, Relational Model, Object Oriented Model –Advantages and Disadvantages of each Model. Relational Database Model Case Study 2 –Developing ER diagram for Tiny College.

1, 2

ER Model Diagram – Introduction, Components, Entity, Attribute Types, Entity Identifier, Attribute Domain, Relationship, Degree, Connectivity, Cardinality, Dependency, Composite Entities, ER Diagram Symbol Normalization – 1 NF, 2 NF, 3 NF, BC – NF, 5 NF

1

Case Study 3– Data Normalization for a construction company

1,2

1

Relational Operators – Select, Project, Union, Intersection, Different, Join, Update Operation Structured Query Language – Types of SQL Command – DDL, DML, DCL, DQL, SQL Operators Case Study 4 – SQL Commands-The Internet Store

1,2

Queries and Sub Queries

1, 2

Transaction Management and Concurrency Control

1, 2

Data Ware Housing – Data Mart

1, 2

Data Mining and OLAP, Object Oriented Database

1,2

Case Study-5-Maximizing the value of cost interaction

1

C 2

Reference MaterialPage N0 P1-1-10

P1-11-17 P1-18-22 P1-28-35 R1-49-51 P1-43-58 P1-98-110 R3-124129 P1-61-78

P1-125151 R3146160 P1-156167 P1-179195 R2226227 P1-236254 P1-429453 P1-569574 P1-522536 R4-441443

Prescribed Book P1-Fundementals of Database Management systems by Alexis Leon, Mathew leon, Mcgrawhill Learning, Second print,2010. Reference books R1-Jeffrey A Hoffer- Modern Database Management Systems-Tenth Edision. R2-Raghu Ramakrishnan-Database Management Systems-Mcgrawhill-Third Edision R4-Peter Rob-Database System Concepts-Cengage Publication-2008. R4- Mahadeo Jaiswal-MIS-Oxford Publications-2005

J.Dinesh Course Co-ordinator

Dr. T. Vijay Kumar Head-Systems

Dr. Jayshree Suresh Dean

MBNS658

SECURITY AND COMPUTER NETWORKS

S.No Topic 1. Introduction of data , Fundamentals of Data Communication communication 2. Basic Terminology – Digital Vs Analog signal 3. Types of communication modes Transmission media – Bounded media Vs unbounded media – satellite Communication 4. Networking Fundamentals 5. LAN – WAN – MAN 6. Network Topology 7. Baseband Vs Broadband 8. Repeaters – Bridges - Routers – Switches 9. Virtual LAN 10 OSI Model & TCP/IP Suite - seven layer protocol suite 11 UDP Vs TCP 12 Data Transmission Networks 13 ISDN - ATM 14 Wireless Mobile Communication 15 Basic Concept of GSM Networks 16 Fiber optics Communications 17 Types of Optical Transmission modes 18 Security – Firewalls Intrusion Detection Systems (IDS) 19 Virtual Private Network (VPN) 20 Internet Architecture – ARPAnet – Ethernet –Telnet – SMTP - FTP

L 2

T 0

P 0

C 2

Periods Page No 1,2 1-10

Unit I

Book No B1

3,4

10-28

I

B1

5,6

29-54

I

B1

7 8 9 10 11

106 - 130 144 – 205 206 – 236 146 - 148 165 - 174

II II II II II

B1 B1 B1 B1 B1

12 13

175 - 177 211 - 217

II III

B1 B1

14 15, 16

225 - 230 238-270

III III

B1 B1

17, 18 19 20,21 22

251 - 268 271 - 273 273 - 292 297- 299

III IV IV IV

B1 B1 B1 B1

23,24 25, 26

300 - 310 312 - 333

IV V

B1 B1

27,28 29,30

334 - 350 356 - 367

V V

B1 B1

Reference Books Reference Books: B1. Rajneesh Agrawal & Bharat Bhushan Tiwari "Data Communication & Computer Networks", Vikas Publishing House Pvt Ltd, 2007 Edition B2. Kuldeep singh Kohar “ Network Security”, Vayu Educational of India, First Edition

(2009) B3. Dietor Gollmann," Computer Security", Willey India, Second Edition (2008) B4. Michael E. Whitman and Herbert J. Mattoro, "Principles of Information Security", Thomson Course technology, second edition (2007)

INTERNAL EVALUATION: Project Presentation/Case Study Analysis Project Report/Case Study Analysis 2 Cycle test Surprise test Attendance Model exam

Subject Coordinator (Ms.S.Thanalakshmi)

Head/Systems (Dr.T.Vijayakumar)

1

- 10 - 10 - 10 - 05 - 05 - 10

Dean (Dr.Jayshree Suresh)

MBNS660

WEB DESIGNING

S.No

Topics

1

Introduction to web page advantages

2

Current design trends – Visual appeal – Utilitarian design –Interactivity –Multimedia elements

L 2

T 0

Reference material page no. T1 / 1-5 & Study material

P 0

C 2

Periods 2 2

T1/ 3 – 9

Analyzing content, graphics and audience understand web design application programs. Editors – convertor –Generators

T1/ 10-22

4

Web design application programs Designing interactive nonlinear structure

T1/ 25-36

2

5

Case discussion

Study Material

2

6

Designing for effective content and efficient delivery –Converting between data rate and bandwidth –Bandwidth Dilemma

T1/ 37-44

2

7

Web browser –dealing with design constraints

T1/ 53-61

2

T1/ 63-74

2

-Physical and logical text styles -Working with images –Working with Anchors

T1/ 75-82

2

10

Design with tables -Table Attributes, Align, Valign, Boarder span, width, Rules.

T1/ 85-112

2

11

Using text in tables -HTML text –level Tags –Formatting text with HTML text –Linking Table text.

T1/ 115-135

2

12

Using graphics in tables

T1/ 137-144

2

3

8

9

HTML Tags - The basics of a document - Importance Block elements - Formatting web page

2

–Create a graphical table -Combing graphics and text. 13

Advanced Graphics Techniques -Characteristics of vector graphics -Utilizing Bitmap graphics -Color differences –Formats and conversion issues – Layered web page and other effects

T1/ 215-279

2

14

Multimedia Techniques -Sampling digital audio -Animating your web -Integrating multimedia in your pages.

T1/ 281

2

15

Case Discussion

Study Material

2

Text Book: 1. James L.Mohler, Jon M.Duff, “Designing interactive web site”. DELMAR CENGAGE Learning, 2000. Reference Books: 1. Paul awing sanda.S.katila, “Introduction to web design and programming”, Thomson, 2009 2. D.P.Nagpal, “Web Design Technology”,S.Chand, 2009. 3. Thomas A.Powell, “Web design: The Complte reference”, McGraw-hill, August 2002. 4. Deital and Deital, Goldberg “Internet & World Wide Web”, Third edition, pearson education,2004.

(Mr.S.Chandran) Course coordinator

(Dr.T.Vijayakumar) Head-Systems

(Dr.Jayshreesuresh) Dean-MBA