CS306 Database Management
Referencing Curricula Print this page
| Course Code | Course Title | Weekly Hours* | ECTS | Weekly Class Schedule | ||||||
| T | P | |||||||||
| CS306 | Database Management | 3 | 2 | 6 | Tuesday 15:00-17:50 | |||||
| Prerequisite | CS105 | It is a prerequisite to | ||||||||
| Lecturer | Emine Yaman | Office Hours / Room / Phone | Monday: 12:00-15:00 Wednesday: 12:00-15:00 Thursday: 10:00-12:00 |
|||||||
| 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. | |||||||||
| Additional Literature |
|
|||||||||
| Learning Outcomes | After successful completion of the course, the student will be able to: | |||||||||
|
||||||||||
| 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 | Face-to-face | Teaching Method Delivery Notes | ||||||||
| WEEK | TOPIC | REFERENCE | ||||||||
| Week 1 | Introduction to Databases | Chapter 1 | ||||||||
| Week 2 | Database Environment | Chapter 2 | ||||||||
| Week 3 | The Relational Model | Chapter 4 | ||||||||
| Week 4 | ER Diagram | Chapter 12 | ||||||||
| Week 5 | EER Diagram | Chapter 13 | ||||||||
| Week 6 | Mapping | Chapter 8 | ||||||||
| Week 7 | Normalization | Chapter 14 | ||||||||
| Week 8 | Database System Development Lifecycle | Chapter 10 | ||||||||
| Week 9 | MIDTERM EXAM | |||||||||
| 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 | Presentation of the Projects | |||||||||
| Assessment Methods and Criteria | Evaluation Tool | Quantity | Weight | Alignment with LOs |
| Final Exam | 1 | 35 | 1,2,3,4,5 | |
| Semester Evaluation Components | ||||
| Midterm exam | 1 | 30 | 1,2,3 | |
| Quizzes | 2 | 15 | 1,2,3,4,5 | |
| Project | 1 | 10 | 1,2,3,4,5 | |
| Homeworks | 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 | Quizzes | 7 | 2 | 14 | |||
| Projects | 15 | 1 | 15 | Home Study | 1 | 15 | 15 | |||
| Midterm Exam Study | 13 | 1 | 13 | Final Exam Study | 15 | 1 | 15 | |||
| Labs | 3 | 6 | 18 | Homeworks | 3 | 5 | 15 | |||
| Total Workload Hours = | 150 | |||||||||
| *T= Teaching, P= Practice | ECTS Credit = | 6 | ||||||||
| Course Academic Quality Assurance: Semester Student Survey | Last Update Date: 08/04/2024 | |||||||||