"Babes-Bolyai" University of Cluj-Napoca
Faculty of Mathematics and Computer Science

Databases (1)
Code
Semes-
ter
Hours: C+S+L
Type
Section
MI006
5
2+1+2
compulsory
Informatica
MI006
5
2+1+2
compulsory
Matematică-Informatică
Teaching Staff in Charge
Prof. ŢÂMBULEA Leon, Ph.D.,  leoncs.ubbcluj.ro
Assoc.Prof. VARGA Viorica, Ph.D.,  ivargacs.ubbcluj.ro
Lect. SUCIU Dan Mircea, Ph.D.,  tzutzucs.ubbcluj.ro
Lect. TRÎMBITAS Gabriela, Ph.D.,  gabitrcs.ubbcluj.ro
Lect. CÂMPAN Alina, Ph.D.,  alinacs.ubbcluj.ro
Asist. SABAU Andreea,  deiushcs.ubbcluj.ro
Asist. COSTA Ciprian,  costacs.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.
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%
Links: Syllabus for all subjects
Romanian version for this subject
Rtf format for this subject