Total newbie needs some (hopefully simple) help

[Ryan Irwin]

I am looking to create a MySQL database with some information I have:

The information is as follows:
Number
Name
Building

The values of Name column and Building column are unique, but both share the value of number.

Something like this

Number | Name | Building
1 | a | 123
2 | b | 133
3 | c | 143
4 | d | 153
5 | e | 163

Name value and building value are not related, but if number is 1 for name it will always be a and if number is 1 for building it will always be 123. If name is a, that does not mean building is 123.

This is my first crack at building a MySQL database and I am totally lost. Please be gentle.

TIA



Edited 1 time(s). Last edit at 04/25/2012 03:37PM by Ryan Irwin.