This repository hosts the comprehensive SQL3-Oracle Advanced Database Project, centered around the modeling and implementation of a "Gestion des salles de sport" database. The project encompasses various aspects, including schema transformation, TableSpaces and user creation, data type definitions, data manipulation methods, and insightful data querying using SQL.
-
Modélisation orientée objet (Object-Oriented Modeling): Transform the given relational schema into an object-oriented schema, represented through a class diagram.
-
Creation of TableSpaces and User: Establish two TableSpaces, SQL3_TBS and SQL3_TempTBS, and create a user 'SQL3' with appropriate privileges.
-
Langage de définition de données (Data Definition Language): Define data types based on the class diagram, considering all existing associations.
-
Méthodes de calcul (Calculation Methods): Implement methods to calculate various statistics, such as the number of sports trained by each sportif, the number of gymnases for each sport, and the average surface area of gymnases for each city.
-
Langage de manipulation de données (Data Manipulation Language): Define the necessary tables for the database.
-
Remplissage des tables (Table Population): Populate all tables with instances from the provided insert.sql file, considering necessary adaptations.
-
Langage d'interrogation de données (Data Query Language): Formulate SQL queries to answer specific questions about the database.