Babes-Bolyai University of Cluj-Napoca
Faculty of Mathematics and Computer Science
Study Cycle: Graduate
SUBJECT

Code	Subject	
MIH0002	Databases	

Section	Semester	Hours: C+S+L	Category	Type	
Computer Science	3	2+1+2	speciality	compulsory	
Mathematics and Computer Science	5	2+1+2	speciality	compulsory	
Information engineering	3	2+2+2		compulsory	

Teaching Staff in Charge	Prof. ŢÂMBULEA Leon, Ph.D., leon@cs.ubbcluj.ro
Assoc.Prof. VARGA Viorica, Ph.D., ivarga@cs.ubbcluj.ro
Lect. SUCIU Dan Mircea, Ph.D., tzutzu@cs.ubbcluj.ro
Lect. TRÎMBITAS Gabriela, Ph.D., gabitr@cs.ubbcluj.ro
Lect. CÂMPAN Alina, Ph.D., alina@cs.ubbcluj.ro	
Aims	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.	
Content	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. 
8. Optimizing query databases.	
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.	
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%