Databases

Introduction to the basic concepts of databases and familiarization for developing databases using database management software (DBMS)

Objectives

To equip the student / student all the knowledge enabling it to recognize and distinguish the advantages of applications developed in an environment Data Base Management System (DBMS - DBMS) and be able to implement simple applications in environments DBMS. The student / student should be able to: • Defines the data types in the tables of a shape. • Know and recognize the types of relationships that exist. • Distinguishes whether two fields in a table are functionally dependent. • Know what is key. • Specifies key of a table using the functional dependencies identified in the table. • normalized tables of a DB scheme and recognizes an already normalized shape. • Know what is referential integrity in two affine tables that you can create two affine tables not violated the integrity rules. • Create and execute simple questions to the management software. • Designs a properly NW (without repetition, with consistency, ease of insertion-deletion of records, etc.) • Identifies a properly designed NW and vice versa.

Prerequisites

Use of search engines. Use of email. Familiarity with spreadsheet software.

Syllabus

Introduction to information storage Data structures Relational databases Tables, queries, forms. accessing data Designing a database Introduction and data interface Create questions The SQL language Create a database for the elements of a parish