Question $1(30$ Marks$)$

Write a JavaScript function to add the following books in the library collection for author

John Grisham. The number in the parentheses is the year of publication.

A Time to Kill $(1989)$

The Firm $(1991)$

The Pelican Brief $(1992)$ The Client $(1993)$

The Chamber $(1994)$ The Rainmaker $(1995)$ The

Runaway Jury $(1996)$ The Partner $(1997)$

The Street Lawyer $(1998)$

The Testament $(1999)$

The Brethren $(2000)$

A Painted House $(2001)$

Skipping Christmas $(2001)$ The Summons $(2002)$

The King of Torts $(2003)$

Bleachers$(2003)$ The Last Juror $(2004)$ The

Broker $(2005)$ Playing for Pizza $(2007)$ The

Appeal $2008)$

The Associate $(2009)$ The Confession $(2010)$

The Litigators $(2011)$ Calico Joe $(2012)$

The Racketeer $(2012)$ Sycamore Row $(2013)$

Gray Mountain $(2014)$

Question $2(10$ marks$)$

Write queries to find the following:

$$ All the books published before $2000($by any author

$$ All the books published by John Grisham

$$ All the books not published by John Grisham

$$ All the books published between years $2000$ and $2009$

$$ The number of books published after $2009$

Question $3(10$ Marks$)$

Write queries to delete the following:

$$ All the books published before $2000($by any author$)$

$$ All the books published by John Grisham

$$ All the books not published by John Grisham

$$ All the books published between years $2000$ and $2009($by any author$)$

Total marks $100$ MARKS

Question $4($Community project$)(50$ Marks$)$

Either develop or select a mobile application. Demonstrate this application to a community of your

choice. Discuss the application created$/$selected and how this uplifted the selected community.