Database design

[joseph_707]

Hi everyone ! I would appreciate anyone who could guide me to develop this
database.

Let me make it simple and short

Database name : PE
Database Tables : Students & Houses

Database Table Student fields : Student code,family code,student name,family
name ,gender,age,grade level,houses

Database Table House fields : Falcons,Leopards,gazelles,scopions

I need to answer these questions ,
-----------------------------------------
a) Given numbers, male-female ratio in each of the houses ex. male= female
(equal)

2.Given numbers , male-female from each grade level ex. Equal male and female
from the same grade level

3.All members from the same family to be in the same house ex. Johns sisters
and brothers in the same house based on their last names


4.All houses should have equal number of students ex Leopards : 5 , Gazelles:
5 Falcon: 5

REPORT GENERATION
--------------------------
1.Report based on Age group EX. Who are the students at the age of 9 and
which house?

2.Report based on Individual grade classification ex. Grade 1 who are the
students

3. Report based on Individual student classification ex. entering the name
reveals student details

Can someone guide me.I know access and I am in the Beginner-intermediate
level.I would appreciate if someone can help me how to program or what
queries etc I need to have this database.Thanks in advance for all the help.

Jo

 

[Evi]

It will look better, if you want a newsgroup to do your homework, if you
only ask one question at a time

And please make it a specific one. Then we can help you to answer it
(especially if we know you've actually had a try at it for yourself)

It isn't clear which bit you can't do - you say you already know Access. Do
you really want someone to write a full course guide (most of which you
probably already know) because you don't want to take the time to word a
specific question?

Your Subject says database design.
Since you only have 2 tables then you will have to have a Foreign key Field
in the Student Table linking to the House table

So if the Primary Key of the House Table is HouseID - perhaps an Autonumber
field

then Student Table will have to have its own Primary Key but it will also
have a Number field called HouseID
In the Relationships window join HouseID from the House Table to HouseID in
the Student Table
Create a form based on the Student Table. Add a combo based on the House
table. Choose the correct house for each student

The first 4 questions you've listed aren't actually questions - they aren't
even in good English unless you have omitted part of your homework paper.

Evi