[sql] aa
Viewer
- CREATE DATABASE BD_Banques;
- CREATE TABLE agence(
- NumAgence INT(4) PRIMARY KEY,
- Nom VARCHAR(30) NOT NULL,
- Ville VARCHAR(25));
- CREATE TABLE client(
- NumClient INT(5) PRIMARY KEY,
- Nom VARCHAR(50) NOT NULL,
- Ville VARCHAR(25) notnull);
- CREATE TABLE compte(
- NumCompte INT(6) PRIMARY KEY,
- NumAgence INT(4) NOT NULL REFERENCES agence(NumAgence) ,
- NumClient INT(5) NOT NULL REFERENCES client(NumClient),
- TypeCompte VARCHAR(20) CHECK(TypeCompte IN (’Epargne’’, ‘’courant’’)),
- Solde REAL(10,3));
- CREATE TABLE emprunt(
- NumEmprunt INT(6) PRIMARY KEY,
- NumAg INT(4) NOT NULL REFERENCES agence(NumAgence) ,
- NumCl INT(5) NOT NULL REFERENCES client(NumClient),
- Montant REAL(10,3) NOT NULL,
- Date_Emprunt datetime DEFAULT ‘2021-01-01 00:00:00’);
Editor
You can edit this paste and save as new:
File Description
- aa
- Paste Code
- 12 May-2021
- 772 Bytes
You can Share it:
Latest Code Pastes