| A | |
|---|---|
1 | About this Spreadsheet |
2 | The following tabs represent a sample data model about students and classes. The model includes a many-to-many relationship between students and classes. That is to say that a student may be linked to many classes and a class may be linked to many students. This model is not intended to be "normal", it is far from that. However, the tabs might respresnt the result of queries against a real database that was well structured. For example,the students tab could be a simple select of a table of all student constrained by such things as Year/Grade school etc.. Likewise, the classes tab clearly is not in normalised form with repeated use of the subject names. The main purpose of this spreadsheet is to be a sample data source that will show a matrix of many-to-may records with some interesting attributes. The attributes themselves would likeley be aggregates from other tables in a real data model. It has also been used in an article about data access from google Sheets |
3 | Article: Getting JavaScript Object Arrays from Google Sheet |
4 |