Consider the following models Creator and Song corresponding to tables creator and song in SQLite database. class Creator(db.Model): id = db.Column(db.Integer(), primary_key = True) c_name = db.Column(db.String(), unique = True) class Song(db.Model): id = db.Column(db.Integer(), primary_key = True) s_title = db.Column(db.String(), unique = True) singer = db.Column(db.Integer(), db.ForeignKey("creator.id")) Based on the model schemas, what relationship do the table creator and song share?

(D) The tables are not at all related

Modern Application Development I · End Term · 24 Dec 2023 · September 2023 term · Set ADD3

Question 8: Consider the following models Creator and Song correspond…

Question 8

+3 marksOne correct option

Consider the following models Creator and Song corresponding to tables creator and song in SQLite database.

python

1class Creator(db.Model):
2    id = db.Column(db.Integer(), primary_key = True)
3    c_name = db.Column(db.String(), unique = True)
4
5class Song(db.Model):
6    id = db.Column(db.Integer(), primary_key = True)
7    s_title = db.Column(db.String(), unique = True)
8    singer = db.Column(db.Integer(), db.ForeignKey("creator.id"))

Based on the model schemas, what relationship do the table creator and song share?

A
Many-to-Many
B
One-to-Many
C
One-to-One
D
The tables are not at all related

Show answer

Correct answer

B
One-to-Many

See the whole paper Take it as a mock test

Question 8 of 32 in the IIT Madras BS Modern Application Development I (MAD 1) End Term paper sat on 24 Dec 2023, in the September 2023 term (IIT M DIPLOMA FN EXAM FDD1 24 Dec 2023). It carries 3 marks.

Question 8: Consider the following models Creator and Song correspond…

Question 8

More questions from this paper