Help with Design of Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
. I need help on how to set this up from scratch. Any
help is well appreciated.
Click to expand...



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
 
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.
Click to expand...

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.
 
Back
Top