For this week$$s assignment, your task is to:

Extend the existing database schema to include the following table:

Authors $($AuthorID$,$ Name, Nationality, BirthYear$)$

Populate the tables with sample data. Include at least:

$10$ books

$5$ authors

$20$ members

Write SQL queries to perform the following operations:

Retrieve all books written by a specific author.

Drop the newly created Authors table.

Identify the names of all members who have borrowed a specific book.

Imagine a scenario where the "Members" table needs to be updated to include a new attribute called "MembershipType" to distinguish between different types of memberships. Write an SQL query to alter the "Members" table to include this new attribute.