Navathe Dbms Pdf Free Download
Database Systems, fall 2006
[News] [Schedule] [Course description] [Links] [Intranet]
News
The exam has been corrected (answers). Grades will be available via my.itu. The passing percentage was 83, and the average passing grade 8.3.Curriculum for the exam.
Note that there is a follow-up course (15 ECTS) on database tuning in spring 2007.
Groups for the project have been made.
The tables used in the course book can be inserted into your database by clicking at this link, copy and paste the text into the SQL*Plus windows. This will create the relations in your database
Schedule
This is a tentative plan. Changes to contents and/or reading material may occur. However, we will strive to make such changes at least a week in advance.
| Date | Subject | Literature | Exercises | Hand-in |
| Aug. 29 | Introduction (RP) - slides | RG 1, 5.2 | Ex0 | - |
| Sep. 5 | ER modeling (RP) - slides | RG 2, note | Ex1 | - |
| Sep. 12 | The relational model (RP) - slides | RG 3 | Ex2 | Individual hand-in 1 |
| Sep. 19 | Relational algebra (ERH) - slides | RG 4.0-4.2, part of 5 | Ex3 | - |
| Sep. 26 | No lecture | - | Group hand-in 1 | |
| Oct. 3 | SQL (ERH) - slides | RG 5 | Ex4 | - |
| Oct. 10 | DB application development (ERH) - slides | RG 6 | Ex5 | Individual hand-in 2 |
| Oct. 17 | No lecture (fall break) | - | - | |
| Oct. 24 | Normalization (RP) - slides | RG 19.1, 19.2, 19.4, 19.5, 19.6, 19.7, 19.9 | Ex6 | - |
| Oct. 31 | Transaction management (ERH) - slides | RG 16, paper | Ex7 | Group hand-in 2, note |
| Nov. 7 | Indexing, query processing (ERH) - slides | RG 8.1,8.2,8.3,8.5, 12.1,12.2,12.4,12.5,12.6 | Ex8 | - |
| Nov. 14 | Database tuning (RP) - slides | RG 20 | Ex9 | Individual hand-in 3 |
| Nov. 21 | Guest lecture: Martin Jensen, Oracle | - | - | |
| Nov. 28 | Security and authorization (ERH) slides | RG 21 | Ex10 | Group hand-in 3 |
| Dec. 5 | Temporal data (slides). Exam info (slides, example). (RP) | EM 24.2.0-24.2.2 (hand-out) | - | - |
| Jan. 2 | Written exam (9.00-13.00), room 3A12+3A14 |
Literature:
- RG = Database Management Systems, 3rd rev. edition, by Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill, 2002, ISBN 0071230572.
- EN = Database Systems, 5th edition, by Elmasri and Navathe, Addison-Wesley 2007. (Copies from the book will be handed out.)
Links
- Oracle 10g SQL reference. Free, but requires registration.
- Oracle XE is a DBMS with similar functionality as the one installed at ITU. It is free to download and install on Windows or Linux.
- Course book website with supporting material, e.g. example solutions to exercises.
- CutePDF (free) can be used to generate PDF files in Windows.
- Exam problems from DBS (in Danish): June 2006 / answers, January 2006, June 2005 / answers, June 2003 / answer, January 2004 / answers
- Exam problems from "Introduction to Databases": January 2006/answers, January 2005, January 2004, December 2003.
- Data for exercises.
- Free SSH client for remote access and T�gers instructions (in Danish).
Teachers
| Rasmus Pagh (lectures, course responsible) Office: 3C 07 E-mail: pagh@itu.dk | Esben Rune Hansen (lectures) Office: 3C 14 E-mail: esben@itu.dk | Knut Tveitane (exercises and hand-ins) E-mail: knut (@itu.dk) Martin Scheil Corneliussen (exercises and hand-ins) |
Source: https://rasmuspagh.net/courses/DBSE06/
Posted by: carrollbasturassa.blogspot.com
Komentar
Posting Komentar