Help with creating organizing database for first time

[Jessica]

I have a small project to do and if anyone can help in any way I'd appreciate
it.

I have a group of courses that need to be put in the database. Each may have
one of the following:

Title, Description, Type, Sub-Type, Quarter, Audience(s), Objectives,
Prerequisites, Length, Date(s), Location(s), Resource(s)

There can be more than one "date" and "location" per class. There may be
"resources" to be downloaded. There is an
"audience" category which is like who will take the class e.g, engineer,
shop hand, manager etc. There are approximately 9 "types" of courses within
those types there are sub-types. The classes are listed under the sub-types.

Some of the courses may be under more than one type and sub-type

Any hints help are appreciated.

 

[Jeff Boyce]

Jessica

These are some fairly specific constraints and requirements. Is this
homework?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[KARL DEWEY]

What is the purpose of the database? What is it suppose to produce?

 

[tina]

recommend you read up on relational design principles, so you can structure
your tables/relationships correctly. with the proper design implemented, the
rest will flow much more smoothly and easily. for more information, see
http://home.att.net/~california.db/tips.html#aTip1.

hth

 

[redant]

I am a web designer, redesigning a training site. I am combining two training
department's courses. They are currently organized in this way:

Title, Description, Type, Sub-Type, Quarter, Audience(s), Objectives,
Prerequisites, Length/Days, Date(s), Location(s), Resource(s)

The two department's courses were organized slightly different but I combined
them to come up with the above.

They currently have a database and are using a content management system. The
current structure or UI design is not working.

I good with design but have not done a database such as this. I have the site
flow and site wireframes semi done and now need to figure out a simple way to
create the database.

There are approximately 80 courses.

Jessica

These are some fairly specific constraints and requirements. Is this
homework?

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a small project to do and if anyone can help in any way I'd
appreciate

[quoted text clipped - 18 lines]

Any hints help are appreciated.

 

[redant]

THe purpose is to have a place where users potential students, employees can
view course offerings. THere are different types of courses - training on
products the company produces, training for your specific field, sales
training, global training (courses held globally).

I guess I need to have the user be able to search or locate course offereing
in different ways. For example if he is an engineer or sales person what
courses could he take or He could search by Type of course, by a particular
product.

Also search for resources to this course.

There is alot to it. Where can I start?

What is the purpose of the database? What is it suppose to produce?

I have a small project to do and if anyone can help in any way I'd appreciate
it.

[quoted text clipped - 14 lines]

Any hints help are appreciated.

 

[redant]

About to read this

recommend you read up on relational design principles, so you can structure
your tables/relationships correctly. with the proper design implemented, the
rest will flow much more smoothly and easily. for more information, see
http://home.att.net/~california.db/tips.html#aTip1.

hth

I have a small project to do and if anyone can help in any way I'd appreciate
it.

[quoted text clipped - 14 lines]

Any hints help are appreciated.