Database Management Systems

This module aims at helping students in designing relational databases management systems (RDBMS). It focuses on methodological skills for conceptual and logical modeling (UML) and on technological skills for RDBMS development (SQL).It bases on theoretical courses,theoretical exercises,practical exercises on Access and MySQL,auto-evaluation through MCQs. This module XF17 of UTC is a version of NF17 for non-francophone students.

Disciplines : Fichiers et bases de données,Catégories particulières de fichiers et de bases de données
Mots-clés : database management systems,DBMS,UML class diagrams,Unified Modeling Language,conceptual schema,database design,relational  model,SQL language,relational normalisation,functional dependency,redundancy,primary key,data control,MySQL technology,Access technology,transaction management,database optimization
Type de document : texte,image,ressource interactive
Type de ressource : lecture,exercise,self assessment
Niveau : higher education,bac+3
Publics visés : teacher,learner
Proposition d'utilisation : Pedagogical objectives: To understand the general concepts of RDBMS To be able to design a database using UML To be able implement a database using SQL To experiment the global design of a database through a team project
Auteurs ou éditeurs : Stephane Crozat,Université de Technologie de Compiègne