Database Answers Header Kyomizu Dera, Japan
FACTS for a Star Design Teaching Schedule
Home Ask a Question Careers Data Models FAQs SQL Scripts Search Site Map  

Back to the Conceptual Data Model.
Original Requirements from the User :-

What is the approach is to creating a multi-dimensional table......
Here is an example:

|Monday|Tuesday|Wednesday|Thursday|Friday...
--------------------------------------------------
9 AM | MATH | HISTORY|ART | SCIENCE|SOC SCI
10 AM | GYM | FRENCH |MUSIC | ART | GYM
11 AM | HIST.| ART |SCIENCE | SOC SCI| GEOG.
12 PM | LUNCH| LUNCH |LUNCH | LUNCH | LUNCH
1 PM | ART | MUSIC | MATH | MATH | MATH
... | ... | ... | ... | ... | ...
... | ... | ... | ... | ... | ...
... | ... | ... | ... | ... | ...

user input - math, gym, art, music, thursday, friday

horizantal columns - monday, tuesday, wednesday, etc.

vertical columns - 9 AM, 10 AM, 11 AM, 12 PM, 1 PM..

Barry Williams
Principal Consultant
Database Answers


[ Home Page | Ask Us a Question | Day in the Life | Email Us | FAQs | Search & Site Map ]

© IceBreaker WebDesigns 2001