| Course Title : Databases | ||||||||
|---|---|---|---|---|---|---|---|---|
| Code | Course Type |
Regular Semester |
Lecture (hours/week) |
Seminar (hours/week) |
Lab (hours/week) |
Credits | ECTS | |
| CMP 217-1 | A | -1 | 3 | 0 | 1 | 3.50 | 5 | |
| Lecturer and Office Hours | ||||||||
| Teaching Assistant and Office Hours | ||||||||
| Language | ||||||||
| Course Level | ||||||||
| Description | This course provides the necessary theoretical and practical foundations for relational database management systems. It also covers data analysis and modeling using entity-relationship techniques, relational theory and normalization, and the SQL language. | |||||||
| Objectives | Get ready to acquire some seriously marketable programming skills! You can’t consider yourself a complete end to end developer until you can code in SQL. Today, data has become the hottest topic in technology and a company’s biggest asset is their data. All databases require the language SQL to store and retrieve data. The great thing is, for this course, you do not need any prior experience in programming what so ever. SQL is a different animal and we’re going to demystify the language from scratch and prepare you with plenty of progressively challenging assignments so that by the time you’ve completed the course, you can call your self an Oracle SQL Master! Oracle is the most popular relational database in the world! | |||||||
| Course Outline | ||||||||
| Week | Topics | |||||||
| 1 | Introduction to Database Systems, Database System Concepts | |||||||
| 2 | Entity-Relationship Model | |||||||
| 3 | Enhanced Entity Relationship Model | |||||||
| 4 | Relational Data Model | |||||||
| 5 | Relational Algebra I | |||||||
| 6 | Relational Algebra II | |||||||
| 7 | Normalizing a database | |||||||
| 8 | Midterm | |||||||
| 9 | Introduction to SQL | |||||||
| 10 | DML data manipulation instructions | |||||||
| 11 | More DML instructions, DDL table creation instructions | |||||||
| 12 | Introduction to MySQL, database design in MySQL | |||||||
| 13 | Tables in MYSQL | |||||||
| 14 | Retrive data from tables using MySQL statements | |||||||
| 15 | Database Programming | |||||||
| 16 | Final Exam | |||||||
| Prerequisites | ||||||||
| Textbook | ||||||||
| Other References | ||||||||
| Laboratory Work | ||||||||
| Computer Usage | ||||||||
| Other | ||||||||
| Learning Outcomes and Competences | ||||||||
| 1 | The student manages to create a simple database | |||||||
| 2 | The student manages to make simple queries in the database | |||||||
| 3 | The student is introduced to the basic components of an RDBMS | |||||||
| Course Evaluation Methods | ||||||||
| In-term studies | Quantity | Percentage | ||||||
| Midterms | 1 | 15 | ||||||
| Quizzes | 2 | 20 | ||||||
| Projects | 0 | 0 | ||||||
| Term Projects | 0 | 0 | ||||||
| Laboratory | 0 | 0 | ||||||
| Attendance | 1 | 5 | ||||||
| Contribution of in-term studies to overall grade | 40 | |||||||
| Contribution of final examination to overall grade | 60 | |||||||
| Total | 100 | |||||||
| ECTS (Allocated Based on Student) Workload | ||||||||
| Activities | Quantity | Duration (hours) |
Total Workload (hours) |
|||||
| Course Duration (Including the exam week : 16 x Total course hours) | 16 | 4 | 64 | |||||
| Hours for off-the-classroom study (Pre-study, practice) | 14 | 4 | 56 | |||||
| Assignments | 0 | 0 | 0 | |||||
| Midterms | 1 | 2 | 2 | |||||
| Final examination | 1 | 2 | 2 | |||||
| Other | 0 | 0 | 0 | |||||
| Total Work Load | 124 | |||||||
| Total Work Load / 25 (hours) | 4.96 | |||||||
| ECTS | 5 | |||||||
Get Syllabus PDF (Albanian) Get Syllabus PDF (English)