Bazat e të Dhënave

Print

Alma Hyra, Msc

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

Objectives

Java
Tema
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
1
The students creates a simple database.
2
The students does simple queries in the database.
3
The student is familiar with the basic components of an RDBMS.
4
The student manipulate the data of a database with SQL and MYSQL.
5
The student is capable of administering a database.
Quantity Percentage Total percent
Midterms
1 30% 30%
Quizzes
0 0% 0%
Projects
0 0% 0%
Term projects
0 0% 0%
Laboratories
0 0% 0%
Class participation
1 10% 10%
Total term evaluation percent
40%
Final exam percent
60%
Total percent
100%
Quantity Duration (hours) Total (hours)
Course duration (including exam weeks)
16 4 64
Off class study hours
14 3 42
Duties
0 10 0
Midterms
1 4 4
Final exam
1 5 5
Other
0 0 0
Total workLoad
115
Total workload / 25 (hours)
4.60
ECTS
5.00