Divide Operator

1
Divide Operator

• CSCI 4707

2
Divide Operator

• Generally used for M-N relationships
• Best explained using examples

3
Divide Operator Examples
Student
Offering
stdSSN stdLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
OfferNo CourseNo
1234 CSCI101
4321 CSCI201
7777 CSCI30
Enrollment
stdSSN OfferNo
111-11-1111 1234
111-11-1111 4321
222-22-2222 1234
111-11-1111 7777
333-33-3333 1234
4
Divide Operator Examples
Student
Offering
stdSSN stdLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
OfferNo CourseNo
1234 CSCI101
4321 CSCI201
7777 CSCI30
Query Student / Offering Which Student(s) are
enrolled all the offered classes?
Enrollment
stdSSN OfferNo
111-11-1111 1234
111-11-1111 4321
222-22-2222 1234
111-11-1111 7777
333-33-3333 1234
5
Divide Operator Examples
Student
Offering
stdSSN stdLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
OfferNo CourseNo
1234 CSCI101
4321 CSCI201
7777 CSCI30
Query Student / Offering Which Student(s) are
enrolled all the offered classes? Wells
Enrollment
stdSSN OfferNo
111-11-1111 1234
111-11-1111 4321
222-22-2222 1234
111-11-1111 7777
333-33-3333 1234
6
Divide Operator Examples
Student
Offering
stdSSN stdLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
OfferNo CourseNo
1234 CSCI101
4321 CSCI201
7777 CSCI30
Query Offering / Students Which course(s) has
all the students enrolled in it?
Enrollment
stdSSN OfferNo
111-11-1111 1234
111-11-1111 4321
222-22-2222 1234
111-11-1111 7777
333-33-3333 1234
7
Divide Operator Examples
Student
Offering
stdSSN stdLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
OfferNo CourseNo
1234 CSCI101
4321 CSCI201
7777 CSCI30
Query Offering / Students Which course(s) has
all the students enrolled in it? 1234
Enrollment
stdSSN OfferNo
111-11-1111 1234
111-11-1111 4321
222-22-2222 1234
111-11-1111 7777
333-33-3333 1234
8
Divide Operator Examples
Product
Customer
custSSN custLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
UPC prodName
1234 apple
4321 orange
7777 strawberry
Purchased
custSSN UPC
222-22-2222 1234
111-11-1111 7777
222-22-2222 4321
333-33-3333 7777
222-22-2222 7777
9
Divide Operator Examples
Product
Customer
custSSN custLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
UPC prodName
1234 apple
4321 orange
7777 strawberry
Query Customer / Product
Purchased
custSSN UPC
222-22-2222 1234
111-11-1111 7777
222-22-2222 4321
333-33-3333 7777
222-22-2222 7777
10
Divide Operator Examples
Product
Customer
custSSN custLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
UPC prodName
1234 apple
4321 orange
7777 strawberry
Query Customer / Product Which customer(s) have
purchased all the products?
Purchased
custSSN UPC
222-22-2222 1234
111-11-1111 7777
222-22-2222 4321
333-33-3333 7777
222-22-2222 7777
11
Divide Operator Examples
Product
Customer
custSSN custLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
UPC prodName
1234 apple
4321 orange
7777 strawberry
Query Customer / Product Which customer(s) have
purchased all the products? Kendall
Purchased
custSSN UPC
222-22-2222 1234
111-11-1111 7777
222-22-2222 4321
333-33-3333 7777
222-22-2222 7777
12
Divide Operator Examples
Product
Customer
custSSN custLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
UPC prodName
1234 apple
4321 orange
7777 strawberry
Query Product / Customer
Purchased
custSSN UPC
222-22-2222 1234
111-11-1111 7777
222-22-2222 4321
333-33-3333 7777
222-22-2222 7777
13
Divide Operator Examples
Product
Customer
custSSN custLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
UPC prodName
1234 apple
4321 orange
7777 strawberry
Query Product / Customer Which product(s) have
been bought by all customers?
Purchased
custSSN UPC
222-22-2222 1234
111-11-1111 7777
222-22-2222 4321
333-33-3333 7777
222-22-2222 7777
14
Divide Operator Examples
Product
Customer
custSSN custLastName
111-11-1111 Wells
222-22-2222 Kendall
333-33-3333 Norbert
UPC prodName
1234 apple
4321 orange
7777 strawberry
Query Product / Customer Which product(s) have
been bought by all customers? strawberry
Purchased
custSSN UPC
222-22-2222 1234
111-11-1111 7777
222-22-2222 4321
333-33-3333 7777
222-22-2222 7777