drop table if exists acct;
create table acct
	(acct_id          varchar(9),
         acct_pin         varchar(4),
	 acct_name        varchar(20),
         acct_type        char(1),
         acct_balance     dec(9,2) not null,
	 primary key (acct_id, acct_type));