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') )‚c…tableproductproductCREATE 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) )�UƒtablebranchbranchCREATE 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 8Рi8/'+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 tÉ“d2Òžn@ × « 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 GÒ¡tG+ 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 ÃPÃP< !!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-30ACTIVEÜÜ9 !! MM 2004-10-282004-10-28ACTIVE@Â@Æffff@Ã:Æffff: !! CHK 2003-07-302004-12-15ACTIVE@_jáG®{@_jáG®{< !!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@^—®záH@^—®záH< !!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)�UƒtablebranchbranchCREATE 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_type‚c…tableproductproductCREATE 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) )