Figure 1: The PUBLISHER and PUBLICATION entities mapped to their equivalent logical tables
Table Name	Column Name	Data Type	Length	Key Status	Required	Indexed	Column Description
PUBLISHER	PubID	Integer	4	Pkey	Yes	Yes	Primary key, unique identifier for each publisher
	PubName	Text	50		Yes	Yes	Name of the publisher
	PubAddress	Text	60				Publisher's address
PUBLICATION	PublicationID	Integer	4	Pkey	Yes	Yes	Primary key, unique identifier for each publication
	PubID	Integer	4	Fkey	Yes	Yes	Foreign key, link back to table PUBLISHER
	PubCatID	Integer	4	Fkey	Yes	Yes	Foreign key, link back to table PUB_CATEGORY
	PublicationName	Text	50		Yes		Descriptive name of the publication