PMG2022/DB Beleg/Carl

Wiki-Quelltext dieser Seite.

<language>SQL</language>
Sammelkarten Datenbank mit verschiedenen Karten, Kunden und Interresenten


ERM und Relationenmodel kommen später nochmal ordentlich aufgeschrieben, sind aber schon Fertig(grob).

<code id="62344745ed69f">
DROP TABLE IF EXISTS phy_Karte;
CREATE TABLE phy_Karte (
  ID varchar(6),
  KartenID varchar(9),
  KundenID varchar(8),
  Zustand varchar(10),
  Wert decimal(10)
); 

Insert into phy_Karte Values ("000000", "000000", "00000", "gut",0.27) ;
Insert into phy_Karte Values ("000001", "000001", "00000", "schlecht",1) ;

Insert into phy_Karte Values ("000002", "000003", "00001", "mittel",6) ;
Insert into phy_Karte Values ("000005", "000003", "00002", "schlecht",2) ;

Insert into phy_Karte Values ("000006", "000003", "00002", "gut",6) ;

Insert into phy_Karte Values ("000007", "000003", "00003", "sehr gut",15) ;

Insert into phy_Karte Values ("000008", "000003", "00002", "gut",6) ;
Insert into phy_Karte Values ("000009", "000003", "00000", "gut",7) ;
Insert into phy_Karte Values ("0000010", "000003", "00000", "super",19.99) ;



Insert into phy_Karte Values ("000003", "000002", "00001", "mittel",4.15) ;

Insert into phy_Karte Values ("000004", "000004", "00001", "super",220000) ;



DROP TABLE IF EXISTS Kunde;
CREATE TABLE Kunde(
  ID varchar(8),
  Name varchar(20),
  Vorname varchar(20),
  Wohnort varchar(40),
  Strasse varchar(40),
  Land varchar(20),
  Hausnummer varchar(3)
); 



Insert into Kunde Values ("00000", "Mueller", "Heinz","Dresden","Lindenstrasse", "Germany", "5");
Insert into Kunde Values ("00001", "Smith", "Will","London","Downing_street", "UK", "5");
Insert into Kunde Values ("00002", "Lillard", "Samuel","Housten","Houstenroad", "USA", "5");
Insert into Kunde Values ("00003", "Rotriges", "Fernando","Madrid","Gran_Via", "Spain", "5");

DROP TABLE IF EXISTS vir_Karte;
CREATE TABLE vir_Karte (
  ID varchar(9),
  MarkenID varchar(5),
  Name varchar(25),
  Erscheinungsjahr varchar(4)
);



Insert into vir_Karte Values ("000000", "00001", "Gilde Lotus", "2018"); 
Insert into vir_Karte Values ("000001", "00002", "General Grievous", "2010"); 
Insert into vir_Karte Values ("000002", "00002", "Obi-Wan-Kenobi", "2010"); 
Insert into vir_Karte Values ("000003", "00000", "Charizard", "2022");
Insert into vir_Karte Values ("000004", "00000", "Charizard", "1996"); 



DROP TABLE IF EXISTS Interesse;
CREATE TABLE Interesse (
  ID varchar(9),
  ExemplarID varchar(9),
  KundenID varchar(9)
);


Insert into Interesse Values ("000000", "000004", "00001");
Insert into Interesse Values ("000001", "000003", "00000"); 
Insert into Interesse Values ("000002", "000001", "00003");  

DROP TABLE IF EXISTS Marke;
CREATE TABLE Marke(
  ID varchar(5),
  HerausgeberID varchar(9),
  Name varchar(15),
  Erscheinungsjahr varchar(4)
);

Insert into Marke Values ("00000", "00000", "Pokemon","1996") ;
Insert into Marke Values ("00001", "00000", "Magic:The_Gathering","1993") ;
Insert into Marke Values ("00002", "00001", "Star_Wars","2010") ;

DROP TABLE IF EXISTS Herausgeber;
CREATE TABLE Herausgeber(
  ID varchar(5),
  Firmensitz varchar(15),
  Name varchar(20),
  Gruendungsjahr varchar(4)
);


Insert into Herausgeber Values ("00000", "Renton", "Wizards_of_the_Coast","1990") ;
Insert into Herausgeber Values ("00001", "New_York_City", "Topps","1938") ;
</code>

<run id="623448a2f3540">

</run>