Subject : Database Platform : Microsoft Access

QUESTION 2 (30 MARKS) Instruction: 1. Create a database. 2. Construct SQL statements for the following questions. 3. Screenshot your Ms Access output 4. Submit your Ms Access database Consider the following relational database: PUBLISHER (PublisherName, City, State, Country, Telephone) AUTHOR (AuthorNum, AuthorName) BOOK (BookNum, BookName, Publication Year, Pages, PublisherName) CUSTOMER (CustNum, CustName, Street, City, State, Country, BookNum) WRITING (BookNum, AuthorNum) BOOKNUM (BookNum, CustNum, BookDate, Price, Quantity) a) Create table PUBLISHER with 5 records (4 marks) b) Create table BOOK with 5 records (4 marks) c) Create table BOOKNUM (4 marks) d) Show the relationship between tables (3 marks) e) Modify table AUTHOR to add a new column called AuthorDOB. (3 marks) f) List the book number, book name and number of pages of all the books published by John Wiley. View the results by book name in descending order. (3 marks) g) Find how many books with at least 300 pages that is published by Pustaka Trading located in Jasin, Melaka (4 marks) h) Find the publisher which published the book that has the earliest publication year