Universitatea Babeş-Bolyai Cluj-Napoca
Facultatea de Matematică şi Informatică
Ciclul de studii: Licenţă
Domeniul: Calculatoare şi tehnologia informaţiei
Programul de studii: Ingineria informatiei - in limba engleza
Limba de predare: Engleză

SYLLABUS

I. General data
Code	Subject	
MIH0002	Databases	

Semester	Hours: C+S+L+P	Category	Status	
3	2+1+2+0	speciality	compulsory	

II. Full status faculty members
Name and	Scientific	Didactic	Chair	Type of activity	
surname	title	title		C	S	L	
SUCIU Dan Mircea	Ph.D.	Lect.	Computer Systems	*			

Associated faculty members
Name and	Scientific	Institution	Type of	Type of activity	
surname	title		position	C	S	L	

III. Course objectives
1. To get acquainted with the general concepts regarding the data bases.
2. To get acquainted with the data models, especially the relational.
3. Database management in .Net.	

IV. Course contents
1. Databases concepts.
2. Architecture of databases management systems.
3. Relational data model. Normalization for relational data model. 
4. Query languages. Relational algebra. Relational calculus. 
5. Database management with SQL language. 
6. Access control and security in a database.
7. Physical structure of databases. Organize of files. Sequential organization. Indexed-sequential organization. Storing the file as a binary tree. Storing the file in the form of a 2-3 tree. Storing the file as a B-tree. Organization directly. Retrieving the values of several attributes. 	

V. Bibliography
1. AHO, A., HOPCROFT, J., ULLMAN, J., Data Structures and Algorithms. Addison-Wesley, Reading, Massachusetts, 1983.
2. BÂSCA, O., Baze de date. Editura All, Bucuresti 1997.
3. DATE, C.J., An Introduction to Data Base Systems. Addison Wesley, Reading, MA, 2004.
4. HELMAN, P., The Science of Database Management. Richard D. IRWIN, Inc., 1994.
5. KORTH, H.F., SILBERSCHATZ, A., Data Base System Concepts. McGraw-Hill Book Compagny, 1986.
6. Microsoft Visual Basic 6.0. Ghidul programatorului. Editura Teora, Bucuresti 1998.
7. RAMAKRISHNAN, R., Database Manegement Systems. McGraw-Hill, 1998.
8. Silberschatz A., Kortz H., Sudarshan S., Database System Concepts, McGraw-Hill, 2002.
9. TAMBULEA, L. Baze de date, Litografiat Cluj-Napoca 2003.	

VI. Thematic of didactic activities per weeks
1.	Introduction in Databases
2.	Relational Databases
3.	SQL Queries
4.	Relational algebra
5.	Schema Refinement
6.	Normal Forms
7.	Entity-Relational Model
8.	Database design
9.	Physical structure of DBs
10.	Indexes
11.	Trees
12.	Hash-Files
13.	Object-Oriented Databases
14.	Object-Relational Databases	

VII. Didactic methods used

VIII. Assessment
The seminar work, laboratory and a practical work will each represent 50% of the final grade. The final exam will be written, representing the remaining 50%

Course materials are published at:
   http://www.cs.ubbcluj.ro/~tzutzu/Didactic/DatabasesEn.htm	

IX. Additional references

	Dean,							Chair head,

	Date,							Course responsible,
								Lect. SUCIU Dan Mircea, Ph.D.