CS306 Database Management

Print this page Please use the scale options of your printing settings for adjustments.

Course Code Course Title Weekly Hours* ECTS Weekly Class Schedule
T P
Wed: 15:00-17:50
Prerequisite It is a prerequisite to
Lecturer Emine Yaman Office Hours / Room / Phone
Monday:
13:00-16:00
Tuesday:
11:00-14:00
Thursday:
11:00-14:00
B F2.7C
E-mail eyaman@ius.edu.ba
Assistant Nesibe Merve Demir Assistant E-mail ndemir@ius.edu.ba
Course Objectives This course introduce basic concepts and fields of database management systems. Main goal is to develop knowledge of the students about data integrity, security, relational model, relational algebra and make them familiar with Entity-Relationship (E-R) and class diagram which used in design of database. They will also learn how to create databases using MSQL and complex Structured Query Language (SQL) queries of relational databases.
Textbook First book: Database Systems, T.Connolly & C.Begg, 5.Edition, Addison Wesley. Second book: Database Systems, R.Elmasri, S.B. Navathe, 6. edition, Pearson. Third book: SQL for MySQL Developers, R. F. Lans, 1.Edition, Addison Wesley.
Additional Literature
Learning Outcomes After successful  completion of the course, the student will be able to:
  1. Draw E-R Diagram for databases
  2. Develop commands to create database schemas, insert and manipulate data records and extract information from stored data.
  3. Understand the theoretical foundations of query languages and the mechanisms used to efficiently process and evaluate queries.
  4. Use SQL database language in MySQL
Teaching Methods Class discussions with examples. Active lab sessions for engaged learning and continuous feedback on progress. Lab exercises and practical assignments.
Teaching Method Delivery Online Teaching Method Delivery Notes
WEEK TOPIC REFERENCE
Week 1 Introduction to Course Chapter 1
Week 2 Introduction to Databases Chapter 1
Week 3 Database Environment Chapter 2
Week 4 The Relational Model Chapter 4
Week 5 ER Diagram Chapter 12
Week 6 EER Diagram Chapter 13
Week 7 Midterm preparation and MIDTERM EXAM
Week 8 Mapping Chapter 8
Week 9 Normalization Chapter 14
Week 10 Relational Algebra Chapter 5
Week 11 SQL:Data Manipulation Chapter 6
Week 12 SQL:Data Definition Chapter 7
Week 13 Advanced SQL Chapter 8
Week 14 Query By Example Chapter 9
Week 15 Review Chapter
Assessment Methods and Criteria Evaluation Tool Quantity Weight Alignment with LOs
Final Exam 1 35 1,2,3,4,5
Semester Evaluation Compenents
Midterm exam 1 25 1,2,3
Assignments 5 20 1,2,3,4,5
Project 1 20 1,2,3,4,5
***     ECTS Credit Calculation     ***
 Activity Hours Weeks Student Workload Hours Activity Hours Weeks Student Workload Hours
Lecture Hours 3 15 45 Assignments 3 5 15
Projects 15 1 15 Home Study 2 15 30
Midterm Exam Study 12 1 12 Final Exam Study 15 1 15
Labs 3 6 18
        Total Workload Hours =
*T= Teaching, P= Practice ECTS Credit =
Course Academic Quality Assurance: Semester Student Survey Last Update Date: 16/04/2021
QR Code for https://ecampus.ius.edu.ba/syllabus/cs306-database-management

Print this page Please use the scale options of your printing settings for adjustments.