MCAL301: Database Management Systems and Software Testing Lab Syllabus for MCA 3rd Sem 2017 Pattern Mumbai University

Database Management Systems and Software Testing Lab detailed Syllabus Scheme for Master of Computer Applications (MCA), 2017 regulation has been taken from the University of Mumbai official website and presented for the MCA students. For Course Code, Course Title, Test 1, Test 2, Avg, End Sem Exam, Team Work, Practical, Oral, Total, and other information, do visit full semester subjects post given below.

For all other Mumbai University MCA 3rd Sem Syllabus 2017 Pattern, do visit MCA 3rd Sem 2017 Pattern Scheme. The detailed Syllabus Scheme for database management systems and software testing lab is as follows.

MCAL301: Database Management Systems and Software Testing Lab Syllabus for MCA 3rd Sem 2017 Pattern Mumbai University

Prerequisites:

Basic Knowledge of SQL and Software Engineering concepts

Course Educational Objectives (CEO):

At the end of the course, the students will be able to

1. Make the students understand basic and relatively advanced issues in modern database management, information storage and retrieval.
2. Study various database techniques in developing data-intensive applications.
3. Explore the need of software testing in current industry scenario, understanding and knowledge of foundations, techniques and tools in area of software.
4. Understand the essential characteristics requirements and usage of Automation tools.

Course Outcomes:

At the end of the course, the students will be able to

1. Design database systems using available tools.
2. Develop applications using basic and modern database techniques as per organization requirements.
3. Demonstrate software testing tools
4. Create test design documents and test reports

1. DDL and DML

Data Definition Language: Create, Alter, Drop, Rename, Truncate Data Manipulation Language: Insert, Update, Delete, Select Constraints Not Null, Unique Key, Primary Key, Foreign Key, Check, adding and Dropping a Constraint 02

2. Data Control Language and Transaction Control

Grant, Revoke, Roles Commit, Rollback 02

3. SQL SELECT Statements

Column Alias, Concatenation Operator, Arithmetic Operators, ComparisonConditions, Logical Conditions, ORDER BY Clause 04

4. Functions And Subquery

Single Row Functions, Character Functions, Number Functions, Date Functions, Conversion Functions, Aggregate functions Subquery: Types of Subquery, Group by and Having Clause 06

5. Joins and other concepts

Equijoins, Non-Equijoins, Self Joins, Left Outer Joins, Right Outer Joins, Full Outer Joins, Natural Joins Other Concepts: View, Index 06

6. PL/SQL Practical Programming:

Variables, Identifiers, Comment, PL/SQL Block Structure IF Statements: Simple IF Statements, Compound IF Statements IF-THEN-ELSE Statements Loop: Basic Loop, WHILE Loop, FOR Loop 06

7. Cursor and Trigger

Cursor: Types of Cursor, Explicit Cursor Attributes Trigger: Trigger, Statement Trigger, Row Trigger, Using Conditional Operations. 06

8. Functions, Procedures and packages

Create Function, Function with Arguments, Executing Function, Dropping Function Procedures: Block Structure of Subprogram, Types of Subprograms, Procedurewith Parameters, Executing Procedures, Dropping Procedures Packages: Package Specification, Package Body, Creating Package, Execution,Dropping Package 06

9. Parallel and distributed database

Implementation of different types of Partitions: Range, Hash, List. Distributed Database: Horizontal, Vertical fragmentation 04

10. Object Oriented database

Implementation ofAbstract Data Type, Inheritance, Reference 04

11. Manual Testing

• Study of Reviews (Writing Test cases, Testing Framework, Test Document)
• Construction of CFG & Deriving Test Cases
• Implementation of Test Cases using Unit Testing, Integration & System Testing 04

12. Manual Testing

• Implementation of Test Cases using Equivalence Class Partitioning, Boundary Value Analysis.
• State Transition Test, Cause Effect Graphing and Decision Table Technique. 04

13. Automation Testing

• Study of Automation Tools.
• Building Test Cases.
• Using Base URL to Run Test Cases in Different Domains 06

14. Automation Testing

• Selenium commands-selenese
• Matching Text Patterns
• Performance Testing Concepts :Load Testing, Stress Testing 06

15. Automation Testing

• Web Driver Implicit & Explicit Wait
• Cross Browser Testing
• API Testing 06

Note: Automation software testing practicals can be performed using open source tool like selenium.

Reference Books:

• Joel Murach, Murachs oracle PL /SQLJoel Murachs publication Murachs and Assocites
• Sharnam shah, Vaishali Shah, Oracle for ProfessionalsPublication SPD-Shroff Publishers and Distributors 2011
• RiniChakrabarti, ShilbhadraDasgupta, KLSI, Advanced Data Base Management System Publication DreamTech
• Chakravarti /Advance Data Base Management System, Wiley -Dreamtech
• RajshekharSundaram, Oracle 10g Programming: A Premier, Publication Pearson Education 2009
• Peter Rob and Coronel, Database Principals fundamentals of Design, Implementation and Management, Publication Cengage Learning 2011.

For detail syllabus of all other subjects of Master of Computer Applications (MCA), 2017 regulation do visit MCA 3rd Sem Subjects syllabus for 2017 regulation.