Subject: Databases (1)	Code: MI006	

Semester	 Hours: C+S+L	Type	 Section	
5	2+1+2	compulsory	Computer Science	
5	2+1+2	compulsory	Mathematics-Computer Science	

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
Asist. SABAU Andreea, deiush@cs.ubbcluj.ro
Asist. COSTA Ciprian, costa@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 gestion in Visual Basic	
Content	1. The evolution of Data Bases Management Systems.
2. Databases concepts.
3. Data structures in databases.
4. Database models.
5. Relational data model. Normalization for relational data model. Query languages. Relational algebra. Relational calculus. SQL language. 
6. Distributed database.
7. Access control and security in a database.
8. Client/server technology in database. 
9. Database in Visual Basic.
10. Reports	
Selective References	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, 1995.
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. 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