Bazat e të Dhënave

Print

Klevis Topi, 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

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!

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 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
Quantity Percentage Total percent
Midterms
1 15% 15%
Quizzes
2 10% 20%
Projects
0 0% 0%
Term projects
0 0% 0%
Laboratories
0 0% 0%
Class participation
1 5% 5%
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 4 56
Duties
0 0 0
Midterms
1 2 2
Final exam
1 2 2
Other
0 0 0
Total workLoad
124
Total workload / 25 (hours)
4.96
ECTS
5.00