retagged by
652 views

2 Answers

4 votes
4 votes
1 professor can teach 1 subject. 1 subject can be taught by multiple teachers.

For max condition, each professor teaches a subject.

Case 1: professors < subjects -> no of rows = no of professors

Case 2: professors > subjects -> no of rows = no of students < no of professors

Thus, rows <= no of professors.

So, max rows = no of professors
3 votes
3 votes
Converted relational model will comtain two tables :

1. Professor(Pid.........(other attributes), Cid)  // Assuming column name for example, Pid->Primary Key, Cid- Foreign Key

2. Course(Cid.......(other attributes) // Cid ->Primary Key

Now as Cid is a foreign key in Professors table, tuples of cid in course table will be a subset of tuples of cid in professors table.

Hence maximum number of tuples is tuples in Professors table. Correct me if I'm wrong.

Related questions

1 votes
1 votes
0 answers
1
bts1jimin asked Aug 30, 2018
1,275 views
0 votes
0 votes
0 answers
2
Anjan asked Nov 9, 2017
663 views
0 votes
0 votes
1 answer
3
Anmol Verma asked Nov 19, 2016
430 views
0 votes
0 votes
1 answer
4
Anmol Verma asked Nov 19, 2016
491 views
What is structural constraint of relationship type and give some examples of it....or any link...???