Good day,
We are developing a website to provide textbooks to parents, and after finish it as HTML/CSS website (helped a lot in these forums!!), now we have to deal with creating a database to load the information.
This is the idea:
- we serve different schools (we make agreements and they let us know their textbooks lists, we publish them in our website and parents purchase textbooks online from our website)
- each school has grades (first, second …). We have here 12 school grades and usually 2 pre-school grades (for small people)
- some schools has one class per grade, but others have more, identifying them, for instance: 1A, 1B, 1C … In other words, different shools have different number of classes (groups of students)
- each school publishes each year the list of textbooks for every grade and class, for instance: textbooks for 1A, for 1B, for 1C … and so on
- sometimes textbook list for different classes for the same grade (in the same school) are the same, other not. For instance texbooks for 1A = 1B, but 1C is different
- each textbook has title, code and price
When parents go to our website to purchase textbooks for their children, they go to the page where are all schools we work with:
- they select one school
- they select one class from a list (for instance radiobutton)
- with this information, a query shows the list of textbooks suggested by the school for this specific class
- is it possible for parents to select one or more textbooks to purchase
- before checkout, a contact e-mail, phone and student name have to be provided by parents
Is it possible to suggest me what to consider entity and attribute, and where to introduce keys?
Thanks a lot!!