Advanced Database Management and System

bugenigmaΛογισμικό & κατασκευή λογ/κού

30 Οκτ 2013 (πριν από 3 χρόνια και 9 μήνες)

89 εμφανίσεις

Department of

MIS.

,

College of Commerce, NCCU


Professo
r

Tseng, Shu
-
Feng






Syllabus_MIS_
MS
_
Advanced Database Management and System
_
Tseng, Shu
-
Feng
:
1

of
2


(Part One)

NA
TIONAL CHENGCHI UNIVERSITY

COLLEGE OF COMMERCE

DEPARTMENT OF


MANAGEMENT INFORMATION SYSTEMS

Regular
M
S

PROGRAM


Advanced Database Management and System



200
9
/
Spring


A. Instructor:

Tseng, Shu
-
Feng



Office:
Research Room
26
1119
,
1
1
th Fl., College of Commerce Bldg.

E
-
mail:


sftseng
@nccu.edu.tw




Phone/Fax:

Office:

8661
-
3129
,
Mobile:
0921
-
879265


Class Hours:

Monday 14:10


17:00

商館
㈶〳ㄲ

=>‴ 6
後到電腦教室
㈶〵〹

Office⁈潵rs:

M潮d慹
Ⱐ,hursd慹

17:00
-
18:00


And by appointment

B. Books

1.

Elmasri, R. and Navathe, S.B.,Fundamentals of Database Systems, 5
t
h
, ed.
ADDISON
-
WESLEY COMPUTING,
2007.

C. Course objectives

Th
is

course would cover D
at
a Base
related issues
including
Conceptual Modeling;
Relational
Model Concepts, Constraints, Languages, Design and Programming
;
Database Design Theory
a
nd
Methodology;
Transaction Processing Concepts;
Data Warehousing and OLA
P


The course would be conducte
d by
t
extbook
reading and
extract

lecturing
, complement
ed
with
exercises using
practical DBMS and OLAP tools, such as

IBM
DB2 and Cognos 8.

Students
are required to work on
2

team project
s

to

practice database application.


D. Grading Policy
(
T
entative
)

1
Exam
-------------------
-
--------
----------------------


35
%


IBM DB2 Labs
------------------------------------------

10%

IBM Cognos8 Labs
-------------------------------------

10%

Web
-
Based DB Transaction Project
----------------

20
%

OLAP DB Ap
plication Project
----
-------------------


20
%

Class Attendance
------------------------------
---
------

5%

Total



100%

E. Important Notes and Policies

Department of

MIS.

,

College of Commerce, NCCU


Professo
r

Tseng, Shu
-
Feng






Syllabus_MIS_
MS
_
Advanced Database Management and System
_
Tseng, Shu
-
Feng
:
2

of
2

CLASS SCHEDULE




















No.

Date

Chapters, Subjects a
nd Assignments

(committee recomme
n
ded*)

Exercise

1

2/23

Course Introduction

Chapter
1
: Databases and Database Users

*Chapter
2
: Database System Concepts and Architecture

Project

Team Up

2

3/2

*Chapter
3
: Data Modeling Using the Entity
-
Relationship (ER)

Model

Chapter
12
: Practical Database Design Methodology and Use
of UML Diagrams

Project

Subject

3

3/9

*Chapter
5
: The Relational Data Model and Relational
Database Constraints

*
Chapter
7
: Relational Database Design by ER
-
and

EER
-
to
-
Relational Mapping

UM
L Diagram

ER
D

4

3/16

*Chapter
10
: Functional Dependencies and Normalization for
Relational Databases


DB Design

Project Discussion

5

3/23

*Chapter
17
: Introduction to Transaction Processing Concepts
and Theory

*Chapter
18
: Concurrency Control Techniques

*Chapter
19
: Database Recovery Techniques

Use Case Description

Initial
UI D
esign

6

3/30

Exam

for Textbook Reading


7

4/6

IBM DB2
-
1

DB2Lab1

8

4/13

IBM DB2
-
2

DB2Lab2

9

4/20

IBM DB2
-
3

DB2Lab3

10

4/27

IBM DB2
-
4

DB2Lab4

11

5/4

IBM DB2
-
5

DB2Lab5

12

5/11

P
roject presentation

-

W
eb
-
B
ased
DB Application


13

5/18

IBM Cognos8
-
1 Analysis

CG
-
Lab1

14

5/25

IBM Cognos8
-
2 Reporting

CG
-
Lab2

15

6/1

IBM Cognos8
-
3 Event

CG
-
Lab3

16

6/8

IBM Cognos8
-
4 Metric

CG
-
Lab4

17

6/15

IBM Cognos8
-
5 OLAP

CG
-
Lab5

18

6/22

Project presentation

-

OLAP for
A
vailable
D
atabase