CS387 - Database design

New lecture notes are posted. (Posted Tu Dec 11 1:05:01 EDT 2001).

Look in blackboard for the solutions of one exercise we did together on transformation of an ERD to relations (Posted Sat Dec 1 11:55:01 EDT 2001).

Check your grades in blackboard. Everybody has 0 for the blackboard discussion, it will be updated later on. If there is a mistake you MUST bring your assignment next week and then I will be able to update.(Posted Sat Dec 1 11:55:01 EDT 2001).

Solutions of the hw 3 are posted in the hw section. (Posted Sat Dec 1 11:55:01 EDT 2001).

The test will be a 1 hour test and will be composed of a definition, a transformation of an ERD to relations, relational algebra and CREATE table of SQL (every options we saw except foreign key). In the definition look at what are a primary key, a foreign key, a relational schema, the operators of relational algebra, equi-join, natural join. You will have one of these definitions. (Posted Sat Dec 1 11:55:01 EDT 2001).

hw 4 is posted in the HW section. (Posted Wed Nov 28 19:36:15 EDT 2001).

New lecture notes are posted. (Posted Mon Nov 26 19:36:15 EDT 2001).

The next test is on Tuesday December 4. (Posted Sun Nov 18 00:00:15 EDT 2001).

Practice exercises are posted in the hw section. (Posted Sun Nov 18 00:00:15 EDT 2001).

HW 3 is posted in the hw section (Posted Wed Nov 14 00:50:15 EDT 2001).

Install Interbase (See the references section). We will use Interbase as a DBMS to test SQL queries. (Posted Tue Nov 13 00:20:15 EDT 2001).

Errata in the lecture notes - Relational model: I wanted to summarize the mistakes we found during the lectures. Slide Select Example: The selection is Id>3000 AND Hobby = 'hiking'. Slide Expression: In the first relation the name of the Person of Id 5678 is Mary. Slide Theta Join: The result is Mary cs386 and Bill cs385. I am sorry for the mistakes. (Posted Tue Nov 13 00:20:15 EDT 2001).

CS 387 prepares you to face the real world of databases application and internals development.
It presents the fundamental concepts of database management. It provides a study of data models, data normalization; data description languages and their design and form, query facilities including relational algebra, relation calculus, and query functions.
It will focus on the SQL query language. But this class is more than a SQL programming class.