SQL

[beeclo9]

CREATE TABLE Employee
(
Eid INT NOT NULL PRIMARY KEY,
Elevel INT NOT NULL,
Elastname VARCHAR(15),
Efirstname VARCHAR(15),
Eaddress VARCHAR(20),
Epno INT,
Essn INT NOT NULL,

);

CREATE TABLE Account
(
Anumber INT NOT NULL PRIMARY KEY,
Abalance FLOAT(8) NOT NULL,

);

CREATE TABLE Customer
(
Cssn INT NOT NULL ,
Clastname VARCHAR(15),
Cfirstname VARCHAR(15),
Cbdate DATE NOT NULL,
Caddress VARCHAR(15),
Cpno INT,
Anumber INT NOT NULL,
FOREIGN KEY (Anumber) references Account(Anumber)
);

CREATE TABLE AccountStatement
(
Anumber INT NOT NULL PRIMARY KEY,
Smodate DATE,
Sbalance FLOAT(8),
Sdifference FLOAT(8),
Cssn INT NOT NULL
FOREIGN KEY (Anumber) references Account(Anumber)

);