A. I. Cuza University of Iaşi

Databases

Course nameDatabases CodeCS2102
Class Computer Science, 2007 - 2010
Level Undergraduate Year 2 Semester 1 Status Compulsory
Hours per weekTotal hours per semesterTotal hours of individual workCreditsEvaluation typeTeaching language
CSLPr
2 0 2 0 56 94 5 P ro
Taught byAcademic and scientific title, name
Professor, PhD, Victor Felea
Required courses
ObjectivesThe specification of some theoretical models for databases: relational, network, hierarchical. The implementation of these models and the realisation of aplications using Visual FoxPro.
General thematicsDescription of some theoretical models for databases: relational, network, hierarchical. Data structures in systems of gestion for databases. Indexes: creations, states, updates, commands with respect to indexes. Relations between tables, their implementation in some SGBDs. Restrictions of type functional dependencies, systemes of formal rules for functional dependencies, study of functional dependencies using propositional calculus. Restrictions of type multivalued, systemes of formal rules for the class of functional and multivalued dependencies.
Seminary / Laboratory thematicsAnalysis of commands in Visual FoxPro. Choice a subject for a project. Analysis of the problem specificated in the project. Specification of realization stages for project theme. Realisation of the project on computer. Test of the project using a set of dates. Evaluation of the project.
Teaching methodsThe courses: orally, laboratory: individual work.
Bibliography
  1. D.Maier: The theory of Relational Databases, Academic Press, 1992.
  2. V.Felea: Baze de date relaţionale. Dependenţe. Ed. Univ. Iaşi, 1996.
  3. J.D.Ullman:Principles of Databases Systems, Comp. Science Press, 1990.
  4. G.Dima, M.Dima: Visual FoxPro 7.0, Ed. Teora, 2002.
  5. C.J.Date: Baze de date, traslation by Simona Preda and Titi Preda, Ed. Plus, 2005.
  6. H.Garcia-Molina, J. Ullman, J.Widom: Database Systems: The Complete Book, Ed. Prentice Hall, 2002.
  7. S.Abiteboul, R.Hull, V.Vianu: Foundations of Databases, Ed. Addison-Wesley, Reading, MA, 1995.
EvaluationconditionsL1+L2 ≥ 20, Lab ≥ 20
criteriasL1+L2+Lab ≥ 45
modesTwo writing tests during the semester (L1,L2), laboratory activity and project realisation (Lab). Max L1=30 points, max L2=30 points, max lab=40 points.
formulaThe percentages established by the university are applied.
© 2006-2008 FII | about | intranet