Lectures : 4 Periods/Week, Tutorial: 1 Continuous Assessment : 40
Final Exam : 3 hours Final Exam Marks : 60
Prerequisites: High Level Programming Languages, CS/IT 214 – Object-Oriented Programming using C++, and CS/IT 216 - Data Structures.
Course Objectives: In this course the student will
1. Develop an understanding of the nature of database-management systems (DBMSs), including their structure, design, and evaluation.
2. Develop an understanding of the relationship between DBMSs and the analysis of information systems in libraries and in business.
3. Develop an understanding of the distinctions among flat-file systems, network systems, hierarchical systems, relational systems, and text-oriented systems.
4. Develop an understanding of the process of normalization of relational databases.
5. Develop an understanding of the role of the Structured Query Language (SQL) standards in the current and future development of DBMSs.
6. Develop an understanding of management and social issues such as database security and privacy.
7. Acquire an introductory level of skill in the use of selected microcomputer database- management systems.
Course Outcomes:
On the completion of the course, the students will be able to:
1. Define a Database, characteristics and functions of Database Management System and types of Database Users.
2. Distinguish between a Traditional File System and a Database System.
3. Describe Data Models, Schemas, Instances, Three Schema Architecture and DBMS Component Modules.
4. Describe the Entity–Relationship (ER) modeling tool using Unified Modeling Language (UML).
5. Model the real world database systems using Entity Relationship Diagrams (ERD) from the requirements specification.
6. Define the Relational Data Model, its Constraints and the Relational Database Schemas. 7. Illustrate the Definition of Functional Dependencies , Inference Rules, Equivalence of Sets of
Functional Dependencies FDs, Minimal Sets of FDs.
8. List the three Normal Forms Based on Partial and Transitive Dependencies 9. Apply normalization techniques to normalize a database
10. Define the concept of Relational Algebra and the Relational Operations from Set Theory. 11. Design queries in Relational Algebra and Relational Calculus
12. Define disk storage devices, files of records, unordered files, ordered files and hashed files. 13. Demonstrate the use of SQL for database creation and maintenance
14. Use SQL queries for data aggregation, calculations, views, sub-queries, embedded queries, manipulation, and report generation.
15. Implement PL/SQL triggers, functions. Procedures and packages for ensuring data integrity and security.
Page 115 of 115 Department of Information Technology
• The Relational Data Model and Relational Database Constraints
• The Relational Algebra and Relational Calculus
• SQL-99: Schema Definition, Constraints, Queries, and Views
• Disk Storage, Basic File Structures
• Functional Dependencies and Normalization for Relational Databases
• Relational Database Design Algorithms and Further Dependencies
• Introduction to Transaction Processing Concepts and Theory
• Concurrency Control Techniques
• Database Recovery Techniques
• Database Security Reference Books:
1. “Introduction to Database Systems”, C.J.Date Pearson Education.
2. “Data Base Management Systems”, Raghurama Krishnan, Johannes Gehrke, TATAMcGrawHill, 3rdEdition.
RELATIONSHIP OF COURSE OUTCOMES TO PROGRAM OUTCOMES FOR DEPARTMENT OF INFORMATION TECHNOLOGY
S.No Program Out Comes None Low High
a.
Demonstrate an ability to apply the knowledge of Mathematics, Computer Science and Engineering appropriate to the development of software systems to solve real world problems.
b.
Demonstrate an ability to analyze a problem and design a computing system or a component or a process confirming to standards using various methodologies and architectures.
c.
Be able to analyze and understand an existing software & hardware system and extend the system to meet evolving requirements.
d.
Demonstrate an ability to implement and test a computing system or a component or a process, to evaluate and compare efficiencies of alternative solutions.
e.
Demonstrate an understanding of the emerging technologies and a working knowledge of software and hardware tools.
f.
Be able to interact professionally with peers and clients with diverse cultures and medium of communication located in geographically dispersed locations in the context of computing and software engineering.
g.
Have the knowledge of professional and ethical
responsibilities in the corporate sector and be aware of contemporary issues.
h. Demonstrate the ability to communicate effectively in both
verbal and written form. i.
Have an ability to analyze the social and human context of computing and be aware of contemporary issues.
j.
Recognize the need for continuing education, research and professional development.
k.
Possess the knowledge and skills for employability and to succeed in national and international level competitive examinations.
Page 117 of 117 Department of Information Technology WEB TECHNOLOGIES
CS/IT 316
Lectures : 4 Periods/Week, Tutorial: 1 Continuous Assessment : 40
Final Exam : 3 hours Final Exam Marks : 60
Prerequisites: Introduction to the Internet,CS/IT216 - Data Structures. Course Objectives:
1. To describe the basic infrastructure and architecture of the Internet, including the main protocols.
2. To use tools to query parts of the Internet infrastructure including name servers, individual machines, and web sites.
3. To list and describe contemporary Internet applications, their purpose, internal architectures, and related security, commercial and social issues.
4. To design and to develop simple database driven web applications using a server-side scripting language.
5. Given a screen shot or access to a web application, students will be able to apply for appropriate techniques and principals to evaluate its usability and accessibility.
Course Outcomes:
After the completion of the course the student will
1. Understand the need for and be able to write validated XHTML 1.0.
2. Understand the principles of W3C WCAG 1.0 (as a minimum) and be able to write compliant XHTML documents.
3. Understand and be able to apply sound, non-browser specific web design principles.
4. Understand and be able to use Javascript to access the DOM to reference web document object CSS properties.
5. Understand the application of XHTML for document structure and content. 6. Understand and apply CSS definitions for document presentation.
7. Understand and apply Javascript, CSS & XHTML to create dynamic XHTML. 8. Be aware of emerging technologies and developing W3C recommendations.
Topics:
• Introduction to XHTML
• Cascading Style Sheets (CSS)
• JavaScript
• Dynamic HTML
• Building Ajax
• Servlets and Java Server Pages. Reference Books:
1. Jason Cranford Teague, “Visual Quick Start Guide CSS, DHTML &AJAX”, 4e, Pearson Education.
2. Tom NerinoDoli smith, “JavaScript & AJAX for the web”, Pearson Education 2007. 3. Joshua Elchorn, “Understanding AJAX”, Prentice Hall 2006.
4. Hal Fulton, “The Ruby Way”, 2e, Pearson Education 2007. 5. David A. Black, “Ruby for rails”, Dreamtech Press 2006.
6. Marty Hall, Larry Brown, “Core Servlets and JavaServer Pages™: Volume 1: Core Technologies”,2nd Edition, Prentice Hall.
Page 119 of 119 Department of Information Technology RELATIONSHIP OF COURSE OUTCOMES TO PROGRAM OUTCOMES FOR
DEPARTMENT OF INFORMATION TECHNOLOGY
S.No Program Out Comes None Low High
a.
Demonstrate an ability to apply the knowledge of Mathematics, Computer Science and Engineering appropriate to the development of software systems to solve real world problems.
b.
Demonstrate an ability to analyze a problem and design a computing system or a component or a process confirming to standards using various methodologies and architectures.
c.
Be able to analyze and understand an existing software & hardware system and extend the system to meet evolving requirements.
d.
Demonstrate an ability to implement and test a computing system or a component or a process, to evaluate and compare efficiencies of alternative solutions.
e.
Demonstrate an understanding of the emerging technologies and a working knowledge of software and hardware tools.
f.
Be able to interact professionally with peers and clients with diverse cultures and medium of communication located in geographically dispersed locations in the context of computing and software engineering.
g.
Have the knowledge of professional and ethical
responsibilities in the corporate sector and be aware of contemporary issues.
h. Demonstrate the ability to communicate effectively in both
verbal and written form. i.
Have an ability to analyze the social and human context of computing and be aware of contemporary issues.
j.
Recognize the need for continuing education, research and professional development.
k.
Possess the knowledge and skills for employability and to succeed in national and international level competitive examinations.
SOFT SKILLS LAB