Examination Preperation
Abstract
Includes:
Summary
Exam Papers and memo’s
Previous MCQ’s
Assignments
Mock Exams
,INF3703 FULL SUMMARY
2022
Examination Preperation
Abstract
Full summary for the examinable chapters of the prescribed book for the module INF3703 for
the year 2022.
, Contents
The information system ............................................................................................................. 8
The Systems Development Life Cycle (Sdlc) ............................................................................... 8
1 Planning ............................................................................................................................... 8
Analysis ................................................................................................................................... 9
Detailed systems Design ......................................................................................................... 9
Implementation ...................................................................................................................... 9
Maintenance ........................................................................................................................ 10
THE DATABASE LIFE CYCLE (DBLC) ........................................................................................... 10
Analyse the Company Situation............................................................................................ 10
Define Problems and Constraints ......................................................................................... 10
Define Objectives ................................................................................................................. 10
The database design process ................................................................................................... 11
i. Conceptual Design ............................................................................................................. 11
ii. DBMS Software Selection ................................................................................................. 11
iii. Logical Design .................................................................................................................. 11
iv. Physical Design................................................................................................................. 11
10.3.3 Implementation and Loading ........................................................................................ 12
install the DBMS ................................................................................................................... 12
Create the Database(s) ......................................................................................................... 12
Load or Convert the Data ..................................................................................................... 12
10.3.4 Database security .......................................................................................................... 13
Data Security Measures........................................................................................................ 13
10.3.5 testing and evaluation ................................................................................................... 14
Software: .............................................................................................................................. 14
Hardware:............................................................................................................................. 14
Programing exemptions: ...................................................................................................... 14
Transactions: ........................................................................................................................ 14
10.3.6 Operation ...................................................................................................................... 15
10.3.7 Maintenance and evolution .......................................................................................... 15
10.3.8 Determine Performance Measures ............................................................................... 15
4 Database DesIgn stRategIes .................................................................................................. 15
5 CentRaLIseD Vs DeCentRaLIseD DesIgn................................................................................. 15