SQLite format 3@ b b-%   m 4    tableaccountaccountCREATE TABLE account (account_id integer primary key autoincrement not null, product_cd varchar(10) not null, cust_id integer not null, open_date date not null, close_date date, last_activity_date date, status text not null, open_branch_id integer, open_emp_id integer, avail_balance float(10,2), pending_balance float(10,2), check(status = 'ACTIVE' or status = 'CLOSED' or status = 'FROZEN') constraint fk_product_cd foreign key (product_cd) references product (product_cd), constraint fk_a_cust_id foreign key (cust_id) references customer (cust_id), constraint fk_a_branch_id foreign key (open_branch_id) references branch (branch_id), constraint fk_a_emp_id foreign key (open_emp_id) references employee (emp_id) )W tableofficerofficer CREATE TABLE officer (officer_id integer primary key autoincrement not null, cust_id integer not null, fname varchar(30) not null, lname varchar(30) not null, title varchar(20), start_date date not null, end_date date, constraint fk_o_cust_id foreign key (cust_id) references business (cust_id) ) qtablebusinessbusiness CREATE TABLE business (cust_id integer primary key autoincrement not null, name varchar(40) not null, state_id varchar(10) not null, incorp_date date, constraint fk_b_cust_id foreign key (cust_id) references customer (cust_id) ) !!otableindividualindividual CREATE TABLE individual (cust_id integer primary key autoincrement not null, fname varchar(30) not null, lname varchar(30) not null, birth_date date, constraint fk_i_cust_id foreign key (cust_id) references customer (cust_id) )6 ?tablecustomercustomer CREATE TABLE customer (cust_id integer primary key autoincrement not null, fed_id varchar(12) not null, cust_type_cd text not null, address varchar(30), city varchar(20), state varchar(20), postal_code varchar(10), check (cust_type_cd = 'I' or cust_type_cd = 'B') )ctableproductproductCREATE TABLE product (product_cd varchar(10) not null, name varchar(50) not null, product_type_cd varchar(10) not null, date_offered date, date_retired date, constraint fk_product_type_cd foreign key (product_type_cd) references product_type (product_type_cd), constraint pk_product primary key (product_cd) )-Aindexsqlite_autoindex_product_1product A%%Etableproduct_typeproduct_typeCREATE TABLE product_type (product_type_cd varchar(10) not null, name varchar(50) not null, constraint pk_product_type primary key (product_type_cd) )7K%indexsqlite_autoindex_product_type_1product_type@StableemployeeemployeeCREATE TABLE employee (emp_id integer primary key autoincrement not null, fname varchar(20) not null, lname varchar(20) not null, start_date date not null, end_date date, superior_emp_id integer, dept_id integer, title varchar(20), assigned_branch_id integer, constraint fk_e_emp_id foreign key (superior_emp_id) references employee (emp_id), constraint fk_dept_id foreign key (dept_id) references department (dept_id), constraint fk_e_branch_id foreign key (assigned_branch_id) references branch (branch_id) )UtablebranchbranchCREATE TABLE branch (branch_id integer primary key autoincrement not null, name varchar(20) not null, address varchar(30), city varchar(20), state varchar(2), zip varchar(12) )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq) !!etabledepartmentdepartmentCREATE TABLE department (dept_id integer primary key autoincrement not null, name varchar(20) not nu )AdministrationLoans !Operations ~~ %transaction0 account officer business customer !individual employee branch!department 8i8/'+So. NH Branch378 Maynard Ln.SalemNH030795'5Quincy Branch125 Presidential WayQuincyMA02169.''Woburn Branch422 Maple St.WoburnMA01801.%'Headquarters3882 Main St.WalthamMA02451  y J K F # / ! #TheresaMarkham2001-03-15Head Teller5 ! 1 SusanHawthorne2002-04-24Operations Manager s& ! RickTulman2002-12-12Teller& ! BethFowler2002-06-29Teller& !  ChrisTucker2004-09-15Tellerr&! FrankPortman2003-04-01Tell( ! FrankPortman2003-04-01 Teller& !  SarahParker2002-12-02Teller& ! CindyMason2002-08-09 Teller+ ! SamanthaJameson2003-01-08 Teller* ! #JohnBlake2000-05-11Head Teller'!  JaneGrossman2002-05-03Telle) ! ThomasZiegler2000-10-23 Teller' !  JaneGrossman2002-05-03Teller- ! #PaulaRoberts2002-07-27Head Teller, ! # HelenFleming2004-03-17Head Teller- !% JohnGooding2003-11-14Loan Manager) !  RobertTyler2000-02-09Treasurer. ! ) SusanBarker2002-09-12Vice President* ! MichaelSmith2001-06-22President 3INSURANCEInsurance Offerings$GLOANIndividual and Business Loans/ACCOUNTCustomer Accounts  INSURANCELOAN  ACCOUNT zI#*3!SBLsmall business loanLOAN2000-01-01.;!BUSbusiness line of creditLOAN2000-01-01 !AUTauto loanLOAN2000-01-01$'!MRThome mortgageLOAN2000-01-01/9!CDcertificate of depositACCOUNT2000-01-01-5!MMmoney market accountACCOUNT2000-01-01)+!SAVsavings accountACCOUNT2000-01-01*-!CHKchecking accountACCOUNT2000-01-01 SBLBUSAUTMRTCDMMSAV CHK td2n@ t5 !704-4444444B4772 Presidential WayQuincyMA02169* !#04-3333333B789 Main StSalemNH030796 !1!04-2222222B287A Corporate AveWilmingtonMA01887/ !-04-1111111B7 Industrial WaySalemNH03079, ##999-99-9999I29 Maple StNewtonMA02458.#)888-88-8888I472 Freedom RdSalemNH030792#'!777-77-7777I29 Admiral LnWilmingtonMA018870#)666-66-6666I12 Blaylock LnWalthamMA02451,#%555-55-5555I2341 Main StSalemNH030790#)444-44-4444I12 Buchanan LnWalthamMA02451-#%333-33-3333I18 Jessup RdQuincyMA021694#3222-22-2222I372 Clearwater BlvdWoburnMA018015#/111-11-1111I47 Mockingbird LnLynnfieldMA01940 pT6 !RichardFarley1968-06-16!LouisBlake1977-07-01!MargaretYoung1947-03-19!JohnSpencer1962-09-14!CharlesFrasier1971-08-25!JohnHayward1966-12-22!FrankTucker1958-02-06!SusanTingley1968-08-15!JamesHadley1972-04-22 GtG+ 1!!AAA Insurance Inc.45-678-9011999-05-01+ 1!!Superior Auto Body34-567-8902002-06-30/ 9!!Northeast Cooling Inc.23-456-7892001-01-01, 3!!Chilton Engineering12-345-6781995-05-01 ]]+! StanleyCheswickPresident1999-05-01$! CarlLutzPresident2002-06-30%! PaulHardyPresident2001-01-01'! JohnChiltonPresident1995-05-01  b$w; J  n 2 \  2 !!SBL 2004-02-222004-12-17ACTIVE PP< !!CHK 2003-07-302004-12-15ACTIVE@@< !!BUS 2004-03-222004-11-14ACTIVE @@ffff@@ffff, !!BUS 2002-10-012004-08-28ACTIVE< !!CHK 2002-09-302004-12-15ACTIVE@Ǯz@Ǯz- !! CD 2004-06-302004-06-30ACTIVE9 !! MM 2004-10-282004-10-28ACTIVE@@ffff@:ffff: !! CHK 2003-07-302004-12-15ACTIVE@_jG{@_jG{< !!SAV2001-05-232004-10-12ACTIVE@x? =p@x? =p< !!CHK2001-05-232005-01-03ACTIVE@>aG{@>aG{/ !!CD2004-01-122004-01-12ACTIVE - !! CD2004-12-282004-12-28ACTIVE'': !! CHK2002-08-242004-11-29ACTIVE@^zH@^zH< !!CHK2004-01-272005-01-05ACTIVE@{ =@ =9 !! MM2004-09-302004-11-11ACTIVE@o =p@o =p: !! SAV2000-01-152004-10-24ACTIVE@(\@(\: !! CHK2003-09-122005-01-03ACTIVE@\)@\); !!MM2002-12-152004-12-05ACTIVE @I@I< !!CHK2002-11-232004-11-30ACTIVE @@0 !!SAV2001-03-122004-12-11ACTIVE < !!CHK2001-03-122004-12-27ACTIVE @ =p@ =p.  !!CD2004-06-302004-06-30ACTIVE /  !!SAV2000-01-152004-12-19ACTIVE ;  !!CHK2000-01-152005-01-04ACTIVE @@  qM)uQ- y U 1 " !!2003-07-30CDTd2003-07-30" !!2002-09-30CDTd2002-09-30" !!2004-06-30CDTd2004-06-30" !!2004-10-28CDTd2004-10-28" !!2003-07-30CDTd2003-07-30" !!2001-05-23CDTd2001-05-23" !!2001-05-23CDTd2001-05-23" !!2004-01-12CDTd2004-01-12" !!2004-12-28 CDTd2004-12-28" !!2002-08-24 CDTd2002-08-24" !!2004-01-27 CDTd2004-01-27" !!2004-09-30 CDTd2004-09-30" !!2000-01-15 CDTd2000-01-15" !!2003-09-12CDTd2003-09-12" !!2002-12-15CDTd2002-12-15" !!2002-11-23CDTd2002-11-23" !!2001-03-12CDTd2001-03-12" !!2001-03-12CDTd2001-03-12" !!2004-06-30CDTd2004-06-30" !!2000-01-15CDTd2000-01-15! ! !2000-01-15CDTd2000-01-15 ##      tableaccountaccountCREATE TABLE account (account_id integer primary key autoincrement not null, product_cd varchar(10) not null, cust_id integer not null, open_date date not null, close_date date, last_activity_date date, status text not null, open_branch_id integer, open_emp_id integer, avail_balance float(10,2), pending_balance float(10,2), check(status = 'ACTIVE' or status = 'CLOSED' or status = 'FROZEN') constraint fk_product_cd foreign key (product_cd) references product (product_cd), constraint fk_a_cust_id foreign key (cust_id) references customer (cust_id), constraint fk_a_branch_id foreign key (open_branch_id) references branch (branch_id), constraint fk_a_emp_id foreign key (open_emp_id) references employee (emp_id) )W tableofficerofficer CREATE TABLE officer (officer_id integer primary key autoincrement not null, cust_id integer not null, fname varchar(30) not null, lname varchar(30) not null, title varchar(20), start_date date not null, end_date date, constraint fk_o_cust_id foreign key (cust_id) references business (cust_id) ) qtablebusinessbusiness CREATE TABLE business (cust_id integer primary key autoincrement not null, name varchar(40) not null, state_id varchar(10) not null, incorp_date date, constraint fk_b_cust_id foreign key (cust_id) references customer (cust_id) )  !!etabledepartmentdepartmentCREATE TABLE department (dept_id integer primary key autoincrement not null, name varchar(20) not null )P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)UtablebranchbranchCREATE TABLE branch (branch_id integer primary key autoincrement not null, name varchar(20) not null, address varchar(30), city varchar(20), state varchar(2), zip varchar(12) )@StableemployeeemployeeCREATE TABLE employee (emp_id integer primary key autoincrement not null, fname varchar(20) not null, lname varchar(20) not null, start_date date not null, end_date date, superior_emp_id integer, dept_id integer, title varchar(20), assigned_branch_id integer, constraint fk_e_emp_id foreign key (superior_emp_id) references employee (emp_id), constraint fk_dept_id foreign key (dept_id) references department (dept_id), constraint fk_e_branch_id foreign key (assigned_branch_id) references branch (branch_id) )A%%Etableproduct_typeproduct_typeCREATE TABLE product_type (product_type_cd varchar(10) not null, name varchar(50) not null, constraint pk_product_type primary key (product_type_cd) )7K%indexsqlite_autoindex_product_type_1product_typectableproductproductCREATE TABLE product (product_cd varchar(10) not null, name varchar(50) not null, product_type_cd varchar(10) not null, date_offered date, date_retired date, constraint fk_product_type_cd foreign key (product_type_cd) references product_type (product_type_cd), constraint pk_product primary key (product_cd) )-Aindexsqlite_autoindex_product_1product 6 ?tablecustomercustomer CREATE TABLE customer (cust_id integer primary key autoincrement not null, fed_id varchar(12) not null, cust_type_cd text not null, address varchar(30), city varchar(20), state varchar(20), postal_code varchar(10), check (cust_type_cd = 'I' or cust_type_cd = 'B') ) !!otableindividualindividual CREATE TABLE individual (cust_id integer primary key autoincrement not null, fname varchar(30) not null, lname varchar(30) not null, birth_date date, constraint fk_i_cust_id foreign key (cust_id) references customer (cust_id) )  L h qtablebusinessbusiness CREATE TABLE business (cust_id integer primary key autoincrement not null, name varchar(40) not null, state_id varchar(10) not null, incorp_date date, constraint fk_b_cust_id foreign key (cust_id) references customer (cust_id) )W tableofficerofficer CREATE TABLE officer (officer_id integer primary key autoincrement not null, cust_id integer not null, fname varchar(30) not null, lname varchar(30) not null, title varchar(20), start_date date not null, end_date date, constraint fk_o_cust_id foreign key (cust_id) references business (cust_id) )  tableaccountaccountCREATE TABLE account (account_id integer primary key autoincrement not null, product_cd varchar(10) not null, cust_id integer not null, open_date date not null, close_date date, last_activity_date date, status text not null, open_branch_id integer, open_emp_id integer, avail_balance float(10,2), pending_balance float(10,2), check(status = 'ACTIVE' or status = 'CLOSED' or status = 'FROZEN') constraint fk_product_cd foreign key (product_cd) references product (product_cd), constraint fk_a_cust_id foreign key (cust_id) references customer (cust_id), constraint fk_a_branch_id foreign key (open_branch_id) references branch (branch_id), constraint fk_a_emp_id foreign key (open_emp_id) references employee (emp_id) )%%mtabletransaction0transaction0CREATE TABLE transaction0 (txn_id integer primary key autoincrement not null, txn_date datetime not null, account_id integer not null, txn_type_cd text not null, amount double(10,2) not null, teller_emp_id integer, execution_branch_id integer, funds_avail_date datetime, check (txn_type_cd = 'DBT' or txn_type_cd = 'CDT'), constraint fk_t_account_id foreign key (account_id) references account (account_id), constraint fk_teller_emp_id foreign key (teller_emp_id) references employee (emp_id), constraint fk_exec_branch_id foreign key (execution_branch_id) references branch (branch_id) )