IOM205 Advanced Database Management
Scenario: [Same as in the GROUP COURSEWORK]
Task Details/Description:
The primary task for this part of the coursework is to individually produce a fully tested and functional database application that has been implemented using Microsoft Access. Please
note, you MUST at a (or the) minimum have the following functionalities in your database application to score a passing mark for the corresponding grading component. Please refer to the last two pages of this document for the grading components and criteria.
• The database must support several business processes described in the scenario context and specification. You may change some of the design produced in the group coursework
based on the feedback received from the instructors.
Weeks 6, 8 and 9
• Include functionality (forms, queries, reports and charts) to support the main operations of the company. The database should be able to: add, edit and remove books, order
books, generate invoices, reorder low stock and produce useful management information (e.g. total value of stocks).
Weeks 6, 8 and 9
• Entities should be identified by a concise and relevant set of attributes. They must include the basic attributes and be realistic but need not be fully comprehensive for the prototype.
Continue/revise on what has been produced in GROUP coursework
• Include at least two non-trivial queries. Your queries should demonstrate the use of multiple tables, parameters, calculated fields and multi-stage query. You should also produce appropriate SQL code for at least one of your queries. The code should be annotated in the report to demonstrate your understanding (please refer to ID2.4 below in the deliverables section).
Week 6 Lecture and demonstration
• Include at least one unbounded form, one trivial and one non-trivial form, that will help to realise key business needs, i.e. gather inputs and produce the correct output,
which are user-friendly and displayed in an appropriate manner to the user (e.g. home page – unbounded form, add a new customer – trivial form, add new customer order, reorder books – non-trivial forms).
Week 6 Video tutorials
• Include two neatly formatted Access reports to provide useful management information. Include at least one level of grouping, and at least one summary/calculated field (e.g. customer invoice, most valued customer based on purchase orders, most popular books sold or reordered, total expenses incurred towards each publisher, most valued employee based on sales).
Week 8 Lecture and Videos
• Include one Access chart that illustrates some key operational information from the application to the organisation (e.g. sales made each month, popular books). Week 8
Lecture and Videos
my wechat：_0206girl
Don't hesitate to contact me
