Assignment 2 Guidance
Task 1 - Develop the database system (P2 โ
P3)
After the design is approved by the CEO, you need to implement it by using properly
queries to develop the full database system and user interface (Mock-up) of the system
described in the previous assignment.
You will need to present the final result with evidence images ( queries to create tables
and database, tables created, final ERD, final Mock-up) in the report.
Then, you want to include more than just the basics so you will implement a fully functional
database system which will include system security and database maintenance features.
(Word limit: 500 โ 1200 words)
Task 2 โ Produce queries (P3 โ M2 โ M3)
After fully developed the database system, you will need to produce queries to:
๏ทPerform Create / Update / Delete actions (INSERT INTO / DELETE / UPDATE)
๏ทAllow to extract useful information as described the previous assignment.
(SELECT / GROUP BY/ HAVING / BETWEEN / JOIN / MIN / MAX / SUM / AVG /
etc.)
๏ทFor advanced actions, Store Procedures / Triggers / Functions should be used
๏ทFor each query, you will have to include the evidence and final result of each query
execution
You will assess whether meaningful data has been extracted through the use of query
tools to produce appropriate management information.
Based on the assessment, you will evaluate the effectiveness of the database solution in
relation to user and system requirements described in the previous assignment and
suggest improvements.
(Word limit: 500 โ 1500 words)
Task 3 โ Test the system (P4 โ M4)
Once the system has been developed, you will test the system and your manager will
complete a witness statement indicating how your tests are performing against user and
system requirements.
You will produce a brief report assessing the effectiveness of the testing, including an
explanation of the choice of test data used.
1
