DBMS and GUI lab COMPUTER SCIENCE 3RD SEMESTER SYLLABUS

DBMS and GUI lab  COMPUTER SCIENCE 3RD SEMESTER SYLLABUS

Government of Karnataka Department of Technical Education

Bengaluru

	Course Title: DBMS and GUI lab
	Scheme (L:T:P) : 0:2:4	Total Contact Hours: 78	Course Code: 15CS36P
	Type of Course: Tutorial and Practical’s	Credit :03	Core/ Elective: Core
CIE- 25 Marks                                                                                                               SEE- 50 Marks

  Course Title: DBMS and GUI lab

Scheme (L:T:P) : 0:2:4 Total Contact Hours: 78 Course Code:

15CS36P

Type of Course: Tutorial and Practical’s Credit :03 Core/ Elective:

Core

CIE- 25 Marks SEE- 50 Marks

Course Outcome		Experiment linked	CL	Linked PO	Teaching Hrs
CO1	Explain   the                underlying                  concepts                  of database                  technologies.            Design                and implement a database schema for a given problem-domain.	1,2,3	U, A	1 to 10	03
CO2	Apply Normalization to a database.	1,2,3	U, A	1 to 10	03
CO3	Illustrate and query a database using SQL DML/DDL commands To motivate the students to relate all these to one or more commercial product environments as they relate to the developer tasks	1 to 17	A	1 to 10	48
CO4	Design,     create,                 build,                 and                 debug Gambas      /Visual                   Basic                   Database applications.	18	A	1 to 10	24
			Total sessions		78

Legends: R = Remember U= Understand; A= Apply and above levels (Bloom’s revised taxonomy)

Course-PO Attainment Matrix

Course	Programme Outcomes
	1	2	3	4	5	6	7	8	9	10
DBMS and GUI lab	3	3	3	3	3	3	3	3	3	3

Level 3- Highly Addressed, Level 2-Moderately Addressed, Level 1-Low Addressed.

Method is to relate the level of PO with the number of hours devoted to the COs which address the given PO. If >40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 3

If 25 to 40% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 2 If 5 to 25% of classroom sessions addressing a particular PO, it is considered that PO is addressed at Level 1

If < 5% of classroom sessions addressing a particular PO, it is considered that PO is considered not-addressed.

 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

 

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

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

 

PROJECT

Pname

Pnumber

Plocation

Dnum

 

WORKS_ON

Essn

Pno

Hours

 

DEPENDENT

Essn

Dependent_name

Sex

Bdate

Relationship

4	Illustrate the use of constraints
	NOT NULL
	PRIMARY KEY
	UNIQUE
	CHECK
	DEFAULT
	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
18.	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 3. The application must be menu driven having suitable active controls with database connectivity. Generate different reports as per user requirements.

 References

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 Note: The following activities or similar activities for assessing CIE (IA) for 5 marks (Any one) Student activity like mini-project, surveys, quizzes, etc. should be done in group of 3-5 students.

1. Each group should do any one of the following type activity or any other similar activity related to the course and before conduction, get it approved from concerned course co- ordinator and programme co-ordinator.

2. Each group should conduct different activity and no repeating should occur.

 Build DBMS application for processing students details such as personal details, results, attendance etc. Use minimum 3-4 tables

 Build DBMS application for maintain a mini library of CD’s. Use minimum 3-4 tables

 Using any ER diagram modelling tool demonstrate modelling of any database containing 3-4 tables.

 Course Delivery

The course will be delivered through Demonstration and Practices

 

 Course Assessment and Evaluation Scheme

Method	What				To whom	When/Where (Frequency in the course)	Max Marks	Evidence collected	Course outcomes
Direct Assessment				IA	Students	Two       tests	10	Blue books	1,2,3,4
						(average    of
	CIE (Continuous					two tests)
						Record	10	Record
	Internal Evaluation)
						Student activity	05	Report	1,2,3,4
						Total	25
	SEE			End		End of the	50	Answer scripts	1,2,3,4
	(Semester			Exam		course		at BTE
	End
	Examination)
Indirect Assessment	Student Feedback on				Students	Middle      of		Feedback	1,2,3(half
	course					the course		forms	session)
									Delivery of
									course
	End	of	Course			End of the		Questionnaires	1,2,3, 4
	Survey					course			Effectiveness
									of Delivery
									of
									instructions
									&
									Assessment
									Methods

*CIE – Continuous Internal Evaluation *SEE – Semester End Examination

Note:

1. I.A. test shall be conducted as per SEE scheme of valuation. However obtained marks shall be reduced to 10 marks. Average marks of two tests shall be rounded off to the next higher digit.

2. Rubrics to be devised appropriately by the concerned faculty to assess Student activities.

Questions for CIE and SEE will be designed to evaluate the various educational components (Bloom’s taxonomy) such as:

Sl. No	Bloom’s Category	%
1	Remembrance	10
2	Understanding	20
3	Application	70

Note to IA verifier: The following documents to be verified by CIE verifier at the end of semester

1. Blue books (10 marks)

2. Record (10 marks)

 

3. Student suggested activities report for 5 marks

4. Student feedback on course regarding Effectiveness of Delivery of instructions & Assessment Methods.

 Format for Student Activity Assessment

DIMENSIO N	Unsatisfactor y 1	Developin g 2	Satisfactor y 3	Good 4	Exemplary 5	Score
Collection of data	Does not collect any information relating to the topic	Collects very limited information ; some relate to the topic	Collects some basic information ; refer to the topic	Collects relevant information ; concerned to the topic	Collects a great deal of information ; all refer to the topic	3
Fulfill team’s roles & duties	Does not perform any duties assigned to the team role	Performs very little duties	Performs nearly all duties	Performs all duties	Performs all duties of assigned team roles with presentatio n	4
Shares work equally	Always relies on others to do the work	Rarely does the assigned work; often needs reminding	Usually does the assigned work; rarely needs reminding	Does the assigned job without having to be reminded.	Always does the assigned work without having to be reminded and on given time frame	3
Listen to other Team mates	Is always talking; never allows anyone else to speak	Usually does most of the talking; rarely allows others to speak	Listens, but sometimes talk too much	Listens and contributes to the relevant topic	Listens and contributes precisely to the relevant topic and exhibit leadership qualities	3
					TOTAL	13/4=3.2= 4

*All student activities should be done in a group of 4-5 students with a team leader.

Scheme of Valuation for End Examination                                         

 

C	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
Total		50

**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 an Intake of 60 Students [3 Batches])

C	Equipment	Quantity
1	PC systems (latest configurations with speakers)	20
2	Laser Printers	01
3	Networking (Structured) with CAT 6e / wireless 24 Port switches / Wireless Router I/O Boxes for networking(as required)	03
4	Broad Band Connection	01

C	Equipment	Quantity
1	PC systems (latest configurations with speakers)	20
2	Laser Printers	01
3	Networking (Structured) with CAT 6e / wireless 24 Port switches / Wireless Router I/O Boxes for networking(as required)	03
4	Broad Band Connection	01