Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE MASTER;
- GO
- CREATE DATABASE Bank;
- GO
- USE Bank;
- CREATE TABLE AccountHolders
- (
- Id INT NOT NULL,
- FirstName VARCHAR(50) NOT NULL,
- LastName VARCHAR(50) NOT NULL,
- SSN CHAR(10) NOT NULL,
- CONSTRAINT PK_AccountHolders PRIMARY KEY (Id)
- );
- CREATE TABLE Accounts
- (
- Id INT NOT NULL,
- AccountHolderId INT NOT NULL,
- Balance DECIMAL(19, 4) DEFAULT 0,
- CONSTRAINT PK_Accounts PRIMARY KEY (Id),
- CONSTRAINT FK_Accounts_AccountHolders FOREIGN KEY (AccountHolderId) REFERENCES AccountHolders(Id)
- );
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (1, 'Susan', 'Cane', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (2, 'Kim', 'Novac', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (3, 'Jimmy', 'Henderson', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (4, 'Steve', 'Stevenson', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (5, 'Bjorn', 'Sweden', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (6, 'Kiril', 'Petrov', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (7, 'Petar', 'Kirilov', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (8, 'Michka', 'Tsekova', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (9, 'Zlatina', 'Pateva', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (10, 'Monika', 'Miteva', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (11, 'Zlatko', 'Zlatyov', '1234567890');
- INSERT INTO AccountHolders (Id, FirstName, LastName, SSN) VALUES (12, 'Petko', 'Petkov Junior', '1234567890');
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (1, 1, 123.12);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (2, 3, 4354.23);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (3, 12, 6546543.23);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (4, 9, 15345.64);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (5, 11, 36521.20);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (6, 8, 5436.34);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (7, 10, 565649.20);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (8, 11, 999453.50);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (9, 1, 5349758.23);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (10, 2, 543.30);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (11, 3, 10.20);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (12, 7, 245656.23);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (13, 5, 5435.32);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (14, 4, 1.23);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (15, 6, 0.19);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (16, 2, 5345.34);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (17, 11, 76653.20);
- INSERT INTO Accounts (Id, AccountHolderId, Balance) VALUES (18, 1, 235469.89);
Add Comment
Please, Sign In to add comment