Entity Relationship Diagram Assessment
Added on 2022-08-25
20 Pages2817 Words21 Views
Running head: SYSTEM ANALYSIS
SYSTEM ANALYSIS
Name of the Student
Name of the University
Author Note
SYSTEM ANALYSIS
Name of the Student
Name of the University
Author Note
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
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
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.
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.
SYSTEM ANALYSIS
3
Figure 1: Thomson Cycle ERD diagram mapped from Class Diagram
Source: created by author
3
Figure 1: Thomson Cycle ERD diagram mapped from Class Diagram
Source: created by author
End of preview
Want to access all the pages? Upload your documents or become a member.
Related Documents
Database Management System | Report | Assignmentlg...
|7
|719
|50
Database Management System | Reportlg...
|13
|767
|15
DATA & KNOWLEDGE MANAGEMENTlg...
|19
|3471
|23
Database Design and Implementation: ER-Model, Relational Schema, Constraints, and Business Intelligencelg...
|5
|1023
|448
Database Design Assignment | Modifying a Database Designlg...
|5
|719
|318
Data Modelling: Conceptual, Logical and Physical Modelslg...
|16
|2565
|499