Help with Design of Database

[teelee]

Hello...I am fairly new to this and I need some assist with this. I have a
sheet of paper that has 5 different catagories and I'm not sure how to set
this up in a database. For example: One catagorie is Demographics and another
is History and Studies. I need help on how to set this up from scratch. Any
help is well appreciated.

Thanks

 

[Tim Ferguson]

. I need help on how to set this up from scratch. Any
help is well appreciated.

CREATE TABLE Categories
( CatID TEXT(5) NOT NULL PRIMARY KEY,
FullName TEXT(64) NOT NULL,
PlaceOnPaper MEMO
);

INSERT INTO Categories (CatID, FullName, PlaceOnPaper)
VALUES ("Demog", "Demography", "Top left in blue ink");

INSERT INTO Categories (CatID, FullName, PlaceOnPaper)
VALUES ("HisSt", "History and Studies", "Bottom Right");



Hope that helps?


Tim F

 

[mnature]

Hello...I am fairly new to this and I need some assist with this. I have a

sheet of paper that has 5 different catagories and I'm not sure how to set
this up in a database. For example: One catagorie is Demographics and another
is History and Studies. I need help on how to set this up from scratch. Any
help is well appreciated.

How are your categories related to each other? If you have demographics,
history, and studies, then are they related by being aspects of a country or
geographic region? Without knowing the point of your database, it is
difficult to help you.