Access QBE Activity

You have been asked to design a web page for the Very Terrific College Science Fiction club.
Create a table for ‘authors’. It should have at least name and ID.
Create a table for ‘works’. It should have at least ID, title, year, and type (book or movie).
Create a relationship table for ‘made’.  It should have ID for author and works.

Include the following authors:
Asimov, Isaac
Asimov, Janet
Toolkien, K.R.
Twain, Mark
Weber, David

Include the following works:
Norby, the Mixed-Up Robot (1983) (Janet and Isaac Asimov)
The Gods Themselves (1972) (Isaac Asimov)
The Honor of the Queen (1993) (David Weber)
Liberal Arts Through Science Fiction 2nd edition, 2023 (K.R.Toolkien)
A Connecticut Yankee in King Arthur’s Court

Write queries to:
List all books by Isaac Asimov
List all works written after 1984
Change the name Mark Twain in the database to be Samuel Clemens.