CMPS328 Database Management Systems II Aug-08.doc

needmoreneedmoreΔιαχείριση Δεδομένων

28 Νοε 2012 (πριν από 4 χρόνια και 6 μήνες)

313 εμφανίσεις

1

Faculty of Science and Technology

Department of Information Technology




UNIVERSITY OF BELIZE

FACULTY OF ENGINEERING & TECHNOLOGY

DEPARTMENT OF INFORMATION TECHNOLOGY

COURSE OUTLINE FOR



DATABASE MANAGEMENT SYSTEMS I
I


(CMPS
328
) 3 CREDITS

SEMES
TER
1

(
AUGUST



DEC

200
8
)





Instructor

Ruel Cima
,M.Sc.





Telephone

822
-
3680

ext
.

30
6




Email

rcima@ub.edu.bz



Class Hours


CMPS
328



SECTION
I

T
/
U

1
2
:
3
0
-
1
:
4
5

p
.m.

Room:
BSc. Lab








Consultation
Hours

Tues
day / Thursday


2
:00

p
.m.


4
:3
0 p.m.



Course description:



Database Systems Applied to Real
-
World Business Problems. Database
Administration. Concurrency Control. Security. Recovery. Database
Application


Design, Implement Using MySQL and PostgreSQL
.







Prerequisites
:
CMPS 245 Database Management Systems


Course
Objectives:



At the end of this

course
,

students will

be able to
:




1.

Apply
data modeling techniques to

medium
-
complexity problems
.

2.

Demonstrate
proficie
cy

with basic SQL and familiar with advanced

usage

including:

a.

Multiple table
complex queries

b.

Stored Procedures

c.

Triggers

3.

Administrate databases
in MySQL and PostgreSQL with emphasis on
:

a.

Concurrency control

b.

Security

c.

Recovery

4.

If time allows,
use:

a.

OBDC

b.

Website
s linked to

databases
.



Text (Required)
:

N
o textbook is assigned for this class. Handouts will be provided from various texts
and Web sites.

















2

Faculty of Science and Technology

Department of Information Technology


COURSE CONTENT AND SCOPE:









EVALUATION:

(Subject to change; students will be notified in advance)

Tests (
3)
3
5%

Assignments
2
5%

Final Exam
40
%

Total


100%






Grading Plan:



For the evaluation of the course a point system will be used according to the following table:





UB GRADING SYSTEM





DESCRIPTION

LETTER

RANGE

QUALITY



Excellent

A

A
-

100




㤴9




4.0

3.75



䝯od



B

㠹8




㠴8




3.5

3.0



卡瑩Sf慣瑯ry



㜹7
-



2.5



P慳a楮g

C



㜴7




㘹6
-



2.0

1.5



䙡楬cre

a

c

㘴6




㔹5
-

0

1.0

0







Topics:

1.

Cou
r
se

Introduction and
Overview


2.

Complex queries in SQL


3.

Use of Stored Procedures in
PostgreSQL and

MSSQL
Server 200


4.

Triggers in PostgreSQL and
MySQL


5.

Installing and
administrating a database in
MySQL


6.

Installing and
administrating a database in
PostgreSQL


7.

ODBC

3

Faculty of Science and Technology

Department of Information Technology


LETTER GRADE KEY

A
-

to A

Work of highest quality. Students have mastered nearly all to all of

he course material

B to B+

Work of high quality. Students have mastered most of the course material

C to C+

Work of acceptable quality. Students have mastered majority of the course material

D to D+

Work of barely acceptable quality. Students have ma
stered some of the course material

F

Work of Unacceptable quality. Students have mastered little of the course material

I

Incomplete

W

Withdrawn after the drop/add deadline but before the deadline for unqualified withdrawal.

WP

Withdrawal while passin
g after deadline for unqualified withdrawal.

WF

Withdrawn while failing after deadline for unqualified withdrawal.




Departmental Policy on Penalties for Collaboration in Information Technology

Courses

In this section we specify the sanctions to be applie
d, in accordance with the guidelines of the University Policy on
Academic Dishonesty, if a student is determined to have committed an act of academic dishonesty or collaboration
within this department.

When two or more students are determined to have impro
perly collaborated:

a)

The first occurrence will be punished by a zero on the assignment; resulting in a reduction of the final grade.
Note that as a result, collaboration on an assignment that is a substantial part of the final grade will likely lead to
fail
ure in the course.

b)

The next occurrence will be punished by an F in the course.

c)

Whenever an incident occurs, a record of the incident will be included in the student’s file both in the
Department of Information Technology and the Office of Student Records.

If a student is involved in multiple
incidents across more than one course, the Department of Information Technology will refer the matter to the
appropriate University body for consideration of more severe sanctions, as outlined in the Student Handbook.
In
addition, the department will consider the disqualification of the student from the department due to
demonstrated low integrity.

d)

These penalties are to be applied to all students involved in the incident.

e)

Students may appeal any penalty using the proce
dures outlined in the Student Handbook.


CLASSROOM RULES OF CONDUCT

Cell phones can
ONLY
be set to vibrate mode. Once a call comes in, you have the option of answering it, but must
do so
OUTSIDE
of the classroom and far enough to prevent distraction of oth
er students.

There is a
15 minute grace period

in which students can enter class after which no one will be allowed to enter.
Y
ou must
NOT
disturb or distract the class while entering. If you are inconsiderate and interrupt the class, you will
be asked to

leave. If you are late or absent, it is your responsibility to find out what information you have missed and
what assignments are due from your colleagues.

As soon as class begins, no student is allowed to use the computer unless otherwise instructed by t
he lecturer.

If you need to see me outside of class, my hours of availability are posted outside my door. In addition,
ALWAYS
knock and
ONLY
when acknowledged do you enter the office.

Once a test has been returned to you, you have exactly one week from th
e date received to make queries or raise any
concerns regarding your grade etc. Each student must take all tests. I reserve the right to determine whether a
makeup test should be done.

All assignments
MUST
be turned in at the beginning of class on the date

due

or emailed by specified time
. If, for
any reason, you cannot attend class on a day an assignment is due, please notify me in advance or make necessary
arrangements for it to get to me. Late assignments will be
PENALIZED
by 5% for each day it is late.

If the instructor is not available when class begins, students are expected to wait until he arrives.

If you would like to discuss any unfavorable situation that is affecting your learning, please feel free to see me. I will
be more than happy to help. If

I cannot assist you, then I will ask the Department Chair to look into the matter.


Final Note:

The lecturer reserves the right to propose changes to this course
-
outline as necessary to ensure that the
objectives of are accomplished. Students will be not
ified in advance of changes
to be
made.