create database feecollectionsystem
use feecollectionsystem

create table login
(
userid varchar(10),
password varchar(10),
)
create table studentmaster
(
class varchar(2),
division varchar(1),
rollno varchar(2),
name varchar(max)
)
create table feemaster
(
class varchar(2),
totalcompfee int,
totalvnfee int,
)
create table vndetail
(
class varchar(2),
division varchar(1),
rollno varchar(2),
name varchar(max),
receiptno varchar(10),
date smalldatetime,
paidfee int,
records int
)
create table vnbalance
(
class varchar(2),
division varchar(1),
rollno varchar(2),
name varchar(max),
totalfee int,
totalpaidfee int,
balance int,
)
create table compdetail
(
class varchar(2),
division varchar(1),
rollno varchar(2),
name varchar(max),
receiptno varchar(10),
date smalldatetime,
paidfee int,
records int
)
create table compbalance
(
class varchar(2),
division varchar(1),
rollno varchar(2),
name varchar(max),
totalfee int,
totalpaidfee int,
balance int
)