- Code
- CMP 217
- Name
- Databases
- Semester
- 3
- Lecture hours
- 3.00
- Seminar hours
- 0.00
- Laborator hours
- 1.00
- Credits
- 3.50
- ECTS
- 5.00
- 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
-
Create a DB
- Java
- Tema
- 1
- Introduction to Database Systems, Database System Concepts
- 2
- Entity-Relationship Model
- 3
- Enhanced Entity Relationship Model
- 4
- Relational Data Model
- 5
- Normalization
- 6
- Normalization
- 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
- 1
- Studenti arrin të krijojë një bazë të dhenash të thjeshtë.
- 2
- Studenti arrin të bëj query të thjeshta në databazë.
- 3
- Studenti njihet me komponentët bazë të një RDBMS.
- 4
- Studenti arrin të manipulojnë të dhënat e një bazë të dhënash me SQL dhe MySQL.
- 5
- Studenti është i aftë të administrojë një bazë të dhënash.
- Quantity Percentage Total percent
- Midterms
- 1 25% 25%
- Quizzes
- 0 0% 0%
- Projects
- 1 15% 15%
- Term projects
- 0 0% 0%
- Laboratories
- 1 10% 10%
- Class participation
- 1 10% 10%
- Total term evaluation percent
- 60%
- Final exam percent
- 40%
- Total percent
- 100%
- Quantity Duration (hours) Total (hours)
- Course duration (including exam weeks)
- 16 4 64
- Off class study hours
- 14 1 14
- Duties
- 1 20 20
- Midterms
- 1 10 10
- Final exam
- 1 20 20
- Other
- 0 0 0
- Total workLoad
- 128
- Total workload / 25 (hours)
- 5.12
- ECTS
- 5.00