Bases de données
153 documents à télécharger gratuitement
Cours, examens, TD, TP et exercices de bases de données. Thèmes couverts : SQL, MySQL, Oracle, modèle relationnel, SGBD, MERISE.
This document serves as an introduction to PL/SQL, a procedural language that extends SQL, specifically within the Oracle environment. It covers essential features, programming conventions, block structures, syntax rules, and various programming structures within PL/SQL. The document is aimed at helping learners understand the practical aspect of PL/SQL programming.
Ce document présente une introduction au langage PL/SQL, une extension procédurale de SQL propre à Oracle. Il décrit les caractéristiques du PL/SQL, y compris la structure des blocs PL/SQL, les conventions de programmation, et les types de variables. Les concepts de déclarations, d'exécution, et de gestion des erreurs sont également abordés.
This document provides an overview of database views, indexes, and sequences. It explains the definitions, creation, usage, and limitations of each element in SQL database management. The document contains practical examples and syntax for implementing these concepts.
This document provides a detailed explanation of the relational model in database systems, originally defined by Ted Codd in 1970 and widely adopted in commercial database systems like Oracle, DB2, and SQL Server. It explains the foundational components of the relational model, including relations (tables), attributes (columns), and tuples (rows). The document also details the translation process from the Entity-Attribute model to the relational model, describing how entities, associations, and attributes are mapped. Integrity constraints such as primary keys, foreign keys, referential inte...
This document discusses the development of a web application aimed at facilitating electronic data exchange between TTS and CNAM, motivated by the Tunisian administration's trend towards new technologies. The application utilizes ASP.NET and SQL Server technologies to enhance employee performance. The work acknowledges the support of mentors and outlines the structure of the project, including its specifications and analysis.
This document outlines various domains, predicates, and clauses related to identity and food items. The first section details personal identification predicates like name, age, and city of residence. The second section lists menu items categorized by type along with their prices.
This course provides an introduction to PL/SQL, a procedural language used in Oracle. It covers the structure of PL/SQL blocks, variable declarations, SQL integration, and advanced features such as exceptions and cursors. Students will learn how to write and execute PL/SQL code effectively.
This document outlines the specifications for a database exam focused on educational data. It includes details for creating tables and constraints in a SQL database, as well as specific queries to retrieve information about students, schools, and teachers. Tasks include table creation, data insertion, and various querying scenarios.
This document outlines an examination on database design concepts. It includes exercises on functional dependencies, relational schemas, and SQL queries. Students are required to analyze and interpret database models, constraints, and design diagrams.