[thelist] Help with SQL/CF

[ted serbinski]

Ok I've finally decided to dive into the backend of web development, but
I have a few questions. For starters, I'm using Windows XP, with SQL
2000, and Cold Fusion 4.5 installed.

Basically I need to create an application the first setups X number of
databases to hold records for each school entered (or are they called
tables?). Once setup, I need to be able to have a new user signup in
whatever school they want. Then they can login and see a list of events
in the database for that school only. Also a user can signup as an admin
person if they have the correct password and page view/ect.

So that's what I'm doing. But now where do I begin? First off, is there
a way in Cold Fusion to create a database? Or do I have to do this
manually? If so, how do I set this up manually in SQL? Also if so, would
I then only need to create a new table for each school entered? I think
this is what I have to do but I'm not too sure.

I know Cold Fusion is supposed to simplify this stuff greatly so is
there a quick tutorial of how I can enter stuff in a database,
retrieve/delete stuff?

And one last thing, structuring data, I know this is key, so I want to
do it right the first time. Basically I have to keep track a few things.

-how many schools I have and under each school, one of these 3 types of
people:
   a. student name, gender, age, grade, and few other relate items.
   b. activity supervisor, password 
   c. admin name, password 

-depending on their status above, they are to view only certain pages,
ect.

Now what would be the best way to setup my data in a table? I was
thinking somewhere along the lines:

ID#  Name  UserName Password Gender Age Grade School Restrict
43   Joe     Joe3     sky      M     15   10   NSHS    YES

Would something like above work? Is there an easy way to assign ID #s to
people? What if I were to delete a person? Just delete their ID# and
that line? 

Any help /comments are greatly appreciated.

Thanks
ted