Database systems Design

warbarnacleΑσφάλεια

5 Νοε 2013 (πριν από 4 χρόνια και 1 μήνα)

78 εμφανίσεις


Database systems Design



-

Software School of Hunan university




2006.08

Course Information


Instructor:
Liubo Ouyang

(
欧阳柳波



Office: Room 213,
Building of software School


Contact:

13574805086
,

8821984,
ouyangliubo@126.com


Experiment tutor:

Shaofei Lu

(
陆绍飞
)


Contact:

13036780732,
sflu@hnu.cn



Textbook:


Thomas Connolly, Carolyn Begg. Database systems


APractical
approachs to Design, Implementation, and management, third
Edition.
电子工业出版社
.



Course Material at web site:
http://ss.hnu.cn/oylb/dbsd/


Copies of all lecture slides and interesting articles will be
provided at the web site.



There are also an enormous number of Database System
internet sites.


A First Course in Database Systems
:


http://www
-
db.stanford.edu/~ullman/fcdb.html



Database System Design and Implementation
:


http://www
-
2.cs.cmu.edu/~christos/courses/721.S03/



ACM Transactions on Database Systems (TODS)


http://www.acm.org/tods/



Grade: HWs
1
0%, Project
25
%, Final
50
%, participation 1
5
%


Project:


PBLT method (3 students in a team)



Plagiarism will be severely punished
.


People who is absent from lecture for three times will not be
permitted to seat in the final exam.


English writing

Pre
-
requisites And Related Courses


Data structure


Discrete mathematics


Computer
principle.


Software Programming

Objectives

To provide a solid foundation on database systems and
database application development.



To master the knowledge of Database systems design.

-
To master fundamental ideas of database technology.

-
To learn how to design databases using ER diagrams and the
relational model

-
To know current new technology on database



To improve the level of speaking, writing, demonstrating,
behaving, communicating, collaborating, innovating,
and inventing.

Database Implementation Project


A significant part of your learning of the course is devoted to
a major database development project.




Design a database using ER diagrams and relational model.



Write SQL to query and update the database.



Develop a web user interface to your database.



In the process you will learn HTML and ASP or JSP.



Those skills are highly valuable to your future individual
development
.


Course Topics



Background


Introduction to Database


Database Environment




The Relational Model and Languages


The Relational Model


Relational Algebra and Relational Calculus


SQL


RDBMS




Database Analysis and Design Techniques


Database Planning, Design, and Administration


Entity
-
Relationship Modeling


Normalization




Methodology


Conceptual Database Design


Logical Database Design for the Relational Model


Physical Database Design for the Relational Databases




Selected Database Issues


Security


Transaction Management


Query Processing


Programming SQL




Current Trends


Distributed Database


Object
-
Oriented Database



Course Topics



Emerging Trends


Web Technology and DBMSs


Semi
-
structure Data and XML


Data Warehousing


OLAP and Data Mining



Course Topics