Scribd
Upload
91 views2 pages

Assignment 1 Guidance: Task 1 - Statements of User and System Requirements (P1)

The document provides guidance for two tasks for an assignment. Task 1 involves stating user and system requirements for a university management system using a user story format. It must include at least two user roles and CRUD and statistical actions. Task 2 is to design a relational database for the system with at least four tables and explanations. The design must be assessed for normalization and include data validation and wireframes. A report structure is outlined with two chapters, one for each task's requirements and database design.

Uploaded by

Guys Good
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
91 views2 pages

Assignment 1 Guidance: Task 1 - Statements of User and System Requirements (P1)

The document provides guidance for two tasks for an assignment. Task 1 involves stating user and system requirements for a university management system using a user story format. It must include at least two user roles and CRUD and statistical actions. Task 2 is to design a relational database for the system with at least four tables and explanations. The design must be assessed for normalization and include data validation and wireframes. A report structure is outlined with two chapters, one for each task's requirements and database design.

Uploaded by

Guys Good
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Assignment 1 Guidance

Task 1 - Statements of user and system


requirements (P1)
In this part, you have to present users’ requirements of your system. To make it simpler to
understand for the CEO, you can use the format of User Story below to describe
requirements
As a < type of user >, I want < some goal > so that < some reason >.
The system must have at least 2 user roles, including business processes for FPT
university managers.
The system must include CRUD actions (Create/ Read/ Update/Delete) and at least 5
advanced statistical action
(Word limit: 300 – 500 words)

Task 2 – Design the relational database


system (P1 – M1)
Next, you will design the relational database system using appropriate design tools and
techniques. It should contain at least four interrelated tables with detailed explanation for
the design and each table. You will assess whether the database is normalized and adapt
the users’ requirements. If the database is not normalized, you have to a clear reason to
justify it. You will have to include the final database design with clear explanation.

You would prefer to produce a more detailed document, so you will produce a
comprehensive design for a fully functional system which will include Wireframes, data
validations and cover data normalization.

Your manager would like on the report your assessment of the effectiveness of the design
in relation to user and system requirements.
(Word limit: 1000 – 1500 words)

1
Report Structure
Chapter 1 - Statements of user and system
requirements
1.1 Overview about the Problem
1.2 Requirements of the application

Chapter 2 – Design the relational database system


2.1 Analyse the requirements
2.2 Database design with explanations
2.3 Review whether the database is normalized
2.4 Data validation
2.5 Wireframe of the application

You might also like