The JustLee DB contains a table called PROMOTION.

It does not have any of the relationships to other tables we discussed last week. It is not a one-to-one, one-to-many, or many-to-many relationship. There is no crowfoot on the ER diagram related to this table.

However, there IS a relationship depicted in the ER diagram between the PROMOTION and the BOOKS tables.

What kind of relationships do you think it is?

Please check the structure of these two tables and the data contained in them in your ApEx schema running SQL commands. Which commands did you use and what results did you see?

Table:

PROMOTION

Column	Data Type	Length	Precision	Scale	Nullable
GIFT	VARCHAR2	15	-	-	Yes
MINRETAIL	NUMBER	22	5	2	Yes
MAXRETAIL	NUMBER	22	5	2	Yes

Table:

BOOKS

Column	Data Type	Length	Precision	Scale	Nullable
ISBN	VARCHAR2	10	-	-	No
TITLE	VARCHAR2	30	-	-	Yes
PUBDATE	DATE	7	-	-	Yes
PUBID	NUMBER	22	2	0	Yes
COST	NUMBER	22	5	2	Yes
RETAIL	NUMBER	22	5	2	Yes
DISCOUNT	NUMBER	22	4	2	Yes
CATEGORY	VARCHAR2	12	-	-	Yes
QOH	NUMBER	22	3	0	Yes