1'The entities are students and teachers each teacher advises at least one student, and each student

1
1. The entities are students and teachers each
teacher advises at least one student, and each
student has one advisor.
Teachers can advise 1 or more students
Students can have only 1 advisor
id
ssn
Teachers
Students
Advises
1..1
1..
Relationship One to many(1)
2
2. The entities are shoppers and department
stores each shopper shops in at most 3
department stores, and each department store has
at least one shopper.
Shopper can shop in at most 3 stores
Each Department Store has least 1 shopper
Shopperid
Storeid
Shopper
Department Stores
Shops
0..3 or 1..3
1..
Relationship Many- to-Many()
3
3. The entities are men and women each man is
married to at most one woman, and each woman is
married to at most one man.
Woman can be married to at most 1 man
Man can be married to at most 1 woman
mssn
wssn
Man
Woman
Married
0..1
0..1
Relationship One- to-One(11)
4
4.The entities are books and authors each book
has at most 3 authors, and each author has any
number of books, but at least one.
Authors can have many books, but must have 1
Book has at most 3 authors
ISBN
ssn
Book
Authors
Has
1..
1..3 or 0..3
Relationship Many-to Many()
5
5. Give an example of a many-many relationship.
How can you represent this relationship in a
database?

Relationship Many-to-Many
6
6. The entities are students and majors and
advisors each student has at least one major,
each student has one advisor for each major, and
each advisor can have any number of advisees, not
necessarily all in the same major.
Has
ssn
name
Student
Major
Student
1..
1..
1..1
id
advisorid
Advisor