Please enable JavaScript.
Coggle requires JavaScript to display documents.
ISYS2056: INFO SYSTEMS (Relational database management system (RDMS): A…
ISYS2056: INFO SYSTEMS
Hero's of Information Systems:
- Daniel Singer: Father of the spreadsheet
- Bill Gates: Chief executive and current chairman of microsoft
- Steve Jobs: CEO of apple
- Tim Berners: Father of the web - created http client services
- Mark Zuckerberg: co founder of Facebook
- Grace Hooper: CO BOL - uses english words to code
- Mike and Scott: Atalassian: Jira and from Austrlia
- Humantix: first non for profit ticketing platform
Satoshi Nakamoto: Bitcoin
Data: facts and figure without any real meaning or context
Information: data that has been made meaningful e.g. context
Knowledge: info that has been incorperated into someone's view of the world
- typically defined and structured in some way
Big Data: high volume, high velocity and high . variety
- " organisations have access to a wealth of data and don't know how to get its full value
System: a collection of interrelated componenets that function together to achieve some well define purposes which include:
- inputs
- outputs
- subsystems
- boundaries etc
Nice problems: well defines structured comprised of parkts and relationships - suitable for systematic reduction
Messy problems: real world problems are usually ill structed and messy
RICH PICTURES:
- suitable for message problems
- pictorial and easy to comprehend
- includes a key for complaits
- title in the bubble with people included inside and external people outside
Bus intelligence: info that results from the processing of operational data to create information that exposes patters, trends etc
Bus Analystics: the use of data, information etc to help managers build their understanding
- Descriptive analytics: the use of data to understand past and current business performance and so make informed decisions (past and current)
- Predictive analytics: analysis of past performance in an effort to predict the future through examining and then extrapolating these relationships forward
- Prescriptive Analytics: using a model where the output of the model can be optimised by adjusting the input alternatives
Data Visualisation: the visual representation, to facilitate the exploration of that data to generate insights that can increase understanding and to inform decision making
- WHAT: a set of techniques which we can make use of - involves displaying data sets in visual formats
- WHY: aim is to reveal patterns/trends by presenting data in particular ways. Easy to communicate. Facilitate exploration
- HOW: tools including excel
EXCEL
Sparklines: miniature charts that fit in a single cell. Since they are so compact, you can place a large number of them in your worksheets (line, column, win/loss)
Conditional Formatting: apply formatting to one or more cells based on the value of the cell
Pivot Tables and charts:
- summarise the data to allow you to manipulate it accordingly
- allows you to recognise and summarise selected columns and rows of data to obtain desired report
Forms of Communication:
Non-verbal communication: the nonlinguistic transmission of information through visual, auditory, tactile and knesthetic channels
Written: include letters, emails etc PROS permanent DADV does not save costs
Verbal Comms: need to be effective, respectful
Human Computer interaction: Disciple concerned with the design with the design, evaluation and implementation of interactive computing systems for human use and with the study of major phenomena
- Learnability: how fast can the user learn to use the interface
- Memorability: If the user used the system at an earlier date, can they remember enough to use it effectively
- Efficiency of use: once learnt the system, how fast can they accomplish a task
- Errors: how often do users make errors while using the system, how serious and how easy to recover?
- Subject satisfaction: How much does the user like the system?
Good interface design heuristics:
- use simple and natural dialogue - match the users tasks in as natural way as possible
- Be consistent - consistency of effects e.g. same commands, graohics
- Speak the users language
- Minimise users memory load
- Provide feedback
- Provide clearly marked exits
- Provide shortcuts
- Deal with errors in a positive manner
- provide help
- screen design - easy to read e.g. dark background with bright text
5 Step process to business problem solving:
- Problem analysis - what type of problem is it? use rich pictures, create boundaries to the problem
- Problem understanding - fact collection to obtain better information e.g. interviews
- Decision making - the process of selecting the best optimal solution. Needs to be checked for viability
- Solution design - develop the proposed solution taking physical, logical and people factors into consideration
- Implementation - put the proposed solution into practise, evaluation and modify
TOP:
- technology
- Organisational
- People
Functional design: focuses on the business solutions functionality - the solution is then reimaginsed and build. At heart is innovation design.
Empathetic design: seeks to identify business solutions design activities. It is at heart creative activity.
Blackbox database model:
- processing in databases is usually hidden from business users
- they don't worry about how its done
- they DO worry about what goes in (data) and what comes out (information)
Relational database management system (RDMS): A collectin of tables (data files) related/joined to one another by common data elements
CONS: redundant data - duplicated data. Wasters time and space. Avoiding redundancy through creating relationships.
- Entities (tables): Something that the business wishes to store data about
- Fields (Attributes, columns): characteristics/descriptors/properties of an entity
Relationships: set up relationships between tables to allow data manipulation
- one to one
- one to many
- many to many
Dynamic query: encourages the user to enter data (due to [ ] brackets)
Foreign key: is the primary key from the one side in the many side
ebusiness: any business transaction or activity that uses networks including the internet
ecommerce: subset of ebusiness specifically includes all electronically mediated information exchanges between an organisation and its external stakeholders
RFID: automatic data capture (ADC) techniques
- these automate the handling (such as trancking) of items using barcodes and code numbers (RFID is most rescent)
- can be read through substances
- high speed
Near-Field Communication (NFC)
- a set of communication protocols that enables two electronic devices, to establish communication by bringing them within 4cm of each other. Subset of RFID
Blockchain: a time-stamped series of immutable record of data manager by a cluster of computers not owned by a single entity. Each block is secured and bound to eachother using cryptographic principles
B2B (business to business): where the participants in the sales transactions are both businesses
Supply chain management: process of managing flow of goods and services starting from supply to then the customer.
- upstream: defines everything that comes into the company supplies
Downstream: defines everything that goes out of the company after proaction cycle
Web 1.0 refers to the first stage in the world wide web, made up of web pages connected by hyperlinks - full of static websites
Web 2.0 allowed interaction and collaboration - connection is faster with more supportive software
Web 3.0 semantic web - understands the relationships between data in order to provide context and meaning
Internet of Things (IoT):
the network of physical objects or things embedded with eletronics etc to enable it to achieve greater value and service by data with the manufacturer. Describes a world where just about anything can be connected and communicated in an intelligent fashion
-