INF3703 Assignment 02 2022 Real Case Study Report

TABLE OF CONTENTS PAGE


1. DESCRIBING THE ORGANISATION SITUATION
1.1. Organisation full address 3
1.2. Organisation mission or business objectives 3
1.3. Organisation general operating environment 3

1.4. Organisation structure 4
2. DEFINING PROBLEMS AN CONSTRAINS
2.1. Description of the challenges facing the organisation 5
2.2. Identify the project constraints 5

3. PROJECT OBJECTIVES 6
4. PROJECT SCOPE AND BOUNDARIES PERMISSION 6
5. SOURCES OF INFORMATION 7
6. INFORMATION COLLECTED AND PROCESSED 7
7. PROPOSED BUSINESS RULES 8
8. DATABASE DESIGN APPROACH 9
9. CONCEPTUAL DATABASE DESIGN
9.1. Main entities 9
9.2. Primary and foreign keys 10
9.3. Normalised entities 10

9.4. ER diagram 11
10. LOGICAL DATABASE DESIGN
10.1. Relational model 12

11. PHYSICAL DATABASE DESIGN
11.1. Composite/Transaction usage map 13

11.2. Estimation of hard disk space 13
12. DEFINE AND EXPLAINED TRANSACTIONS 14
13. FORMULATE POSSIBLE SQL STATEMENTS FOR THE DATABASE 14
14. DISCUSSION OF DIFFERENT DATABASE PERFORMANCE TURNING
METHODS/CONCEPTS 16
15. QUESTIONS AND ANSWERS

15.1. Challenges Encountered and How They Were Handled 17
15.2. Question and Answers 17
16. DECLARATION 19

1
INF3703_ASS02_2020