Need help to create tables and relationship for following please.
Student table
StudentA - Id (primary key- no duplicate)
StudentB - Id (primary key- no duplicate)
StudentC - Id (primary key- no duplicate)
StudentD - Id (primary key- no duplicate)
StudentE - Id (primary key- no duplicate)
StudentF - Id (primary key- no duplicate)
StudentG - Id (primary key- no duplicate)
and so on.........
Subject & Fee table
Maths - £2.00
English - £2.00
French - £3.00
Science - £3.00
1. Student can be from same family and they get discount only in English if they have siblings.
if two children from same family they pay £3.00 (not £4.00)
if three children from same family they pay £4.00 (not £6.00)
2. One student can have many subjects.
Each family get only one receipt that include Student name, Id, subject they are taking, fees, totals.
How do I do the tables, query, relationship and the calculation.?
Thanks
- Mahen
Student table
StudentA - Id (primary key- no duplicate)
StudentB - Id (primary key- no duplicate)
StudentC - Id (primary key- no duplicate)
StudentD - Id (primary key- no duplicate)
StudentE - Id (primary key- no duplicate)
StudentF - Id (primary key- no duplicate)
StudentG - Id (primary key- no duplicate)
and so on.........
Subject & Fee table
Maths - £2.00
English - £2.00
French - £3.00
Science - £3.00
1. Student can be from same family and they get discount only in English if they have siblings.
if two children from same family they pay £3.00 (not £4.00)
if three children from same family they pay £4.00 (not £6.00)
2. One student can have many subjects.
Each family get only one receipt that include Student name, Id, subject they are taking, fees, totals.
How do I do the tables, query, relationship and the calculation.?
Thanks
- Mahen