https://www.kaggle.com/competitions/sentiment-anal… Requirements
The information system produced should be of medium complexity level.
It is anticipated that the final database will have
between 5 and 10 tables
a minimum of 4 queries
a minimum of 2 visualisations
the database that is created should be in a format that is easy to run, MS Access
with all necessary instructions. If using other software such as node-red all supporting
flows and files should be provided too.
Each student should identify an information system topic to develop, and also a source of data
that can be used to populated the database.
The information system must do the following
Store the data
Process the data – the raw data should be manipulated to produce summary information.
Visualise the data – the raw and/or processed data should be visualised.
The following actions should be performed
(Enhanced Entity Relation Diagram)
Produce a relational schema (ie table details) for your database from your conceptual
model.
Populate your database with either dummy data or open source data appropriate for your
approved database idea
Normalise your database tables
Implement your information system in your chosen software
Write a report that details all the work you have done, ie
The need for your system
The data source(s) for your system
The user requirements for your system
The semantic modelling (EERD) of your system
Knowledge and Information Management for Engineers
information requirements.
Deadline
Get approval from Dr for your database idea and source BEFORE you start •
Determine what the user requirements for your information system will be
Determine what the interface requirements for your information system will be
Produce a conceptual model of your database
Task
Design, develop, implement and report on an appropriate information system to meet the identified
adminX
Subject expert at Treatisely.