By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,027 Members | 1,261 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,027 IT Pros & Developers. It's quick & easy.

Generalization in Microsoft Access

P: n/a

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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
You need tables that look like:

TblGuest
GuestID
etc

TblGuestBuy
GuestBuyID
GuestID
etc

TblGuestSell
GuestSellID
GuestID
etc
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Luca" <lu**********@fastwebnet.it> wrote in message
news:BS*******************@tornado.fastwebnet.it.. .

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

Nov 12 '05 #2

P: n/a
read Rebecca Riordan's article on this...
"Sub-classing Entities"
http://www.mvps.org/access/tables/tbl0013.htm
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.