{"id":10615,"date":"2020-02-21T16:28:14","date_gmt":"2020-02-21T16:28:14","guid":{"rendered":"https:\/\/www.inspirenignite.com\/vtu\/15is32p-dbms-and-gui-lab-information-sci-3rd-sem-syllabus-for-diploma-dte-karnataka-c15-scheme\/"},"modified":"2020-02-21T16:28:14","modified_gmt":"2020-02-21T16:28:14","slug":"15is32p-dbms-and-gui-lab-information-sci-3rd-sem-syllabus-for-diploma-dte-karnataka-c15-scheme","status":"publish","type":"post","link":"https:\/\/www.inspirenignite.com\/vtu\/15is32p-dbms-and-gui-lab-information-sci-3rd-sem-syllabus-for-diploma-dte-karnataka-c15-scheme\/","title":{"rendered":"15IS32P: Dbms and Gui Lab Information Sci 3rd Sem Syllabus for Diploma DTE Karnataka C15 Scheme"},"content":{"rendered":"<p>Dbms and Gui Lab detail DTE Kar Diploma syllabus for Information Science And Engineering (IS), C15 scheme is extracted from <a href=\"http:\/\/dte.kar.nic.in\/obe11.shtml\/\" target=\"_blank\" rel=\"noopener\">DTE Karnataka<\/a> official website and presented for diploma students. The course code (15IS32P), and for exam duration, Teaching Hr\/week, Practical Hr\/week, Total Marks, internal marks, theory marks, duration and credits do visit complete sem subjects post given below. The syllabus PDFs can be downloaded from official website.<\/p>\n<p>For all other information sci 3rd sem syllabus for diploma c15 scheme dte karnataka you can visit <a href=\"..\/information-sci-3rd-sem-syllabus-for-diploma-c15-scheme-dte-karnataka\">Information Sci 3rd Sem Syllabus for Diploma C15 Scheme DTE Karnataka Subjects<\/a>. The detail syllabus for dbms and gui lab is as follows.<\/p>\n<p><h4>Pre-requisites:<\/h4>\n<p>Knowledge of basics DBMS theoretical concepts\n<\/p>\n<p><h4>Course Objectives:<\/h4>\n<ol>\n<li>Provide strong formal foundation in database concepts.<\/li>\n<li>Understand relational data model and systematic database design approach including conceptual design and logical design using data modelling tool.<\/li>\n<li>Learn the techniques of query processing using SQL engines.<\/li>\n<li>Develop a database application using any of the GUI application products.<\/li>\n<\/ol>\n<p><h4>Course Outcomes:<\/h4>\n<p><b>For complete syllabus and results, class timetable and more pls <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy Syllabus App<\/a>.<\/b> Its a light weight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n<p><h4>List of Graded Practical Exercises<\/h4>\n<ol>\n<li>Using any open source data modelling tool (MySQL\/Rational Rose\/ERwin), design and develop a ER diagram for the following Library database. Specify relevant Referential constraints.<\/li>\n<p>\nBOOK AUTHORS<br \/>\n<br \/>\nBOOK ID\tAUTHOR NAME<\/p>\n<p>PUBLISHER<br \/>\n<br \/>\nNAME\tADDRESS\tPHONE<\/p>\n<p>BOOK COPIES<br \/>\n<br \/>\nBOOK ID\tBRANCH ID\tNO COPIES<\/p>\n<p>BOOK LOANS<br \/>\n<br \/>\nBOOK ID\tBRANCH ID\tCARD NO\tDATE HIRED\tDUE DATE<\/p>\n<p>LIBRARY_BRANCH<br \/>\n<br \/>\nBRANCH ID I BRANCH NAME ADDRESS<\/p>\n<p>BORROWER<br \/>\n<br \/>\nCARD NO\tNAME\tADDRESS\tPHONE<\/p>\n<li>Consider a GRADE_BOOK database in which instructors within an academic department record point earned by individual students in theory classes. The data requirements are summarised as follows:<\/li>\n<ul>\n<li>Each student is identified by a unique identifier, first and last name and an email address.<\/li>\n<li>Each instructor teaches certain courses each term. Each course is identified by a course number, a section number and the term in it is taught. For each course he or she teaches, the instructor specifies the minimum number of points required in order to earn letter grades, A, B, C, D and F. For Ex. 90 points for an A, 80 points for a B, 70 points for a C and so forth.<\/li>\n<li>Students are enrolled in each course taught by the instructor.<\/li>\n<li>Each course has a number of grading components (such as mid-term exam, final exam, project and so forth). Each grading component has a maximum number of points (100 or 50) and a weight (20% or 10%). The weight of all the grading components of a course is 100.<\/li>\n<li>Finally, the instructor records the points earned by each student in each of the grading components in each course. For Ex. The student 1234 earns 84 points for a mid-term exam, grading component of the section 2 course CS 2310 in the fall term of 2009. The mid-term exam grading component may have been defined to have a maximum of 100 points and a weight of 20% of the course grade.<\/li>\n<\/ul>\n<li>Create the following tables for a COMPANY database<\/li>\n<p>\nEMPLOYEE<br \/>\n<br \/>\nFname\tMinit\tLname\tSsn\tBdate\tAddress\tSex\tSalary Super ssn\tDno<\/p>\n<p>DEPARTMENT<br \/>\n<br \/>\nDname Dnumber Mgr ssn Mgr start date<\/p>\n<p>DEPT_LOCATIONS<br \/>\n<br \/>\nI Dnumber | Dlocation<\/p>\n<p>PROJECT<br \/>\n<br \/>\nPname Pnumber Plocation Dnum<\/p>\n<p>WORKS ON<br \/>\n<br \/>\nEssn\tPno\tHours<\/p>\n<p>DEPENDENT<br \/>\n<br \/>\nEssn | Dependent name Sex Bdate Relationship<\/p>\n<li>Illustrate the use of constraints<\/li>\n<ol type=\"i\">\n<li>NOT NULL<\/li>\n<li>PRIMARY KEY<\/li>\n<li>UNIQUE<\/li>\n<li>CHECK<\/li>\n<li>DEFAULT<\/li>\n<li>REFERENCES<\/li>\n<\/ol>\n<li>DATA MANIPULATION : INSERTING VALUES INTO A TABLE<\/li>\n<li>Illustrate the use of SELECT statement<\/li>\n<li>Conditional retrieval &#8211; WHERE clause<\/li>\n<li>Query sorted &#8211; ORDER BY clause<\/li>\n<li>Grouping the result of query &#8211; GROUP BY clause and HAVING clause<\/li>\n<li>Aggregate functions in SQL (Count, Sum, Max, Min, Avg)<\/li>\n<li>SQL operators(And, Or, Like, Between, In)<\/li>\n<li>Query multiple tables using JOIN operation.<\/li>\n<li>Write nested and complex queries using multiple tables.<\/li>\n<li>Perform UPDATE, ALTER, DELETE, DROP operations on tables<\/li>\n<li>Illustrate the use of CREATE VIEW command and manipulating<\/li>\n<li>Use COMMIT and ROLL BACK commands<\/li>\n<li>Use SAVEPOINT commands<\/li>\n<\/ol>\n<p><b>GUI<\/b><\/p>\n<ol>\n<li>To study about various Gambas\/Visual Basic (front end) or any other front end tool<\/li>\n<li>Design a form to use various tools like label, text, combo box, list boxes, check box, option box, horizontal and vertical scroll bars, etc. Illustrate the above with an example such as survey form, registration form for an event or another other example.<\/li>\n<li>Design a menu driven form to process student&#8217;s results or a shopping list or any other example.<\/li>\n<li>Generate a report for student&#8217;s results or employee details or shopping list or any other example.<\/li>\n<li>Based on any database specified in Question No. 1, 2 or<\/li>\n<li>The application must be menu driven having suitable active controls with database connectivity. Generate different reports as per user requirements.<\/li>\n<\/ol>\n<p><h4>Reference Books:<\/h4>\n<ol>\n<li>Fundamentals of Database system 5th Edition, Ramez Elmasri,Shamkan B. Navthe, Pearson Education<\/li>\n<li>Visual Basic 6 How to program by Deitel &amp; Associates<\/li>\n<li>http:\/\/www.tutorialspoint.com\/dbms\/sql_overview.htm<\/li>\n<li>http:\/\/www.sql-tutorial.net\/<\/li>\n<li>http:\/\/www.visualbasicbooks.com\/vb6introtutorial.html<\/li>\n<li>http:\/\/gambas.sourceforge.net\/<\/li>\n<li>http:\/\/gambasdoc.org\/help<\/li>\n<\/ol>\n<p><h4>Suggested List of Student Activities:<\/h4>\n<p><b>For complete syllabus and results, class timetable and more pls <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy Syllabus App<\/a>.<\/b> Its a light weight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n<p><h4>Course Delivery:<\/h4>\n<p>The course will be delivered through Demonstration and Practices\n<\/p>\n<p><h4>Scheme of Valuation for End Examination<\/h4>\n<ol>\n<li>Creating and inserting records for minimum two tables. Use minimum 2 constraints\t10<\/li>\n<li>Executing minimum 3 queries\t15<\/li>\n<li>Build a GUI program for the table created with data grid view and options such as Add, Delete, Modify etc.\t15<\/li>\n<li>Viva-Voce\t10<\/li>\n<\/ol>\n<p><i>**Evaluation should be based on the screen output only. No hard copy required. **Change of question is allowed only once. Marks of 05 should be deducted in the given question.<\/i>\n<\/p>\n<p><h4>Resource requirements for DBMS &amp; GUI Lab<\/h4>\n<p><b>For complete syllabus and results, class timetable and more pls <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy Syllabus App<\/a>.<\/b> Its a light weight, easy to use, no images, no pdfs platform to make students life easier.<\/p>\n<p>For detail syllabus of all other subjects of BE Information Sci, C15 scheme do visit <a href=\"..\/category\/information-science-diploma+3rd-sem\">Information Sci 3rd Sem syllabus for C15 scheme<\/a>.<\/p>\n<p>Dont forget to <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=ini.istudy\" target=\"_blank\" rel=\"noopener\">download iStudy Syllabus App<\/a> for latest syllabus and results, class timetable and more.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Dbms and Gui Lab detail DTE Kar Diploma syllabus for Information Science And Engineering (IS), C15 scheme is extracted from DTE Karnataka official website and presented for diploma students. The [&hellip;]<\/p>\n","protected":false},"author":2298,"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":[4,66],"tags":[],"class_list":["post-10615","post","type-post","status-publish","format-standard","hentry","category-3rd-sem","category-information-science-diploma"],"_links":{"self":[{"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/posts\/10615","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/users\/2298"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/comments?post=10615"}],"version-history":[{"count":0,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/posts\/10615\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/media?parent=10615"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/categories?post=10615"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inspirenignite.com\/vtu\/wp-json\/wp\/v2\/tags?post=10615"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}