databases lab 5

Lab 4/Insert data.txt

Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1000, 'Mohammad', 'Gutkowski', '123 Dunkin Rd', 'Pittsburgh', 'PA', '15237', '4123334455', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1001, 'Tom', 'Hanks', '123 Tyler Rd', 'Pittsburgh', 'PA', '15237', '4123334466', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1002, 'Mark', 'Ingram', '123 McMuffin Rd', 'Pittsburgh', 'PA', '15237', '4123335566', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1003, 'Antonio', 'Rotherburger', '123 Summer Rd', 'Pittsburgh', 'PA', '15237', '4123334477', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1004, 'Jared', 'Kassel', '123 Winter Rd', 'Pittsburgh', 'PA', '15237', '4123334488', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1005, 'Donny', 'Frazier', '333 Tyler Rd', 'Pittsburgh', 'PA', '15237', '4123334412', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1006, 'Drew', 'Barbin', '565 Tyler Rd', 'Pittsburgh', 'PA', '15237', '4123334423', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1007, 'Jess', 'Baker', '321 Holand Rd', 'Pittsburgh', 'PA', '15237', '4123334434', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1008, 'Kristen', 'William', '123 Wankful Rd', 'Pittsburgh', 'PA', '15237', '4123334445', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1009, 'Jack', 'hunter', '123 SunSet Rd', 'Pittsburgh', 'PA', '15237', '41233344567', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1010, 'Brandon', 'Shay', '123 Baker Rd', 'Pittsburgh', 'PA', '15237', '4123334478', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1011, 'Ahmed', 'Smith', '123 Dossey Rd', 'Pittsburgh', 'PA', '15237', '4123334469', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1012,'Ali', 'Kamel', '123 Kammelnose Rd', 'Pittsburgh', 'PA', '15237', '4123334233', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1013, 'Tiger', 'Groupe', '123 Winterpeek Rd', 'Pittsburgh', 'PA', '15237', '4123334654', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1014, 'Martty', 'Powel', '123 Sanjuan Rd', 'Pittsburgh', 'PA', '15237', '4123334789', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1015, 'Rick', 'McCown', '123 SanDrafted Rd', 'Pittsburgh', 'PA', '15237', '4123334090', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1016, 'Jhon', 'FitzWilliam', '123 Wenchester Rd', 'Pittsburgh', 'PA', '15237', '4123334400', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1017, 'David', 'Berkhamp', '123 Lopy Rd', 'Pittsburgh', 'PA', '15237', '4123334980', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1018, 'Matt', 'Jones', '123 Somatra Rd', 'Pittsburgh', 'PA', '15237', '4123334120', '[email protected]') Insert into Customers (CustomerID, FirstName, LastName, Address, City, State, ZipCode, PhoneNumber, Email) Values (1019, 'Spencer', 'Ware', '123 Wender Rd', 'Pittsburgh', 'PA', '15237', '41233344220', '[email protected]') Insert into AccountType (AccountTypeID, Description) Values (101, 'Checking') Insert into AccountType (AccountTypeID, Description) Values (102, 'Checking'); Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (200, 1000, 101, '$150') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (201, 1001, 101, '$250') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (202, 1002, 102, '$300') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (203, 1003, 101, '$1000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (204, 1004, 101, '$1500') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (205, 1005, 102, '$5000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (206, 1006, 101, '$7000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (207, 1007, 101, '$80000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (208, 1008, 101, '$9050') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (209, 1009, 102, '$450000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (210, 1010, 102, '$500000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (211, 1011, 101, '$550000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (212, 1012, 101, '$600000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (213, 1013, 102, '$650000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (214, 1014, 101, '$700000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (215, 1015, 101, '$750000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (216, 1016, 101, '$800000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (217, 1017, 101, '$850000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (218, 1018, 102, '$900000') Insert into Accounts (AccountID, CustomerID, AccountTypeID, CurrentBalance) Values (219, 1019, 101, '$1000000'); Insert into TransactionType (TransactionTypeID, Description) Values (10001, 'Withdraw') Insert into TransactionType (TransactionTypeID, Description) Values (10002, 'Balance') Insert into TransactionType (TransactionTypeID, Description) Values (10003, 'Deposit') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3001, 200, 10001, '$100', '10/13/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3002, 201, 10001, '$60', '10/13/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3003, 202, 10001, '$140', '10/13/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3004, 203, 10001, '$60', '10/13/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3005, 204, 10001, '$240', '10/14/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3006, 205, 10001, '$340', '10/15/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3007, 206, 10001, '$440', '10/16/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3008, 207, 10001, '$1000', '10/16/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3009, 208, 10001, '$120', '10/17/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3010, 209, 10001, '$5000', '10/18/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3011, 210, 10002, '$500000', '10/18/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3012, 211, 10002, '$550000', '10/18/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3013, 212, 10002, '$600000', '10/19/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3014, 213, 10002, '$650000', '10/20/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3015, 214, 10002, '$700000', '10/21/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3016, 215, 10003, '$5000', '10/21/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3017, 216, 10003, '$10000', '10/21/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3018, 217, 10003, '$15000', '10/24/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3019, 218, 10003, '$2500', '10/25/2018') Insert into Transactions (TransactionID, AccountID, TransactionTypeID, Ammount, DateOfTransaction) Values (3020, 219, 10003, '$58000', '10/26/2018');