dbInput

dbname:grocerydb

table:savingaccounts
attr:account_number int 2 1000 100,branch_name varchar(50) aaa www 50,branch_city varchar(50) aaa www 50,customer_id int 2 1000 100
primaryKey:customer_id
primaryIndex:account_number hashing 200 3
secondaryIndex:account_number,customer_id B+tree 200 3
foreignIndex:
cardinality:4
sizeOfTuple:104
numberOfTuples:1000

table:chekingaccounts
attr:account_number int 2 1000 100,branch_name varchar(50) aaa www 50,branch_city varchar(50) aaa www 50,customer_id int 2 1000 100
primaryKey:account_number
primaryIndex:account_number B+tree 200 3
secondaryIndex:account_number staticHashing 200 3
foreignIndex:customer_id customer(id) staticHashing 200 5
cardinality:4
sizeOfTuple:104
numberOfTuples:100

table:customer
attr:id int 2 1000 100,branch_name varchar(50) aaa www 50,branch_city varchar(50) aaa www 50,customer_name varchar(50) aaa www 50
primaryKey:id
primaryIndex:id Extensible-Hashing 200 4
secondaryIndex:
foreignIndex:
cardinality:4
sizeOfTuple:18
numberOfTuples:1000