NAME :
STUDENT NO :
MODULE : INF3703
ASSIGNMENT : 2
UNIQUE NO. :
Page 0 of 13
, Table of Contents
DESCRIBING THE ORGANISATION SITUATION ...................................................................... 2
Organisation full name ..................................................................................................................... 2
Organisation mission or business objectives .................................................................................. 2
General operating environment....................................................................................................... 2
Organisation structure ..................................................................................................................... 2
DEFINING PROBLEMS AN CONSTRAINS ................................................................................... 3
Description of the challenges facing the organization ................................................................... 3
Project constraints ............................................................................................................................ 4
PROJECT OBJECTIVES.................................................................................................................... 4
PROJECT SCOPE AND BOUNDARIES PERMISSION ................................................................ 4
INFORMATION COLLECTED AND PROCESSED ...................................................................... 4
PROPOSED BUSINESS RULES ........................................................................................................ 5
DATABASE DESIGN APPROACH ................................................................................................... 6
CONCEPTUAL DATABASE DESIGN.............................................................................................. 6
Main entries ....................................................................................................................................... 6
Primary and foreign keys ................................................................................................................. 6
Normalized entities ........................................................................................................................... 6
ER Diagram ....................................................................................................................................... 7
LOGICAL DATABASE DESIGN ....................................................................................................... 7
Relational model................................................................................................................................ 7
Integrity constraints.......................................................................................................................... 9
PHYSICAL DATABASE DESIGN ..................................................................................................... 9
Composite/Transaction usage map................................................... Error! Bookmark not defined.
Estimation of hard disk space .......................................................................................................... 9
DEFINE AND EXPLAINED TRANSACTIONS ............................................................................. 10
FORMULATE POSSIBLE SQL STATEMENTS FOR THE DATABASE ................................. 10
DISCUSSION OF DIFFERENT DATABASE PERFORMANCE TURNING
METHODS/CONCEPTS ................................................................................................................... 11
PRESENT THE DATABASE PERFORMANCE TURNING APPROACH USED AND
REASONS............................................................................................... Error! Bookmark not defined.
QUESTIONS AND ANSWERS ......................................................................................................... 12
Challenges encountered and explain how you handle them........................................................ 12
How you think the assignment can be improved.......................................................................... 13
Page 1 of 13
STUDENT NO :
MODULE : INF3703
ASSIGNMENT : 2
UNIQUE NO. :
Page 0 of 13
, Table of Contents
DESCRIBING THE ORGANISATION SITUATION ...................................................................... 2
Organisation full name ..................................................................................................................... 2
Organisation mission or business objectives .................................................................................. 2
General operating environment....................................................................................................... 2
Organisation structure ..................................................................................................................... 2
DEFINING PROBLEMS AN CONSTRAINS ................................................................................... 3
Description of the challenges facing the organization ................................................................... 3
Project constraints ............................................................................................................................ 4
PROJECT OBJECTIVES.................................................................................................................... 4
PROJECT SCOPE AND BOUNDARIES PERMISSION ................................................................ 4
INFORMATION COLLECTED AND PROCESSED ...................................................................... 4
PROPOSED BUSINESS RULES ........................................................................................................ 5
DATABASE DESIGN APPROACH ................................................................................................... 6
CONCEPTUAL DATABASE DESIGN.............................................................................................. 6
Main entries ....................................................................................................................................... 6
Primary and foreign keys ................................................................................................................. 6
Normalized entities ........................................................................................................................... 6
ER Diagram ....................................................................................................................................... 7
LOGICAL DATABASE DESIGN ....................................................................................................... 7
Relational model................................................................................................................................ 7
Integrity constraints.......................................................................................................................... 9
PHYSICAL DATABASE DESIGN ..................................................................................................... 9
Composite/Transaction usage map................................................... Error! Bookmark not defined.
Estimation of hard disk space .......................................................................................................... 9
DEFINE AND EXPLAINED TRANSACTIONS ............................................................................. 10
FORMULATE POSSIBLE SQL STATEMENTS FOR THE DATABASE ................................. 10
DISCUSSION OF DIFFERENT DATABASE PERFORMANCE TURNING
METHODS/CONCEPTS ................................................................................................................... 11
PRESENT THE DATABASE PERFORMANCE TURNING APPROACH USED AND
REASONS............................................................................................... Error! Bookmark not defined.
QUESTIONS AND ANSWERS ......................................................................................................... 12
Challenges encountered and explain how you handle them........................................................ 12
How you think the assignment can be improved.......................................................................... 13
Page 1 of 13
