Please enable JavaScript.
Coggle requires JavaScript to display documents.
Database management systems (Capabilities and features (Strengths) (Data…
Database management systems
Limitations (Weaknesses)
Software and hardware can be costly
Data conversion from a large spreadsheet is a complex task and can be costly with a specialist. Fields and tables need special attention for setup
Staff need training
If hardware failure or corruption, huge impact for organisation with staff not being able to do their work
Capabilities and features (Strengths)
Data redundancy is reduced by centralising different data sources into one database
Multiple users can use the same data
Data integrity via validation
Can be locked down to only authorised users for editing
Multiple data fields can be updated in one transaction
User interfaces can be designed for commons users (G.U.I.)
Reports can be saved easily for data visualisation
Concurrency of data when two users editing the same field
Risks (Threats)
Garbage in = garbage out
Version control of data
Privacy with prevention of unauthorised users
Prevention of hackers
Prevention of authorised users stealing or damaging data
Complex, time consuming to design
High training costs of staff -- high staff turn over
High costs of running the system
Power
Hardware
Software
Benefits (Oppurtunities)
Store all of your data on one place
Reduced staffing costs due to ease of accessing data
Cross correlate records of several periods of time
Easy to use interfaces produce elegant reports
More readable to a wider audience