Language and expected due date list overdue copies

DSE2051 Information Systems Management

Assignment: Access Database

The table copies stores the data concerning each copy of the comic books in the library. They include the book title, publisher, author, cost, language, category and purchase date. Note there may be multiple copies of the same comic title (determined jointly by booktitle + language), which means that these copies share the same book title, language, publisher, author and category.

Part 1: Creating Tables (40%)

Modify the above preliminary design to eliminate redundant data storage and facilitate efficient filtering or sorting of records in subsequent queries. We expect a few tables being logically related together. For each table, determine appropriate table names, field names, primary key fields and field types, and have them filled in with the sample data shown above. There is no need for you to make up any other data.

3. The borrowing count of the comic titles (a unique [booktitle, language] as a single comic title) within some two borrowing dates being specified dynamically, arranged in descending order of popularity

4. The number of distinct comic titles in different categories

9. A list of overdue copies. You should include the copy_id, booktitle, language and expected due date.

10. A list of members who have overdue books. List these member IDs, full names and mobile numbers.