Database Systems (academic course) - Revision history

Christoph: +FairUse

2006-05-25T23:35:03Z

+FairUse

Christoph: /* Contact */ Added time

2006-01-17T16:27:15Z

‎Contact: Added time

Christoph: Added Textbook

2005-12-23T00:52:26Z

Added Textbook

Christoph: Started article

2005-12-23T00:44:44Z

Started article

New page

==Overview==

===Aim/objectives===

The amount of data met in our daily life makes demands on how data are structured and stored asking for more powerful tools than the use of files and file systems. On the other hand database systems offer basic mechanisms to structure large amounts of data allowing storing and retrieving data using general principles based on a general data model and query language as e.g. SQL.

The course goal is to give a general understanding of databases, their use and foundations. More specific the participants should:
* gain knowledge on how database systems are constructed,
* be familiar to the conceptual design of databases,
* be acquainted with different data models and the corresponding query-languages

===Content===

Introduction to fundamental database concepts and database management.
The relational data model. Relational algebra and calculus; Structured Query Language (SQL): Data Definition, data queries, data manipulation and data integrity. Design of databases using Entity-Relationship diagrams Transformation from ER-diagrams to relational database schemas. Normalization of relational databases.
Databases and query languages based on other data models: Object oriented and object-relational databases. Semistructured and XML databases. XML for data representation and data interchange.

Several exercises using different database system are given during the course period.

===Contact===
*Professor: Hans Bruun, build. 325, room 211, (+45) 4525 3709, hab@imm.dtu.dk
*Department: 02 Informatics and Mathematical Modelling
*Home Page: http://www.imm.dtu.dk/courses/02170

[[Category:Academic Courses]]

← Older revision		Revision as of 23:35, 25 May 2006
Line 1:		Line 1:
		+	{{FairUse}}
	==Overview==		==Overview==

@@ Line 22: / Line 22: @@
 * "[http://www.amazon.com/gp/product/0130353000/qid=1135298814/sr=2-1/ref=pd_bbs_b_2_1/102-5399506-7733700?s=books&v=glance&n=283155 A First Course in Database Systems]", by Jeffrey D. Ullman, Jennifer D. Widom, Prentice Hall; 2nd Edition (2-Oct-2001).
-===Contact===
+=== Contact ===
-*Professor: Hans Bruun, build. 325, room 211, (+45) 4525 3709, hab@imm.dtu.dk
+* Professor: Hans Bruun, build. 325, room 211, (+45) 4525 3709, hab@imm.dtu.dk
-*Department: 02 Informatics and Mathematical Modelling
+* Department: 02 Informatics and Mathematical Modelling
-*Home Page: http://www.imm.dtu.dk/courses/02170
+* Home Page: http://www.imm.dtu.dk/courses/02170
 [[Category:Academic Courses]]

← Older revision		Revision as of 00:52, 23 December 2005
Line 17:		Line 17:

	Several exercises using different database system are given during the course period.		Several exercises using different database system are given during the course period.
		+
		+	===Textbook===
		+
		+	* "[http://www.amazon.com/gp/product/0130353000/qid=1135298814/sr=2-1/ref=pd_bbs_b_2_1/102-5399506-7733700?s=books&v=glance&n=283155 A First Course in Database Systems]", by Jeffrey D. Ullman, Jennifer D. Widom, Prentice Hall; 2nd Edition (2-Oct-2001).

	===Contact===		===Contact===