Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Relationships
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00519386
Message ID:
00519551
Vues:
17
>Rules Are:
>
>Property - A property has one manager, and one client
>
>Client - Can have one or many properties, Client has one DIRECT "client" manager, but could have different managers for each property
>
>Manager - Each manager could have many clients, Each manager could have many properties

The rule for 'client' seems to violate the rule for 'property': "but could have different managers for each property" whereas 'property' states: "one manager". I'm going to assume that it's just worded bad.

client 1-* property *-1 manager

where '1-*' is a one-to-many relationship. It seems that the entire relationship is worded as "clients can own multiple properties, managers can manage multiple properties but a property has only one owner and only one manager."

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform