Bineesh  Viswanath

Bineesh Viswanath

  • NA
  • 1k
  • 760.1k

Normalization in SQL Server

Oct 9 2013 2:23 PM
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

 

 



Answers (2)