{"cells":[{"cell_type":"markdown","metadata":{},"source":[""]},{"cell_type":"markdown","metadata":{},"source":["--- \n","\n","---\n","\n"," 1ere partie : Créer et Modifier la base\n"," \n"," \n","---\n","\n","---\n"]},{"cell_type":"markdown","metadata":{},"source":["Dans tout ce TP nous allons utiliser une base de donnée contenant 3 tables :\n","\n","La table personnages(id : INTEGER, nom : TEXT, #dans_titre : INTEGER, age : FLOAT)\n","\n","L'attribut dans_titre de la table personnages est une clef étrangère qui fait référence à l'attribut id, clef primaire de la table titres :\n","\n","La table titres(id: INTEGER , titre:TEXT ,#auteur:INTEGER, annee_sortie: INTEGER)\n","\n","L'attribut auteur de la table titre est une clef étrangère qui fait référence à l'attribut id, clef primaire de la table auteurs :\n","\n"]},{"cell_type":"markdown","metadata":{},"source":[""]},{"cell_type":"markdown","metadata":{},"source":["## I. Création des tables\n","\n","
\n","table personnages(id, nom, #dans_titre, age) \n","\n","table titres(id, titre, #auteur, annee_sortie) \n","\n","table auteurs( id, nom, année_naiss) \n","\n"]},{"cell_type":"code","execution_count":null,"metadata":{"trusted":true},"outputs":[],"source":["-- Il faut commencer par l'auteur, puis le titre, avant d'insérer le personnage\n","\n","INSERT INTO auteurs\n","VALUES\n","(3, 'Uderzo', 1927);\n","\n","INSERT INTO titres\n","VALUES\n","(6, 'Le Grand Fossé', 3, 1980);\n","\n","INSERT INTO personnages\n","VALUES\n","(8, 'Asterix', 6, 35);"]},{"cell_type":"markdown","metadata":{},"source":["--- \n","\n","---\n","\n"," 2ème partie : Consultation\n"," \n"," \n","---\n","\n","---\n","\n","\n","