Practices Using Database 3360702
Practices Using Database 3360702
Practices Using Database 3360702
3360702
1.
RATIONALE
The subject is associated with database administration and developers who want to use
maximum functionalities of the database. By the end of this course students will learn
how to implement user privileges, set resource limitations, and access controls. In
addition, students will learn multiple new features such as creating and using stored
procedures, triggers and views of MySQL database.
2.
COMPETENCIES
The course content should be taught and implemented with the aim to develop different
types of skills so that students are able to acquire following competencies:
3.
COURSE OUTCOMES:
The theory should be taught and practical should be carried out in such a manner that
students are able to acquire different learning out comes in cognitive, psychomotor
and affective domain to demonstrate following course outcomes.
Write, Debug and test triggers
Implement stored routines
Implement event handling
Handle User management
Apply database backup and recovery techniques
4.
Teaching Scheme
(In Hours)
L
T
P
0
0
4
Total Credits
(L+T+P)
C
4
Examination Scheme
Theory Marks Practical Marks
Total Marks
ESE
PA
ESE
PA
100
0
0
40
60
5.
COURSE DETAILS
GTU/NITTTR/Bhopal/14-15
Gujarat State
Professional
Unit
Unit I:
Introduction to
MySQL
Unit II:
Advanced
MySQL-I
Major Learning
Outcomes (in cognitive
domain)
1a.Operate some basic
operations
of
MySQL
1b. Utilize enlisted
MySQL GUI tools
for various database
operations
2a.Describe MySQL
Trigger
2b. Define and operate
MySQL Stored
Routine
Unit III :
Advanced
MySQL-II
3a. Utilize
functionalities of
MySQL Cursor
3b.Use MySQL Events
Unit IV:
User
Management
4a.Perform Use
Management in
MySQL
Unit - V
Backup and
Recovery
3360702
GTU/NITTTR/Bhopal/14-15
Gujarat State
Professional
3360702
Note: Here only outcomes in psychomotor domain are listed as practical. However, if these
practical are completed appropriately, they would also lead to development of certain
outcomes in affective domain which would in turn lead to development of Course Outcomes
related to affective domain. Thus over all development of Programme Outcomes (as given in
a common list at the beginning of curriculum document for this programme) would be
assured.
Faculty should refer to that common list and should ensure that students also acquire
outcomes in affective domain which are required for overall achievement of Programme
Outcomes/Course Outcomes.
Example Practical list is followed with this suggested list of exercises
Sr. Unit
Practical Exercises
No. No.
1
I
Install and configure MySQL database
2
I
Install and use of SQLyog
3
I
Install and use of phpmyadmin
4
I
Install and Use of MySQL Browser
5
I
Install and use of MySQL Administration
6
II
Create table and perform various task such as Create a product and
product_price_history table. The price of product change constantly. Write
a trigger for updating product_price_history table when product price
change in product table and such other database can be explored
7
II
Implement and manipulate trigger such as Create a trigger for deleting all
the products of particular product type when that product type is deleted
and similar for other databases.
8
II
Write stored routines such as write a routine for counting all product types
and other such routines can be performed
9
II
Manipulate on routines such as write a routine for updating price of all
product by 5% and other such routines can be performed
10
III Create cursors such as create a cursor for selecting all product whose price
is more than 1000 and other such cursors can be implemented
11
III Perform various event handling operations such as create an event that
checks the product types having quantity less than 20 in stack at every ten
minutes and such other procedure can be done
12
III Implement precise events such as create an event that checks the product
which has been sold maximum in a day and same exercises can be
performed
13
IV Creating and managing user accounts in MySQL
14
IV Practicing with GRANT and Revoke Command
15
V
Practicing with database backup and recovery operations as well security
operations
Total Hours
8.
Hrs.
Required
4
4
4
4
4
4
GTU/NITTTR/Bhopal/14-15
Gujarat State
4
2
4
4
4
4
4
56
Professional
3360702
Title of Book
Author
Publication
MySQL Administrator
Sheeri Cabral
Wiley
B. Mohamed Ibrahim
MySQL 5
Michael Kofler
Apress
B).
ii.
iii.
C).
i.
ii.
iii.
http://www.mysqltutorial.org/mysql-administration.aspx
http://www.tutorialspoint.com/mysql/mysql-administration.htm
http://www.washington.edu/itconnect/connect/web-publishing/sharedhosting/using-mysql-on-shared-uw-hosting/basic-mysql-administration/
iv.
http://www.vtc.com/products/MySQL-5-Administration-Part1Tutorials.htm
11. COURSE CURRICULUM DEVELOPMENT COMMITTEE
Faculty Members from Polytechnics
Prof. P. P. Kotak, H. O. D Computer Department, A. V. P. T. I., Rajkot
Prof. R. M. Shaikh, H.O.D Computer Department, K. D. Polytechnic, Patan
Prof. K. N. Raval, H.O.D Computer Department, R. C. Technical Institute,
Ahmedabad
Prof. M. P. Mehta, Lectuer Computer, K. D. Polytechnic, Patan
Prof. R. B. Pancholi, Lectuer Computer, L. J. Polytechnic, Ahmedabad.
Prof. A. J. Shah, Lectuer Computer, L. J. Polytechnic, Ahmedabad.
Coordinator and Faculty Members from NITTTR Bhopal
1. Dr.K.James Mathai, Associate Professor, DCEA, NITTTR, Bhopal.
GTU/NITTTR/Bhopal/14-15
Gujarat State