SEMESTER III
MCA 301: DATA BASE
MANAGEMENT SYSTEMS
UNIT 1 : Introduction, :Database- System
Application -Purpose ol' Database Systems-
View of Data-Database Languages-Relational
Data bases-Database Design-Object-
Based and Semistructred Databases-Data
Storage and Querying-Transaction anagement-
Data Mining and Analysis-Database
Architecture. Entity-Relationship model.: Structure of
Relational Databases-. Relational Algebra
Operations-Modification of the Database. SQL :
Data Deilnition- Structure of SQL Queries-
Set Operations- Aggregate Functions- Nested
Subqueries- Complex Queries -SQL Data Types
and Schcmas- Integrity Constraints-
Authorization-Embedded SQL- Dynamic SQL
UNIT II : The Entity-Relationship Model-
Constraints- Entity- Relationship Diagrams,
Design Issue- Weak Entity Sets- Database
Design for Banking Enterprise - The Unified
Modeling Language UML- Features of Good
Relational Designs- Atomic Domains and
Normal Forms- Database-Design Proces-
Modeling Temporal Data- User Interfaces and
Tools- .Web interfaces to Databases- Web
Fundamentals- Servlets and JSP-Building
Large Web Applications- Triggers-
Authorization in SQL.
UNIT III OBJECT-BASED DATABASES AND XML:
Complex Data Types-Structured
Types and Inheritance in SQL- Table Inheritance-
Array and Multiset Types in SQLObject-
Identity and Reference Types in SQL-
Implementing O-R Features-Persistent
Programming Languages - Object-Oriented
versus, Object-Relational- Structure of XML
Data- XML Document Schema- Querying and
Transformation-Application Program
Interfaces to XML- Storage of XML Data.
UNIT IV : Query Processing : Measures of
Query Cost- Selection Operation- Sorting- Join
Operation-Evaluation of Expressions- Query
Optimization.: Transformation of Relational
Expressions- Estimating Statistics of
Expression Results-Choice of Evaluation Plans.
L'NIT V : Transactions : Transaction
Concept.Transaction State- Implementation of
Atomicity and [)urabiitiy- Concurrent
Executions- Seriali/abiliu- Recovcrabiiil) -
Implementation of Isolation- I esting for
SerializabiHty, Concurrency (Control: Lock
Based Protocols- 'I imestamp-Based Protocols-
Validation-Based Protocols- Multiple
Granularity- Multiversion Schemes- Deadlock
handling- insert and Delete Operations-
Weak Levels of Consistency- Concurrency in
Index Structures. Recovery System:
Failure Classifieation-Storage Structure-
Recovery and Atomicii}- Log-Based Recover)-
Recover) with Concurrent Transactions-Buffer
Management- Failure with loss of
Nonvolatile Storage- Advanced Rcco\er>
Techniques-Remote Backup Systems.
Text Book:
1. Silbcrschatz A, Korlh H F, and Sudarsan S,
Database System Concepts. 51h edition,
McGraw-HilK
2002. (Chapters 1 to 4. 6 to 10 and 13 to 17)
Reference Books:
1. Date C 3, An Introduction to Database Systems,
7Ih edition, Pearson Education, 2000.
2. Elmasri R, and Navathe S B,
Fundamentals'of Database Systems, 4th edition,
Pearson Education, 2004.
3. Ramakrishnan R, and Gehrke J. Database
Management Systems, 2nd edition,
McGra\v-Hill, 2000.
4. Mannino M V, Database Application
Development and Design, McGnm-Hiil. 2001.
SRI VE_KATESWARA U_IVERSITY :: TIRUPATI
www.vsuniversity.in
MCA 302: DATA
COMMUNICATIONS AND COMPUTER NETWORKS
UNIT I : Introduction, Network
models - Internet model, OSI model. Physical Layer Signals
- Analog, Digital, Digital Transmission
-Coding, Sampling, Analog Transmission -
Modulation of digital and analog signals.
Telephone modem, Multiplexing - FDM, WDM,
TDM, Transmission Media - cable, wireless,
Circuit switching and Telephone network,
DSL Technology, Cable modem, SONET,
UNIT II : DataLjnk_Layer Error
detection and correction, Data link control and Protocols -
Stop and wait. Go-back-n, Selective repeat,
HDLC, Point to point access, Channelization,
LANS - Traditional Ethernet, Fast Ethernet,
Gigabit Ethernet, Wireless LAN's - IEEE
802.11, Blue tooth. Connecting EANs -
Connecting devices, Backbone networks, Virtual
EANS, Cellular telephony, Satellite networks.
Virtual circuit switching, Frame relay, ATM.
UNIT HI Network Layer: Inter-networks,
Addressing, .Routing, Network layer Protocols -
ARP. IP, ICMP, IPv6, Routing - Introduction,
Unicast routing, Protocols - RIP, OSPF.
BGP, Multicast Routing. Protocols -DVMRP,
MOSPF. CBT, PIM.
UNIT IV Transport Eayer: Process-
to- Process delivery, UDP, TCP, Data traffic,
Congestion and Control, Quality of service
(QOS) and techniques to improve QOS,
Integrated services, QOS in Switched
networks. Security:, Introduction, Symmetric- key
cryptography, Public key cryptography.
Message security, Digital signature, User
authentication, Key management, Kerberos, IP
level security: IPSEC. Transport layer
security, Application layer security: PGP,
Firewalls, Virtual private networks.
UNIT V Application Layer: Client-
Server model, Socket interface, Introduction to DNS,
Distribution of name space, DNS in the
Internet, Resolution, DDNS, Electronic mail,
SMTP, File Transfer, FTP, HTFP, World Wide
Web, Multimedia fundamentals, Digitizing
and compression of audio and video. Streaming
audio/video - stored and live, Rea! time
interactive audio/video, Voice over IP.
Text Books:
1. Forouzan B A. Data Communications and
Networking, 4* edition, Tata McGraw-Hill.
2007.
2. Tanenbaum A S, Computer Networks, 4th edition, Pearson
Education, 2003.
Reference Books:
1. Stallings W, Data and Computer
Communications, 7lh edition, Pearson Education.
2004.
2. Gallo M A, and Hancock W M, Computer
Communications and Networking
Technologies, Thomson Brooks/Cole, 2002.
3. Comer D E, Computer Networks - and
Internets with Internet Applications, 4* edition,
Pearson Education, 2004.
4. Kurose .1 F, and Ross K W, ('ompuler
Networking . I top-down Approach I t-iituring
the Internet. Pearson Education, 2001.
5. Tomasi W, Introduction to Data
Communications and \<.'working, Pcarson Education,
2004.
SRI VE_KATESWARA U_IVERSITY :: TIRUPATI
www.vsuniversity.in
MCA 303: SOFTWARE
ENGINEERING
Unit - 1 Software
Engineering - Introduction, Generic view of process, process models, an
agile view of process. Software Engineering
practice - Software Engineering,
communication, planning, modeling,
construction practices and deployment.
Unit - II System
Engineering - Computer-based systems, the system engineering
Hierarchy, business process engineering,
product engineering and system modeling-
Requirement engineering - Requirement
Engineering task, initiation, eliciting, developing
use-cases- Building the analysis model -
Requirement analysis, modeling approaches,
data modeling concept, object-oriented
analysis. Scenario-based flow-oriented, class
based modeling. Behavioral model. The ueb
engineering process, analysis models for
web apps.
Unit - [II Design
Engineering - Design process and quality, design concepts the design
model, and pattern-based software design.
Architectural design - Software architecture,
data design, architectural styles and
patterns, architectural design mapping data flow into
a software architecture. Component-level
design -component, designing class-based
components, conducting component-level
design, object-constraint language, and design
conventional components. Interface design -
Design steps, web apps design issues and
architecture design.
Unit - IV Testing
strategies - Strategies and issues, testing strategies for and objectoriented
software. Validation testing and system
testing. Software testing tactics -
Fundamentals, black-box and white-box
testing, white-box testing basis path testing.
Control structure testing, black-box testing,
object-oriented testing methods. Testing
methods applicable at the class level. Inter
class testing case design. Testing for
specialized environments, architectures and
applications, web application testing -
concepts, testing process, component level
testing.
Unit - V Product metrics
- Software quality, framework, metrics for analysis model, design
model, source case and testing. Managing
software projects - The management
spectrum, the w5 HH principle, metrics in
process, software measurement, metrics for
software quality integrating metriccs within
the software process. Estimation -
observations, decomposition techniques,
empirical models, estimation for object-oriented
projects other estimation techniques, project
scheduling, risk management, quality
management, reengineering, change management,
component-based development,
TEXT BOOK:
1. Roger, S., Pressman, Software Engineering,
A Practitioner's Approach, Six Edition,
McGraw-Hill, International Edition, 2005.
REFERENCE BOKKS :
1. James F Peters, Software Engineering.
John Wiley
2. lan Sommerville, Software Engineering,
Pearson Education, 6lh Edition.
3. Waman S Jawadekar, Software Engineering,
Tata McGraw Hill, 2004.
4. Carlo Ghezzi, Mehdi Jazayen, Dino Manrioli,
Fundamentals of Software Engineering,
PHI,2001
5. Pankaj Jalote, An Integrated approach to
Software Engineering, Narosa.
SRI VE_KATESWARA U_IVERSITY :: TIRUPATI
www.vsuniversity.in
MCA 304: DESIGN AND
ANALYSIS OF ALGORITHMS UNIT I: Divide - and - Conquer
and Greedy Methods.
UNIT II: Dynamic Programming; Basic
Traversal and Search Technique.
UNIT III: Backtracking; and Branch-and
Bound Technique.
UNIT IV: Louer bound Theory:
NP-Hard and NP-Complete Problems. UNIT V: Mesh and
Hypercube Algorithms. TEXT BOOK:
1. Eiiis llorowitz, Sartaj Sahni and
Sanguthevar Rajasekaran,Computer
Algorithms. Galgotia Publications,1999.
REFERENCE BOOKS:
1. RCT Lee, SS Teang, RC Chang and YT Tsai,
Introdution to the Desigh and Analysis
of Algorithms, McGraw-Hill 2005
2. R Jhonsonbaugh and Mschaefer. Algorithms,
Pearson education 2004
3. A.Levitin, Intorduction to the Design and
Analysis of Algorithms,Pearson
Education,2005
4. TH Coremen,CE Leiserson and Ri, Ri\
^.Introduction to Algorithms,PHI
5. GBrassadand P Bratley, Fundamentals of
Algorithms, PHI
SRI VE_KATESWARA U_IVERSITY :: TIRUPATI
www.vsuniversity.in
MCA 305: TECHNICAL
COMMUNICATION AND COMPUTER ETHICS
UNIT I : Phonetics and Spoken
English - The Phonemes, The Syllable, Prosodic Features,
The Sounds of English - Vowels and
Consonants, Word Accent, Features of Connected
Speech. Pronunciation, Spelling, Suggestions
for improvement of Indian English. Effective
Speaking - Oral Presentations. Listening
Comprehension. Reading Comprehension.
UNIT II: Introduction to Technical
Writing - Objective of technical writing, Audience
Recognition and Involvement, Preparation of
Resume. Techniques for writing effective Email,
Writing User Manuals, Writing Technical
Reports and Summaries.
UNIT III introduction to Computer Ethics -
Policy vacuum. Moral and Legal issues.
Computer Ethics. Professional Ethics -
Characteristics of" professions. Conflicting
Responsibilities, Code of Ethics and
Professional conduct. Philosophical Ethics - Ethical
Relativism, Utilitarianism, Rights,
Individual and Social Policy Ethics.
UNIT IV . :Ethics Online - Hacking
and Hacker Ethics, Computer Crime, Netiquette.
Privacy -Computers and Privacy issue,
Proposals for better Privacy Protection. Property
Rights in Computer Software - Current Legal
Protection, Software Piracy. The Moral
question.
UNITV: Accountability - Buying
and Selling Software, Accountability issues. Social
Implications and Social values - Technology
and Social Change, Democratic values in the
Internet, Freedom of Speech, Future issues.
The Rights and Responsibilities of Engineers
- Professional Responsibilities, Ethics, and
Rights. Ethics in Research and
Experimentation
Text Books:
1.Gerson S J, and Gerson S M, Technical
Writing - Process and Product, 3rd edition,
Pearson Education Asia, 2001.
2.Johnson D G, Computer Ethics, 3rd edition. Pearson Education
Asia, 2001.
3.Bansal R K, and Harrison J B, Spoken
English, 2nd edition, Orient Longman, 1994.
4.Fleddermann C B, Engineering Ethics, 2nd edition, Pearson
Education, 2004.
Reference Books:
1.Krishna Mohan, and Meenakshi Raman,
Effective English Communication, Tata
McGraw-Hill, 2000.
2.Martin M W, and Schinzinger R, Ethics in
Engineering, 3rd edition, Tata McGraw-Hill,
1996.
3.Division of Humanities and Social Sciences,
Anna University, English for
Engineers and Technologists, Vols. 1 and 2, 2nd edition, Orient Longman,
2002.
4.NIIT, Ethics and Security Management on the
Web, Prenticc-I lall of India, 2003.
5.Rutherfoord A J, Basic Communication Skills
for Technology, 2" edition, Pearson
Education Asia, 2001.
6.Ja\anthi Dukshina Murthy. Contemporary
English Grammar. Book Palace, Delhi. I W8.
y.Homhy A S. Parn\vcll \l C, An English
Reader's Dictionary, Oxford University Press,
2001 S.Rogct M R. and Roget J L, Roger's
Thesaurus of Synonyms & Antonyms, W R
Goyal Publishers and Distributors. Delhi.
2004.
9.Nurnberg M, and Rosenblum M, How to
Build a Better Vocabulary. Warner Books.
1989.
10. Paul V. Anderson. Techical Communication,
Thomson, 5th Ldhion, 2004,
No comments:
Post a Comment