120 likes | 138 Views
Engage in real-life database problems, learn concepts like ER modeling, SQL, and database design. Implement a relational DBMS in lab sessions for practical learning.
E N D
COMPE 341 Database Design and Management 2015Fall Barış ÖZKAN Department of Information Systems Engineering Murat KARAKAYA Department of Computer Engineering
COMPE / SE / ISE493 Instructors:Barış ÖZKAN Murat KARAKAYA Email :baris.ozkan@atilim.edu.tr murat.karakaya@atilim.edu.tr Lecture :Friday 15:30-17:20 @ B-1017 Office Hour :Friday 15:00-15:30 Teaching Asst.:TBD Course Web page is on Moodle: Check your registration!
Objectives & Content Objectives: This course involves students in real-life problemsand theory on database systems and encouragesteamwork in the design and implementation ofdatabase systems.
Objectives & Content Content: Database system concepts. Data modeling with ERand EER. The Relational Data Model. Fileorganizations and index structures. Relationalalgebra. Structured Query Language (SQL). Database design: functional dependence and tablenormalization. Introduction to databaseadministration. A relational DBMS will beintroduced in a laboratory environment..
Text Books and References Course Book: “Fundamentals of Database Systems”, 6th Edition, RamezElmasri & Shamkant B. Navathe, Addison-Wesley, 2010 “Oracle 9i: SQL with an introduction to PL/SQL”, L. L.Morris-Murphy, Thomson Course Technology, 2003 Other Sources: 1. “Principles of Database Systems with Internet and Java Applications”, Greg Ricardi, Addison-Wesley, 2001.2. “Database Application Development & Design”, 3rd Ed., McGraw-Hill, M.V. Mannino, McGraw-Hill, 2005.3. http://sqlCourse.com/ (Interactive Online SQL Training)4. “Database Systems: A practical Approach to Design, Implementation, and Management”, T. Collony & Carolyn Begg, 4th Edition, Addison-Wesley, 2005.
Grading (Tentative) Attendance 5% Lab 15% Project 30% Midterm 20% Final Exam 30% You will get NA grade if : For Lectures: you miss 4 or more weeks, or For Labs: you miss 3 or more weeks Passing grade DD >= 50 FD<=49!
GradesLettersCoefficientsOrtalamaya Katılmayan Notlar • 90-100 AA 4.0I-Eksik • 85-89 BA 3.5S-Yeterli • 80-84 BB 3.0 U-Yetersiz • 75-79 CB 2.5 T-Transfer • 70-74 CC 2.0 W-Dersten Çekilme • 65-69 DC 1.5 NA-Devamsızlık nedeni ile • 60-64 DD 1.0 başarısızlık • 50-59FD 0.5NI-Not ortalamasına • 0-49 FF 0.0 katılmayan • *Öğrencilerin derslere en az %70, uygulamalara ise %80 oranında devamı zorunludur. Disiplin cezası ile uzaklaştırma dahil hangi gerekçe ile olursa olsun devam zorunluluğunu yerine getirmeyen öğrenciler dönem sonu sınavına girme hakkını kaybeder. Bu durumdaki öğrencilere (NA) notu verilir. • *ATILIM ÜNİVERSİTESİ ÖĞRENCİ KAYIT, KABUL ÖNLİSANS VE LİSANSEĞİTİM-ÖĞRETİM VE SINAV YÖNETMELİĞİ • http://atilim.edu.tr/shares/atilim/files/yonetmelikler/ Grading*
Grading Policies Missedexams: no make-up exam for midterm without approved excuse! no make-up exam for final for any excuse! Objection to Grades and seeing Exam papers: Only allowed within 2 weeks after the grade announcements Ethics: All assignments/projects are to be your own workunless it is a team work. Participation: You are supposed to be active in the class by involving and participating disscusions via asking questions, proposing solutions, explaning your ideas, etc.
EXPECTED WORK LOAD Need to have a copy of the Text Book You have to read the covered chapters in the book. PPT might not always be available & sufficient to cover all the topic’s details!!!