Hi

As a relative newbie I need some advice on whether the following design and relationships are OK or if they need adjusting.

Currently there is an excel spreadsheet (.xls) being used that has the following column headings and data types. Data in it at the mo is really meesy with mixed datatypes - my job = fix it!

GPN Number (Unique)
ENUM Number (repeated values)
MAKE Text (repeated values)
SYSTEM text (repeated values)
SYSTYPE text (repeated values)
DESCRIPTION text (repeated values)
SERIALNO Number (unique)
QUANTITY Number (repeated values)
PRICE Currency (repeated values)
REGION Text (repeated values)
LOCATION Text (repeated values)
CONFIRMED Date (repeated values)
FIRSTNAME text (repeated values)
LASTNAME text (repeated values)
STOCKTAKE Date (repeated values)
REMARKS text (repeated values)



Here's some sample data to give an example of the types of info that is required.


GPN [Unique]
4556
2033
1815

ENUM
282
282
123

MAKE
Sony
Motorola
Nokia

SYSTEM
HF
VHF
SATCOM
TRACKING

SYSTYPE
MOBILE
HANDHELD
WLAN
WGAN
THURAYA

DESCRIPTION
CABLE CAT5
CHARGER
MIKE
EARPIECE

SERIALNO
54324
45766
43556
54324
45766
1234
1234

QUANTITY
1
3
1

PRICE
$110.85
$250.25
$215.62


REGION
London
Kent
Buckinghamshire
Berkshire


LOCATION
H1
Store 6
Building2
Team4

CONFIRMATION
12/04/05
23/06/05

FIRSTNAME
Bob
Cordelia
Kim
James
Miles
Jessica


LASTNAME
Curtis
De Havilland
Tong
Mayfield
pondwell



STOCKTAKE
21/05/05
01/12/04


REMARKS
Nice bit of kit
Blah blah zzzz......



Here's an attempt to start afresh and create some tables with new fields and normalise them. I think I've got the relations right, but would appreciate some feedback to see if you pick up any obvious mistakes.


ASSET
GPN[PK], Description, SerialNo, RNum, DateAquired, StockTakeDate, Price, ConfirmDate, ContactNo, CatNo, MakeNo, RegionNo
[FK's: CatNo, ContactNo, MakeNo]

MAKE
MakeNo[PK], MakeName
[FK: CatNo]

SYSTEM
SysNo[PK], SysName
[FK: CatNo]

CATEGORY
CatNo[PK], CatName, SysNo
[FK: SysNo]

REGION
RegionNo[PK], RegionName, LocNo
[FK: GPN, LocNo]

LOCATION
LocNo[PK], LocName

CONTACT
ContactNo[PK], FirstName, LastName

Any help would be much appreciated.

Hey guys how are you?
I'm not a spamer so don't ban me please.
Could you please tell me your opinion about these two sites:

Best Portal
and Great Site

Thanks you very much.