A Car Sales Database System Case Study: Spear Motors

TABLE OF CONTENTS:

Declaration

Dedication iii

Acknowledgement iv

Table of Contents V

List of Abbreviations and Acronyms vi

List of Table vu

CHAPTER 1 1

1.1~

1.2 Background of Case study

1.3 Problem Statement 2

1.4 Aim of the study 2

1.5 Objectives of study 2

1.5.1 General Objective 2

1.5.2 Specific Objective 2

1.6 Scope of study 3

1.7 Significances of the study 3

v

C~H~AI~’I’E~R. 2.........,,,•,‘‘e’’’

2.0 LITERATURE REVIEW ...

2.1 Introduction 4

2.2 Database Model 6

2.2.1 Relational Model 7

2.2.2 Network Model 8

2.2.3 Relational Operations 8

CIIAPTER 3~9

3,0 SYSTEM ANALYSIS AND DESIGN...,..,.............................~..9

3.1 Data Collection Method 9

3.2 Analysis of Existing System 9

3.3 New System Design 10

3.4 System Testing 18

3.5 Security 18

3.5.1 Hardware Requirement 18

3.5.2 Software Requirement 18

CBAPTER4 19

4,0 IMPLEMENTATION,,,.,,.,,,.,,,,.,.,,,.,,,,,,.,..••,,,,....,..,, ,...,,,,,.,.,,.,, 19

4.1 User Guide 19

4.2 User-Level Authentication 20

vi

4.3 Functionality within the Database 21

4.4 Features of Database 23

4.4.1 Filter 23

4.4.2 Sort 23

4.4.3 Delete 23

4.5 Conclusion 24

CHAPTER 5..... ...,,... ,.“,, ..,..,......., . ., . ., . . . .., ..,................•.

5.0 CONCLUSION,RECOMMENDATIONS AND LIMITIONS....,25

5.1 Conclusion 25

5.2 Recommendations 25

5.3 Limitations of the study