15CS36P: Dbms and Gui Lab Computers 3rd Sem Syllabus for Diploma DTE Karnataka C15 Scheme

Dbms and Gui Lab detail DTE Kar Diploma syllabus for Computer Science And Engineering (CS), C15 scheme is extracted from DTE Karnataka official website and presented for diploma students. The course code (15CS36P), 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.

For all other computers 3rd sem syllabus for diploma c15 scheme dte karnataka you can visit Computers 3rd Sem Syllabus for Diploma C15 Scheme DTE Karnataka Subjects. The detail syllabus for dbms and gui lab is as follows.

Pre-requisites:

Knowledge of basics DBMS theoretical concepts

Course Objectives:

1. Provide strong formal foundation in database concepts.
2. Understand relational data model and systematic database design approach including conceptual design and logical design using data modelling tool.
3. Learn the techniques of query processing using SQL engines.
4. Develop a database application using any of the GUI application products.

Course Outcomes:

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

List of Graded Practical Exercises

1. 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.

BOOK AUTHORS

BOOK ID AUTHOR NAME

PUBLISHER

NAME ADDRESS PHONE

BOOK COPIES

BOOK ID BRANCH ID NO COPIES

BOOK LOANS

BOOK ID BRANCH ID CARD NO DATE HIRED DUE DATE

LIBRARY_BRANCH

BRANCH ID I BRANCH NAME ADDRESS

BORROWER

CARD NO NAME ADDRESS PHONE

2. 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:
• Each student is identified by a unique identifier, first and last name and an email address.
• 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.
• Students are enrolled in each course taught by the instructor.
• 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.
• 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.
3. Create the following tables for a COMPANY database

EMPLOYEE

Fname Minit Lname Ssn Bdate Address Sex Salary Super ssn Dno

DEPARTMENT

Dname Dnumber Mgr ssn Mgr start date

DEPT_LOCATIONS

I Dnumber | Dlocation

PROJECT

Pname Pnumber Plocation Dnum

WORKS ON

Essn Pno Hours

DEPENDENT

Essn | Dependent name Sex Bdate Relationship

4. Illustrate the use of constraints
1. NOT NULL
2. PRIMARY KEY
3. UNIQUE
4. CHECK
5. DEFAULT
6. REFERENCES
5. DATA MANIPULATION : INSERTING VALUES INTO A TABLE
6. Illustrate the use of SELECT statement
7. Conditional retrieval – WHERE clause
8. Query sorted – ORDER BY clause
9. Grouping the result of query – GROUP BY clause and HAVING clause
10. Aggregate functions in SQL (Count, Sum, Max, Min, Avg)
11. SQL operators(And, Or, Like, Between, In)
12. Query multiple tables using JOIN operation.
13. Write nested and complex queries using multiple tables.
14. Perform UPDATE, ALTER, DELETE, DROP operations on tables
15. Illustrate the use of CREATE VIEW command and manipulating
16. Use COMMIT and ROLL BACK commands
17. Use SAVEPOINT commands

GUI

1. To study about various Gambas/Visual Basic (front end) or any other front end tool
2. 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.
3. Design a menu driven form to process student’s results or a shopping list or any other example.
4. Generate a report for student’s results or employee details or shopping list or any other example.
5. Based on any database specified in Question No. 1, 2 or
6. The application must be menu driven having suitable active controls with database connectivity. Generate different reports as per user requirements.

Reference Books:

1. Fundamentals of Database system 5th Edition, Ramez Elmasri,Shamkan B. Navthe, Pearson Education
2. Visual Basic 6 How to program by Deitel & Associates
3. http://www.tutorialspoint.com/dbms/sql_overview.htm
4. http://www.sql-tutorial.net/
5. http://www.visualbasicbooks.com/vb6introtutorial.html
6. http://gambas.sourceforge.net/
7. http://gambasdoc.org/help

Suggested List of Student Activities:

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

Course Delivery:

The course will be delivered through Demonstration and Practices

Scheme of Valuation for End Examination

1. Creating and inserting records for minimum two tables. Use minimum 2 constraints 10
2. Executing minimum 3 queries 15
3. Build a GUI program for the table created with data grid view and options such as Add, Delete, Modify etc. 15
4. Viva-Voce 10

**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.

Resource requirements for DBMS & GUI Lab

For complete syllabus and results, class timetable and more pls download iStudy Syllabus App. Its a light weight, easy to use, no images, no pdfs platform to make students life easier.

For detail syllabus of all other subjects of BE Computers, C15 scheme do visit Computers 3rd Sem syllabus for C15 scheme.

Dont forget to download iStudy Syllabus App for latest syllabus and results, class timetable and more.