Need some guidance on school database project

[Christan]

I am currently taking a db course and my class is paired us into
groups of 4s and our instructor had us download a template from the
microsoft Access site for education to create and modify a database
for a made up school. This was our objective as it was from a business
asking for our team.

St. Marys School is an educational establishment who recently decided
to convert from paper to technology. A earlier Database was used by
inputing data from the main office which included Students info such
as their names and assignments and their grades. The school is now
desiring their teachers to input data into the school's main datbase
with students names and grades as well as assignments and scores. Only
the teachers will be able to see and input their classroom students,
but keeping all other info to the main office. There is currently 10
diffrent teachers who need to input their students information.

This is only part of the description my group decided that the best
way was to create diffrent tables for each grade levels and give only
permissions to that rooms teacher and the main office..So far are we
right?

If we are then we must create a relationship to another table but
which one?
The template we downloaded already had 8 tables and them being
(Students, Students and Classes, Departments, Instructors, Results,
Assignments, Switchboard Items, Classes)

[Darryl Kerkeslager]

Please post your prof's email address so that we can verify that usenet help
is not in fact considered cheating, becuase it feels kinda' dirty-like.
Darryl Kerkeslager

[Alan Webb]

Christian,
If you were one of my students you just failed. Now, anytime you are
designing a database start with pencil & paper and draw your ideas. There
is plenty of stuff out there on how to draw charts of the design. Go find
it and do your homework yourself.

"Christan" <Co***********@hotmail.com> wrote in message
news:f8**************************@posting.google.c om...

I am currently taking a db course and my class is paired us into
groups of 4s and our instructor had us download a template from the
microsoft Access site for education to create and modify a database
for a made up school. This was our objective as it was from a business
asking for our team.

St. Marys School is an educational establishment who recently decided
to convert from paper to technology. A earlier Database was used by
inputing data from the main office which included Students info such
as their names and assignments and their grades. The school is now
desiring their teachers to input data into the school's main datbase
with students names and grades as well as assignments and scores. Only
the teachers will be able to see and input their classroom students,
but keeping all other info to the main office. There is currently 10
diffrent teachers who need to input their students information.

This is only part of the description my group decided that the best
way was to create diffrent tables for each grade levels and give only
permissions to that rooms teacher and the main office..So far are we
right?

If we are then we must create a relationship to another table but
which one?
The template we downloaded already had 8 tables and them being
(Students, Students and Classes, Departments, Instructors, Results,
Assignments, Switchboard Items, Classes)

[Trevor Best]

Alan Webb wrote:

Christian,
If you were one of my students you just failed. Now, anytime you are
designing a database start with pencil & paper and draw your ideas. There
is plenty of stuff out there on how to draw charts of the design. Go find
it and do your homework yourself.

Hey, Kirk got a commendation for original thinking when he cheated on
the Kobayashi Maru test :-)

--
This sig left intentionally blank

[Paul]

You are NOT Kirk!!!
"Trevor Best" <no****@besty.org.uk> wrote in message
news:41**********************@news.zen.co.uk...

Alan Webb wrote:

Christian,
If you were one of my students you just failed. Now, anytime you are
designing a database start with pencil & paper and draw your ideas.
There is plenty of stuff out there on how to draw charts of the design.
Go find it and do your homework yourself.

Hey, Kirk got a commendation for original thinking when he cheated on the
Kobayashi Maru test :-)

--
This sig left intentionally blank

[Trevor Best]

Paul wrote:

You are NOT Kirk!!!

Who said I was? Spot the smiley. Sheesh, newbies.

--
This sig left intentionally blank

[Paul]

It was a joke...I forgot the smiley! :-)

Which reminds me of a joke, relating to this string post.

A kid chops down a 100 year old cherry tree in his backyard. The dad gets
home and asks the son if he cut down the tree. The kids says NO!

So the dad explains the story to the kid about George Washington and how he
cut down his dad's cherry tree. And that when HIS dad asked him if he cut
down the tree, George told the truth and said "Yes father I did, and I'm
sorry". And that was the end of that.

So the father says to his son. Now son, did you chop down the cherry tree.
The son answers YES this time. The father then proceeds to beat the living
hell out of the son. The son, between sobs says "but george told you the
truth his father let him off.", why did you beat me? The father replies,
Because you are NOT George Washington....No Trevor..you are not Kirk. :-)

"Trevor Best" <no****@besty.org.uk> wrote in message
news:41**********************@news.zen.co.uk...

Paul wrote:

You are NOT Kirk!!!

Who said I was? Spot the smiley. Sheesh, newbies.

--
This sig left intentionally blank

[Bas Cost Budde]

Chuck Grimsby wrote:

Not a newbie, a "trekie"! <GRIN>

Qapla'!

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea

[Trevor Best]

Bas Cost Budde wrote:

Chuck Grimsby wrote:

Not a newbie, a "trekie"! <GRIN>

Qapla'!

majQa'
tlhIngan maH!

--
This sig left intentionally blank