Consider the below two data models Author and Book using SQLite database. class Author(db.Model): id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String) dob = db.Column(db.String) class Book(db.Model): id = db.Column(db.Integer(), primary_key=True) title = db.Column(db.String()) publisher = db.Column(db.String()) written_by = db.Column(db.Integer(), db.foreign_key("author.id")) What kind of relationship exists between Author and Book classes?

(B) One Author to many Books relationship

(A) One Book to one Author relationship

(C) Many Authors to one Book relationship

(D) Many Books to many Author relationship

Modern Application Development I · End Term · 28 Apr 2024 · January 2024 term · Set QDF1

Question 18: Consider the below two data models Author and Book using…

Question 18

+3 marksOne correct option

Consider the below two data models Author and Book using SQLite database.

python

1class Author(db.Model):
2   id = db.Column(db.Integer, primary_key=True)
3   name = db.Column(db.String)
4   dob = db.Column(db.String)
5
6class Book(db.Model):
7   id = db.Column(db.Integer(), primary_key=True)
8   title = db.Column(db.String())
9   publisher = db.Column(db.String())
10   written_by = db.Column(db.Integer(), db.foreign_key("author.id"))

What kind of relationship exists between Author and Book classes?

A
One Book to one Author relationship
B
One Author to many Books relationship
C
Many Authors to one Book relationship
D
Many Books to many Author relationship

Show answer

Correct answer

B
One Author to many Books relationship

See the whole paper Take it as a mock test

Question 18 of 32 in the IIT Madras BS Modern Application Development I (MAD 1) End Term paper sat on 28 Apr 2024, in the January 2024 term (IIT M FOUNDATION DIPLOMA AN EXAM QDF3 28 Apr 2024). It carries 3 marks.

Question 18: Consider the below two data models Author and Book using…

Question 18

More questions from this paper