Navigation

Dr. Roberto Rossi
- A Weather Forecasting System in MySQL
- CS6003 - Database Systems
Sitemap

"To know the road ahead, ask those coming back",

Chinese proverb

"Not everything that counts can be counted, and not everything that can be counted counts",
A. Einstein

"Like everything metaphysical the harmony between thought and reality is to be found in the grammar of the language",
L. Wittgenstein

"The greatest challenge to any thinker is stating the problem in a way that will allow a solution",
B. Russell

"...no general method for the solution of questions in the theory of probabilities can be established which does not explicitly recognise... those universal laws of thought which are the basis of all reasoning",

G. Boole

"No great discovery was ever made without a bold guess",
Sir. I. Newton

"All truths are easy to understand once they are discovered; the point is to discover them",
G. Galilei

"In the universe many things, in spite of their differences among themselves, can be united on account of their common limits",

G. Gemistos

"Alea iacta est",

G. Cesare, Rimini, January the 10th, 49 BC

"Wisdom is the principal thing, therefore get wisdom, and with all thy getting, get understanding. Exalt her and she shall bring thee to honour",

Proverbs 4:7

"A good decision is based on knowledge and not on numbers",
Plato

"Rest satisfied with doing well, and leave others to talk of you as they please",
Pythagoras

"If you search for the laws of harmony, you will find knowledge",

inscription on a wall of Luxor temple

CS6003 - Database Systems

Lecturer: Roberto Rossi
Cork Constraint Computation Centre
University College Cork
14 washington st. west
robros (at) gmail.com
+353 21 4255459
My Google Calendar

CS6003 - Module content

a Relational database systems: data model features; SQL data language.
b Relational database implementations: Sybase; Oracle; Ingres; Access; dBase.
c Database design.
d Data administration: concepts; strategies; high level tools.
e Fourth generation languages.

	Week* 1	Week 2	Week 3	Week 4	Week 5	Week 6
a
b
c
d
e

*one week consists of an average of 8 hours of lessons.
At the beginning of every week there is a "fill in the blanks" or "multiple choices" test.

Module Lectures

Lecture Location

Westbourne Villas, Western Road

Lecture material

a	Introduction to Databases
a	Introduction to Databases - MySQL examples
a	Database Management Systems (DBMS)
a	Relational Data Model
a	Exercises I
b	DBMS Implementations
a	Databases in the Biosciences
a	Relational Algebra
a	Relational Algebra - Exercises
a,b	Exercises II
a	Structured Query Language (SQL) - Basics (I)
a	Structured Query Language (SQL) - Sample DB
a	Structured Query Language (SQL) - Execises
a	Exercises III
a	Structured Query Language (SQL) - Basics (II)
a	Transactions
d	DB Administration
a,d	Exercises IV
c	Database Design
c	Entity-Relationship Data Model
c	Entity-Relationship: Exercises
c	Exercises V
e	Fourth generation languages

Course Software

MySQL 5.0 Download Page
MySQL 5.0 GUI Download Page
MySQL reference manual
A handy list of commands

Course Book

T. Connoly, C. Begg. Database Solutions (Second Edition). Pearson Education ISBN 0 321 17350 3

Dr. Roberto Rossi	Search this site

Dr. Roberto Rossi

Navigation