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
CS306 Database Management 3 2 6 Tue 15:00-15:50; Thur 12:00-13:50
Prerequisite CS105 It is a prerequisite to
Lecturer Emine Yaman Office Hours / Room / Phone
E-mail eyaman@ius.edu.ba
Assistant Haris Hodzic, Haris Cengic Assistant E-mail
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.
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.
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 +Quiz 1 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 +Quiz 2 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 30 1,2,3
Quizzes 2 15 1,2,3,4,5
Assignments 5 10 1,2,3,4,5
Project 1 10 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 Midterm Exam Study 9 1 9
Quizzes 5 2 10 Final Exam Study 15 1 15
Projects 10 1 10 Assignments 3 5 15
Home Study 2 15 30 Labs 2 8 16
        Total Workload Hours = 150
*T= Teaching, P= Practice ECTS Credit = 6
Course Academic Quality Assurance: Semester Student Survey Last Update Date: 21/02/2020
QR Code for https://ecampus.ius.edu.ba/course/cs105-advanced-programming

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