Database Answers Pebble Beach

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Hierarchies of Preferences
   Back to the Data Model.

The Draft Business Rules have been defined and are listed below.
User Requirements :-
A design to store Preference Settings in a database.
Let's assume 3 levels
1) a general (= default settings)
2) group level
3) user level - a user belongs to a group.

Group- and User- settings overwrite the general settings and are normally a
subset of all possible values.

----------------------------
this could be an example:
general:
- color = black
- lang = en
- size = 5
group1:
- lang = fr
user1:
- size = 6
(user1 belongs to group1)
----------------------------
the query to get all the settings for user1 should return the following
values:
- color = black
- lang = fr
- size = 6
----------------------------
I know, there are other solutions than using a database and it could be a
massive overkill, but I'm interested in possible designs.


Thank you for any comment!

Greetings from Switzerland to London

Philipp

A. The Area being Modelled is :-
A Hierarchy of Preferences

B. The Things of Interest, ('THINGS'), include :-
B.1 Hierarchies
B.2 Hierarchy Entries
B.3 Hierarchy Levels
B.3 Preferences

C. These THINGS are Related as follows :-
C.1 A HIERARCHY has one or many LEVELS.
C.2 

D. Other Characteristics of these THINGS include :-
D.1 

E. Sample Data includes :-
To be determined

F. Typical Enquiries include :-
F.1 To be determined
 

Barry Williams
9th. June 2003
Principal Consultant
Database Answers
Home Ask a Question Careers Contact us Data Models First Timers Search Site Map