Sir, I am doing a project in asp.net.
I want your help in normalizing a SQL table.
Here the table which I want to normalize. Please normalize this table and send back.
|
Hotel Name
|
Hotel Address
|
Pass.Name
|
Pass.Address
|
Booking ID
|
Booking Date
|
Staying Date
|
Room Type
|
Price/Day
|
No Of Days
|
Vehicle Type
|
Vehicle No
|
|
Dream Hotel
|
S.A, Road, Cochin
|
James
|
Hancock
|
B001
|
1.1.2010
|
10.oct.2011
|
Delux
|
13000
|
1
|
Vehicle1
|
A-B-C
|
|
The Mercy
|
M.G ROAD, RAVIPURAM
|
John
|
sanfrancisco
|
B002
|
12.11.2010
|
05.feb.2011
|
Standard
|
15000
|
3
|
Vehcile2
|
D-D-D
|
|
Hotel East Avenue
|
Nadakkavu, Calicut
|
James
|
Hancock
|
B003
|
25.02.2011
|
02.feb.2011
|
Single
|
12000
|
2
|
Vehicle1
|
A-B-C
|
|
Silent Valley Resort
|
Mumbai Ahmedabad Highway
|
Priya
|
sparks
|
B004
|
10.Mar.2011
|
25.dec.2011
|
Double
|
25000
|
1
|
Vehcile2
|
D-D-D
|
|
Dream Hotel
|
S.A, Road, Cochin
|
John
|
califonia
|
B005
|
25. Mar .2011
|
25.dec.2011
|
Delux
|
10000
|
2
|
|
|