bispo-daniel
diff --git a/‎atmDB/atmDB--DDL.sql
Copy file name to clipboard
+20Lines changed: 20 additions & 0 deletions b/‎atmDB/atmDB--DDL.sql
Copy file name to clipboard
+20Lines changed: 20 additions & 0 deletions
diff --git a/‎atmDB/atmDB--DML.sql
Copy file name to clipboard
+14Lines changed: 14 additions & 0 deletions b/‎atmDB/atmDB--DML.sql
Copy file name to clipboard
+14Lines changed: 14 additions & 0 deletions
diff --git a/‎atmDB/atmDB--DQL.sql
Copy file name to clipboard
+11Lines changed: 11 additions & 0 deletions b/‎atmDB/atmDB--DQL.sql
Copy file name to clipboard
+11Lines changed: 11 additions & 0 deletions
@@ -0,0 +1,20 @@
+CREATE DATABASE IF NOT EXISTS atmDB;
+USE atmDB;
+
+/*
+describe account;
+drop database atmDB;
+*/
+
+CREATE TABLE IF NOT EXISTS customer (
+    id int not null PRIMARY KEY,
+    name varchar(100) not null
+);
+
+CREATE TABLE IF NOT EXISTS account (
+     id int not null PRIMARY KEY,
+     balance double not null,
+     pass varchar(8) not null,
+     customer_id_fk int not null,
+     foreign key (customer_id_fk) references customer(id)
+ )	
@@ -0,0 +1,14 @@
+USE atmDB;
+
+INSERT INTO customer (id, name) VALUES 
+(1, "João"),
+(2, "Maria"),
+(3, "José");
+
+INSERT INTO account (id, balance, pass, customer_id_fk) VALUES
+(556, 0, "1234", 1),
+(762, 100, "qwerty", 2),
+(338, 50, "1q2w3e", 3),
+(1001, 1, "0000", 3);
+
+delete from customer where id = 3;
@@ -0,0 +1,11 @@
+USE atmDB;
+
+select * from customer;
+select * from account;
+
+select a.account_number, a.pass,
+a.balance,
+c.name
+from account a 
+join customer c
+on c.id = a.customer_id_fk;