dears,
I am looking for your help to build a prize bond management system.
below is my table which I want to create. can anybody will help me to structure the queries, do the normalization and design it well.
Denomination (ID, Type(200,750 ...)
Prize bond (Denomination ID, Serial Number)
Prize bond Schedule (Denomination ID, Draw No. Date, Day, City)
Prize bond Prize money (denomination, No. of prizes(total0, Winning amount, Prize class (1st,2nd,3rd),
Winning List Prize bond list (Denomiation ID, Prize bond Number, Prize(1st,2nd or 3rd), Draw Number, Draw held at(city), date(yyyy-mm-dd)