Stage II (15 marks, a work document required)
This part continues the system development process to the stage of design. It is a technical part for you to demonstrate how a relational database system is constructed conceptually. The expectation is that you will analyse, build and document a module (sub-system) of a hypothetical database system, such as a sale and order module, a purchase and payment module, and a human resources administration module, for IS developers. You choose
one of the sample datasets
that are provided by the lecturer or obtained elsewhere by yourself to develop an ERD with all the essential elements normalised.
It is expected that you use Power BI to develop your ERD and produce a visualised query report. If you want to use other software, it is possible but you need to get the lecturer’s permission.
In recommendation, you need to review the dataset first to figure out what an interesting query would be, then go on to build up your data model.
In data modelling, it is expected students use Power BI as the tool.
The following requirements must be met in your work document:
1. Identify at least three entities (tables) with PK, FK and an attribute in your ERD, with the 3NF rules complied.
2. Show your relational data model in a screen shot
in Power BI
(or other software), with all many-to-many relationships resolved.
3. Create a visualised report of an informative query (such as the total sale value within a region, the inventory amount for a particular product and the factors affecting staff attrition) that is enabled in the data.
4. Explain, using two or three examples, why the database needs to be normalised.
You must combine all your answers in one document (in either Word or PDF formats) which you will submit. (The Moodle system can take only one document you’ve submitted for marking. This means your additional documents may not get marked).
The word count of your work document is expected to be around 800 (with the account of graphics taken). Harvard Referencing Style