{"id":10787,"date":"2020-08-23T17:04:12","date_gmt":"2020-08-23T17:04:12","guid":{"rendered":"https:\/\/www.inspirenignite.com\/mh\/mcal301-database-management-systems-and-software-testing-lab-syllabus-for-mca-3rd-sem-2017-pattern-mumbai-university\/"},"modified":"2020-08-23T17:04:12","modified_gmt":"2020-08-23T17:04:12","slug":"mcal301-database-management-systems-and-software-testing-lab-syllabus-for-mca-3rd-sem-2017-pattern-mumbai-university","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/mh\/mcal301-database-management-systems-and-software-testing-lab-syllabus-for-mca-3rd-sem-2017-pattern-mumbai-university\/","title":{"rendered":"MCAL301: Database Management Systems and Software Testing Lab Syllabus for MCA 3rd Sem 2017 Pattern Mumbai University"},"content":{"rendered":"<p align=\"justify\">Database Management Systems and Software Testing Lab detailed Syllabus Scheme for Master of Computer Applications (MCA), 2017 regulation has been taken from the <a href=\"https:\/\/mu.ac.in\/syllabus\" style=\"color: inherit\" target=\"_blank\" rel=\"noopener\">University of Mumbai<\/a> 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. <\/p>\n<p align=\"justify\">For all other Mumbai University MCA 3rd Sem Syllabus 2017 Pattern, do visit <a href=\"..\/mumbai-university-mca-3rd-sem-syllabus-2017-pattern\">MCA 3rd Sem 2017 Pattern Scheme<\/a>. The detailed Syllabus Scheme for database management systems and software testing lab is as follows.<\/p>\n<h2 align=\"center\">MCAL301: Database Management Systems and Software Testing Lab Syllabus for MCA 3rd Sem 2017 Pattern Mumbai University<\/h2>\n<p>  <title>Database Management systems and Software Testing Lab<\/title><\/p>\n<h4>Prerequisites:<\/h4>\n<p align=\"justify\">\nBasic Knowledge of SQL and Software Engineering concepts<\/p>\n<h4>Course Educational Objectives (CEO):<\/h4>\n<p align=\"justify\">\nAt the end of the course, the students will be able to<\/p>\n<ol>\n<li>Make the students understand basic and relatively advanced issues in modern database management, information storage and retrieval.<\/li>\n<li>Study various database techniques in developing data-intensive applications.<\/li>\n<li>Explore the need of software testing in current industry scenario, understanding and knowledge of foundations, techniques and tools in area of software.<\/li>\n<li>Understand the essential characteristics requirements and usage of Automation tools.<\/li>\n<\/ol>\n<h4>Course Outcomes:<\/h4>\n<p align=\"justify\">\nAt the end of the course, the students will be able to<\/p>\n<ol>\n<li>Design database systems using available tools.<\/li>\n<li>Develop applications using basic and modern database techniques as per organization requirements.<\/li>\n<li>Demonstrate software testing tools<\/li>\n<li>Create test design documents and test reports<\/li>\n<\/ol>\n<h4>1. DDL and DML<\/h4>\n<p align=\"justify\">\nData 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<\/p>\n<h4>2. Data Control Language and Transaction Control<\/h4>\n<p align=\"justify\">\nGrant, Revoke, Roles Commit, Rollback 02<\/p>\n<h4>3. SQL SELECT Statements<\/h4>\n<p align=\"justify\">\nColumn Alias, Concatenation Operator, Arithmetic Operators, ComparisonConditions, Logical Conditions, ORDER BY Clause 04<\/p>\n<h4>4. Functions And Subquery<\/h4>\n<p align=\"justify\">\nSingle Row Functions, Character Functions, Number Functions, Date Functions, Conversion Functions, Aggregate functions Subquery: Types of Subquery, Group by and Having Clause 06<\/p>\n<h4>5. Joins and other concepts<\/h4>\n<p align=\"justify\">\nEquijoins, Non-Equijoins, Self Joins, Left Outer Joins, Right Outer Joins, Full Outer Joins, Natural Joins Other Concepts: View, Index 06<\/p>\n<h4>6. PL\/SQL Practical Programming:<\/h4>\n<p align=\"justify\">\nVariables, 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<\/p>\n<h4>7. Cursor and Trigger<\/h4>\n<p align=\"justify\">\nCursor: Types of Cursor, Explicit Cursor Attributes Trigger: Trigger, Statement Trigger, Row Trigger, Using Conditional Operations. 06<\/p>\n<h4>8. Functions, Procedures and packages<\/h4>\n<p align=\"justify\">\nCreate 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<\/p>\n<h4>9. Parallel and distributed database<\/h4>\n<p align=\"justify\">\nImplementation of different types of Partitions: Range, Hash, List. Distributed Database: Horizontal, Vertical fragmentation 04<\/p>\n<h4>10. Object Oriented database<\/h4>\n<p align=\"justify\">\nImplementation ofAbstract Data Type, Inheritance, Reference 04<\/p>\n<h4>11. Manual Testing<\/h4>\n<p align=\"justify\">\n<ul>\n<li>Study of Reviews (Writing Test cases, Testing Framework, Test Document)<\/li>\n<li>Construction of CFG &amp; Deriving Test Cases<\/li>\n<li>Implementation of Test Cases using Unit Testing, Integration &amp; System Testing 04<\/li>\n<\/ul>\n<h4>12. Manual Testing<\/h4>\n<p align=\"justify\">\n<ul>\n<li>Implementation of Test Cases using Equivalence Class Partitioning, Boundary Value Analysis.<\/li>\n<li>State Transition Test, Cause Effect Graphing and Decision Table Technique. 04<\/li>\n<\/ul>\n<h4>13. Automation Testing<\/h4>\n<p align=\"justify\">\n<ul>\n<li>Study of Automation Tools.<\/li>\n<li>Building Test Cases.<\/li>\n<li>Using Base URL to Run Test Cases in Different Domains 06<\/li>\n<\/ul>\n<h4>14. Automation Testing<\/h4>\n<p align=\"justify\">\n<ul>\n<li>Selenium commands-selenese<\/li>\n<li>Matching Text Patterns<\/li>\n<li>Performance Testing Concepts :Load Testing, Stress Testing 06<\/li>\n<\/ul>\n<h4>15. Automation Testing<\/h4>\n<p align=\"justify\">\n<ul>\n<li>Web Driver Implicit &amp; Explicit Wait<\/li>\n<li>Cross Browser Testing<\/li>\n<li>API Testing 06<\/li>\n<\/ul>\n<p><i>Note: Automation software testing practicals can be performed using open source tool like selenium.<\/i>\n  <\/p>\n<h4>Reference Books:<\/h4>\n<p align=\"justify\">\n<ul>\n<li>Joel Murach, Murachs oracle PL \/SQLJoel Murachs publication Murachs and Assocites<\/li>\n<li>Sharnam shah, Vaishali Shah, Oracle for ProfessionalsPublication SPD-Shroff Publishers and Distributors 2011<\/li>\n<li>RiniChakrabarti, ShilbhadraDasgupta, KLSI, Advanced Data Base Management System Publication DreamTech<\/li>\n<li>Chakravarti \/Advance Data Base Management System, Wiley -Dreamtech<\/li>\n<li>RajshekharSundaram, Oracle 10g Programming: A Premier, Publication Pearson Education 2009<\/li>\n<li>Peter Rob and Coronel, Database Principals fundamentals of Design, Implementation and Management, Publication Cengage Learning 2011.<\/li>\n<\/ul>\n<p align=\"justify\">For detail syllabus of all other subjects of Master of Computer Applications (MCA), 2017 regulation do visit <a href=\"..\/category\/mca+3rd-sem\">MCA 3rd Sem Subjects<\/a> syllabus for 2017 regulation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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 [&hellip;]<\/p>\n","protected":false},"author":2351,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[35,71],"tags":[],"class_list":["post-10787","post","type-post","status-publish","format-standard","hentry","category-3rd-sem","category-mca"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/10787","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/users\/2351"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/comments?post=10787"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/10787\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/media?parent=10787"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/categories?post=10787"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/tags?post=10787"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}