parivedamohan (11/20/2010)
Hi All,I am new to the Database world.
I would be very happy if any body Normalize the below table, which is in First Normal Form (1NF).
Table:
CREATE TABLE BoatBooking
(Week NUMBER(2),
BoatName VARCHAR2(20),
BoatLength NUMBER,
ExtraRequest VARCHAR2(20),
SkipperPno NUMBER,
SkipperName VARCHAR2(40),
SkipperAddress VARCHAR2(40),
CrewPno NUMBER,
CrewName VARCHAR2(40),
CrewAddress VARCHAR2(40)) ;
GRANT SELECT ON BoatBooking TO PUBLIC ;
Thanks in advance.
For us to make you happy you need to explain what are the business requirements.From a brief glance I think you are relating skipper & crews to a particular boat.
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server