- 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
-
Understand the role of databases in managing and storing information. Distinguish between a database, a database management system (DBMS), and a relational database. Understand data modeling and database design. Create entity-relationship (ER) diagrams and convert them into relational tables. Learn to use SQL for creating tables, inserting, and modifying data. Use SQL commands for querying, updating, deleting, and managing data (SELECT, INSERT, UPDATE, DELETE). Explore concepts of data normalization and denormalization to eliminate redundancy and improve efficiency. Apply normalization forms up to the fourth normal form (4NF). Master methods for optimizing SQL query performance. Understand the use of indexes, query speed, and system resource management. Learn about transactions and how to maintain data integrity. Understand the ACID properties (Atomicity, Consistency, Isolation, Durability) and their implementation in DBMS. Study techniques for securing data and controlling access to databases. Learn methods for data backup and recovery. Understand user management and privilege control. Learn procedures for database maintenance and performance optimization. Understand distributed databases and distributed database management systems: Explore the concept of distributed databases and data synchronization across multiple systems. Examine the use of databases in modern applications, such as content management systems (CMS), e-commerce services, etc.
- 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 20% 20%
- Term projects
- 0 0% 0%
- Laboratories
- 1 10% 10%
- Class participation
- 1 10% 10%
- Total term evaluation percent
- 65%
- Final exam percent
- 35%
- Total percent
- 100%
- Quantity Duration (hours) Total (hours)
- Course duration (including exam weeks)
- 16 4 64
- Off class study hours
- 14 3 42
- Duties
- 1 0 0
- Midterms
- 1 10 10
- Final exam
- 1 10 10
- Other
- 0 0 0
- Total workLoad
- 126
- Total workload / 25 (hours)
- 5.04
- ECTS
- 5.00