This assignment will assess your knowledge and skills about:

Creating and manipulating database entities.

Modifying data within database tables.

Assignment Information

In the previous week$$s assignment of Unit $4,$ you were assigned to develop a simple database system to manage a library. Use the same database schema of the entities:

Books $($with attributes: ISBN, Title, Author, Genre, and Quantity$)$

Members $($with attributes: MemberID, Name, Email, and Phone$)$

Loans $($with attributes: LoanID, MemberID, ISBN, LoanDate, and ReturnDate$)$

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.