Ask a question from expert

Ask now

Entity Relationship Diagram Assessment

Deliver a report based on the deliverable tasks provided in the case study of Thomson Cycles, covering topics such as database design, database normalization, architecture design, UI design principles, usability, and user experience goals.

20 Pages2817 Words21 Views
   

Added on  2022-08-25

Entity Relationship Diagram Assessment

Deliver a report based on the deliverable tasks provided in the case study of Thomson Cycles, covering topics such as database design, database normalization, architecture design, UI design principles, usability, and user experience goals.

   Added on 2022-08-25

BookmarkShareRelated Documents
Running head: SYSTEM ANALYSIS
SYSTEM ANALYSIS
Name of the Student
Name of the University
Author Note
Entity Relationship Diagram Assessment_1
SYSTEM ANALYSIS
1
Table of Contents
Task 1 Database Design...................................................................................................................2
Entity Relationship Diagram.......................................................................................................2
Task 2 Database Normalization.......................................................................................................4
First Normal Form.......................................................................................................................4
Second Normal Form...................................................................................................................6
Third Normal Form......................................................................................................................8
Task 3 Architecture Design.............................................................................................................8
Deployment Diagram...................................................................................................................8
Task 4 UI Design principles & User Interface Mock-up.................................................................9
Task 5 UI Design process..............................................................................................................13
Scenario.....................................................................................................................................13
Navigation Diagram...................................................................................................................14
Define/apply the standards in UI design....................................................................................16
Prototyping technique and interface evaluation technique........................................................16
Task 6 Usability and User experience Goals.................................................................................17
Key requirements.......................................................................................................................17
Bibliography..................................................................................................................................18
Entity Relationship Diagram Assessment_2
SYSTEM ANALYSIS
2
Task 1 Database Design
Entity Relationship Diagram
Class Diagram is a part of Unified Modelling language whereas the Entity Relationship
diagram is a structural approach of system modelling. An ERD illustrates the real life objects as
entity, attributes and relationship between them. In the field of business information, software
engineering and education, the entity relationship diagram plays major role in development.
Below diagram has been mapped from the provided class diagram of the Thomson Cycle where
the methods are not included as an ERD only contains attributes. The stock maintenance and
system interface class has not been taken into the account as they contain product related
attributes. They have been included in the product table. Also the order status class is also
eliminated due to not having atomic values and it is related to the order table, hence an attribute
named “Status” has been included in the order table. The table booking reference has also been
neglected as it does contributes heavily in the process of booking and order system.
Entity Relationship Diagram Assessment_3
SYSTEM ANALYSIS
3
Figure 1: Thomson Cycle ERD diagram mapped from Class Diagram
Source: created by author
Entity Relationship Diagram Assessment_4

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database Management System | Report | Assignment
|7
|719
|50

Database Management System | Report
|13
|767
|15

DATA & KNOWLEDGE MANAGEMENT
|19
|3471
|23

Database Design and Implementation: ER-Model, Relational Schema, Constraints, and Business Intelligence
|5
|1023
|448

Database Design Assignment | Modifying a Database Design
|5
|719
|318

Data Modelling: Conceptual, Logical and Physical Models
|16
|2565
|499