fork download
copy 
  1. CREATE DATABASE universite;
  2. USE universite;
  3.  
  4. -- ======================
  5. -- TABLES UNIVERSITE
  6. -- ======================
  7.  
  8. CREATE TABLE Etudiant(
  9. idEtu INT PRIMARY KEY,
  10. nom VARCHAR(50),
  11. prenom VARCHAR(50),
  12. ville VARCHAR(50)
  13. );
  14.  
  15. CREATE TABLE Cours(
  16. idCours INT PRIMARY KEY,
  17. intitule VARCHAR(50),
  18. credits INT
  19. );
  20.  
  21. CREATE TABLE Inscription(
  22. idEtu INT,
  23. idCours INT,
  24. note FLOAT,
  25. PRIMARY KEY(idEtu, idCours),
  26. FOREIGN KEY(idEtu) REFERENCES Etudiant(idEtu),
  27. FOREIGN KEY(idCours) REFERENCES Cours(idCours)
  28. );
  29.  
  30. CREATE TABLE Enseignant(
  31. idEns INT PRIMARY KEY,
  32. nom VARCHAR(50),
  33. specialite VARCHAR(50)
  34. );
  35.  
  36. CREATE TABLE Enseigne(
  37. idEns INT,
  38. idCours INT,
  39. PRIMARY KEY(idEns,idCours),
  40. FOREIGN KEY(idEns) REFERENCES Enseignant(idEns),
  41. FOREIGN KEY(idCours) REFERENCES Cours(idCours)
  42. );
  43.  
  44. -- INSERT DATA
  45.  
  46. INSERT INTO Etudiant VALUES
  47. (1,'Ali','Karim','Casablanca'),
  48. (2,'Sara','Amine','Rabat'),
  49. (3,'Yassine','Omar','Fes'),
  50. (4,'Lina','Hajar','Marrakech'),
  51. (5,'Nadia','Salma','Agadir');
  52.  
  53. INSERT INTO Cours VALUES
  54. (1,'BD',4),
  55. (2,'IA',5),
  56. (3,'Reseaux',3),
  57. (4,'Algo',4);
  58.  
  59. INSERT INTO Inscription VALUES
  60. (1,1,15),
  61. (1,2,14),
  62. (2,1,12),
  63. (3,3,16),
  64. (4,2,10);
  65.  
  66. INSERT INTO Enseignant VALUES
  67. (1,'ProfA','BD'),
  68. (2,'ProfB','IA'),
  69. (3,'ProfC','Reseaux');
  70.  
  71. INSERT INTO Enseigne VALUES
  72. (1,1),
  73. (2,2),
  74. (3,3);
  75.  
  76.  
  77. CREATE DATABASE hospital;
  78. USE hospital;
  79.  
  80. -- ======================
  81. -- TABLES HOPITAL
  82. -- ======================
  83.  
  84. CREATE TABLE Patient(
  85. idPat INT PRIMARY KEY,
  86. nom VARCHAR(50),
  87. prenom VARCHAR(50),
  88. age INT
  89. );
  90.  
  91. CREATE TABLE Medecin(
  92. idMed INT PRIMARY KEY,
  93. nom VARCHAR(50),
  94. specialite VARCHAR(50)
  95. );
  96.  
  97. CREATE TABLE Consultation(
  98. idCons INT PRIMARY KEY,
  99. date DATE,
  100. idPat INT,
  101. idMed INT,
  102. FOREIGN KEY(idPat) REFERENCES Patient(idPat),
  103. FOREIGN KEY(idMed) REFERENCES Medecin(idMed)
  104. );
  105.  
  106. CREATE TABLE Traitement(
  107. idTrait INT PRIMARY KEY,
  108. nomTraitement VARCHAR(50),
  109. cout FLOAT,
  110. idCons INT,
  111. FOREIGN KEY(idCons) REFERENCES Consultation(idCons)
  112. );
  113.  
  114. -- INSERT DATA
  115.  
  116. INSERT INTO Patient VALUES
  117. (1,'Ali','Karim',30),
  118. (2,'Sara','Amine',25),
  119. (3,'Omar','Yassine',40),
  120. (4,'Hajar','Lina',28);
  121.  
  122. INSERT INTO Medecin VALUES
  123. (1,'DrA','Cardio'),
  124. (2,'DrB','Generaliste'),
  125. (3,'DrC','Dermato');
  126.  
  127. INSERT INTO Consultation VALUES
  128. (1,'2024-01-10',1,1),
  129. (2,'2024-02-15',2,2),
  130. (3,'2024-03-20',1,2);
  131.  
  132. INSERT INTO Traitement VALUES
  133. (1,'Med1',200,1),
  134. (2,'Med2',150,2);
  135.  
Success #stdin #stdout #stderr 0.01s 5320KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: near "DATABASE": syntax error
Error: near line 2: near "USE": syntax error
Error: near line 77: near "DATABASE": syntax error
Error: near line 78: near "USE": syntax error
https://ideone.com/8NxmjI
language:
SQLite (sqlite 3.27.2)
created:
7 hours ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!