{"id":14377,"date":"2020-08-27T06:59:59","date_gmt":"2020-08-27T06:59:59","guid":{"rendered":"https:\/\/www.inspirenignite.com\/mh\/pel302-data-base-information-retrieval-laboratory-syllabus-for-pe-3rd-sem-2017-pattern-mumbai-university\/"},"modified":"2020-08-27T06:59:59","modified_gmt":"2020-08-27T06:59:59","slug":"pel302-data-base-information-retrieval-laboratory-syllabus-for-pe-3rd-sem-2017-pattern-mumbai-university","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/mh\/pel302-data-base-information-retrieval-laboratory-syllabus-for-pe-3rd-sem-2017-pattern-mumbai-university\/","title":{"rendered":"PEL302: Data Base Information Retrieval Laboratory Syllabus for PE 3rd Sem 2017 Pattern Mumbai University"},"content":{"rendered":"

Data Base Information Retrieval Laboratory detailed syllabus scheme for Production Engineering (PE), 2017 regulation has been taken from the University of Mumbai<\/a> official website and presented for the Bachelor of Engineering 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

For all other Mumbai University Production Engineering 3rd Sem Syllabus 2017 Pattern, do visit PE 3rd Sem 2017 Pattern Scheme<\/a>. The detailed syllabus scheme for data base information retrieval laboratory is as follows.<\/p>\n

Data Base Information Retrieval Laboratory Syllabus for Production Engineering SE 3rd Sem 2017 Pattern Mumbai University<\/h2>\n

Data Base Information Retrieval Laboratory<\/title><\/p>\n<h4>Course Objectives:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>. <\/p>\n<h4>Course Outcomes:<\/h4>\n<p align=\"justify\">\nLearner will be able to..<\/p>\n<ol>\n<li>Identify data models and schemes in DBMS<\/li>\n<li>Demonstrate the features of database management systems and Relational database<\/li>\n<li>Use SQL- the standard language of relational databases<\/li>\n<li>Demonstrate understanding of functional dependencies and design of the database<\/li>\n<li>Design graphical user Interface for specific application<\/li>\n<li>Create visual software entities<\/li>\n<\/ol>\n<h4>Module 1<\/h4>\n<p align=\"justify\">\nIntroduction to Database Concept: What is a database?, Characteristics of database, Example of database, File system V\/s Database system, What is DBMS?, Users of database system, Advantage of using an enterprise database, Concerns when using an enterprise database, Data independence, DBMS systems architecture, Database administrator 02<\/p>\n<h4>Module 2<\/h4>\n<p align=\"justify\">\nEntity-Relationship Data Model: Introduction, Benefits of Data Modelling, Types of Models, Phases of Database Modelling, The Entity-Relationship (ER) Model, Generalisation, Specialization and Aggregation, Extended Entity-Relationship (EER) Model 04<\/p>\n<h4>Module 3<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>. <\/p>\n<h4>Module 4<\/h4>\n<p align=\"justify\">\nStructured Query Language (SQL): Overview of SQL, Data definition commands, set operations, aggregrate functions, null values, Data manipulation commands, Data control commands, Views- using virtual tables in SQL, Nested and complex queries 04<\/p>\n<h4>Module 5<\/h4>\n<p align=\"justify\">\nIntroduction to Transactions Management and Co-currency: Transaction concept, transaction states, ACID properties, Implementation of atomicity and durability, Concurrent Executions, Serializability, Recoverability, Co-currency Control: Lock-based, Timestamp-based, Validation-based protocols, Deadlock handling, Recovery system, Failure classification, Storage structure, Recovery and atomicity, Log based recovery, Shadow paging 04<\/p>\n<h4>Module 6<\/h4>\n<p align=\"justify\">\nGraphical User Interface: Murphys law of GUI design, Features of GUI, Icons and graphics, Identifying visual cues, clear communication, colour selection, GUI standard, planning GUI Design Work Visual Programming: Sharing Data and Code: Working with projects, introduction to basic language, Using inbuilt controls and ActiveX controls, creating and using classes, introduction to collections, usinf and creating ActiveX components, dynamics data exchange, Object linking and embedding, Creating visual software entities: Working with text, graphics, working with files, file management, serial communication, multimedia control interfaces 06<\/p>\n<h4>Assessment:<\/h4>\n<p id=\"istudy\" style=\"text-align:center\">For the complete Syllabus, results, class timetable, and many other features kindly download the <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">iStudy App<\/a><br \/><b> It is a lightweight, easy to use, no images, and no pdf platform to make students’s lives easier.<\/b><br \/><a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy&pcampaignid=pcampaignidMKT-Other-global-all-co-prtnr-py-PartBadge-Mar2515-1\" target=\"_blank\" rel=\"noopener\"><img decoding=\"async\" src=\"https:\/\/play.google.com\/intl\/en_us\/badges\/static\/images\/badges\/en_badge_web_generic.png\" alt=\"Get it on Google Play\" style=\"height:65px\"><\/a>. <\/p>\n<h4>Reference Books:<\/h4>\n<p align=\"justify\">\n<ol>\n<li>Database Management Systems, G K Gupta, McGraw – Hill<\/li>\n<li>Database System Concepts, Korth, Slberchatz, Sudarshan, 6thEdition, McGraw – Hill<\/li>\n<li>GUI Design for dummies, IDG books<\/li>\n<li>Visual Basic 2005, How to program, Deitel and Deitel,3rdEdition, Pearson Education<\/li>\n<li>SQL and PL\/SQL for Oracle 10g,Black Book, Dr P S Deshpande, Dreamtech Press<\/li>\n<li>Introduction to Database Management, Mark L Gillenson, Paulraj Ponniah, Wiley<\/li>\n<li>Oracle for Professional, Sharaman Shah, SPD.<\/li>\n<li>Database Management Systems, Raghu Ramkrishnan and Johannes Gehrke, TMH<\/li>\n<li>Fundamentals of Database Management System, Mark L Gillenson, Wiley India<\/li>\n<\/ol>\n<p align=\"justify\">For detail syllabus of all other subjects of Production Engineering (PE) 3rd Sem 2017 regulation, visit <a href=\"..\/category\/production-engg+3rd-sem\">PE 3rd Sem Subjects<\/a> syllabus for 2017 regulation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Base Information Retrieval Laboratory detailed syllabus scheme for Production Engineering (PE), 2017 regulation has been taken from the University of Mumbai official website and presented for the Bachelor of […]<\/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,88],"tags":[],"class_list":["post-14377","post","type-post","status-publish","format-standard","hentry","category-3rd-sem","category-production-engg"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/14377","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=14377"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/posts\/14377\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/media?parent=14377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/categories?post=14377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/mh\/wp-json\/wp\/v2\/tags?post=14377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}