dbTalk Databases Forums  

Generalization in Access

comp.database.ms-access comp.database.ms-access


Discuss Generalization in Access in the comp.database.ms-access forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Luca
 
Posts: n/a

Default Generalization in Access - 02-18-2004 , 02:27 PM






Is it possible to represent a generalization (coming from an E-R chart) in
Microsoft Access, and how?? For example I have the "GUEST" class and two
sub-classes "GUEST-BUY" and "GUEST-SELL" (this generalization is complete
and dosjoint), how can I set the integrity referential contraints so that
any item in the sub-classes is linked with the main class by the primary
key? The class "GUEST" should own all the attributes and the counter
(primary key); the sub-classes should only have the counter (or an integer)
to refer to the main class.
I have to develop a project for the university so please help me!! Thank you
all!


Luca



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.