High prio Flashcards
(91 cards)
What are the four components of Architecture?
- Architect (interaction between actors and audience)
- Architecture (results and effects)
- Architecture methods (how to design and build)
- Environment (context, where to build, who/ how/ when to use)
What are the three key operations of data architecture?
- Data acquisition
- Data analysis / processing
- Data delivery
What are some social impacts of IT (3)?
- Climate change
- Health care
- Home / travel
What is the most popular conceptual model?
ER diagram which describes entities their relationships to other entities and their attributes.
What is a process model?
A process model consists of a starting node (event) and an ending node with other events and activities arranged between these nodes. A process can contain objects like events, activities and other processes, relationships between the nodes.
Name three concept modelling methods.
- ER (Entity Relation model)
- DFD (Data flow diagram)
- OM (Objectives model)
What is an Information system of an enterprise?
A collection of activities that regulate the sharing and distribution of information and the storage of data that are relevant to the management of the enterprise.
What is the typical breakdown of an information system’s lifecycle (7 steps)?
- Feasibility study.
- Requirement collection and analysis.
- Design.
- Prototyping. -> back to 2
- Implementation.
- Validation and testing.
- Operation.
Why can conceptual modelling not be helped by automatic tools?
Because the designers have the full responsibility for the process of understanding and transforming requirements into conceptual schemas.
What is the difference between a conceptual model and a logical model?
Conceptual models are tools for representing reality at a high level of abstraction and are used in database design. Logical models support data description that can be processed by a computer and are supported by DBMS.
What models are included in logical models?
- Hierarchical models
- Network models
- Relational models
What are the four qualities of conceptual models?
- Expressiveness. (Ability to express concepts and properties)
- Simplicity. (Easy to understand)
- Minimality. (Each concept must distinctly represent a meaning)
- Formality. (All concepts have a well-defined interpretation)
What are the basic concepts provided by the ER model?
- Entities (Classes of real-world objects) (rectangle)
- Relationships (aggregation of two or more entities) (diamond)
- Attributes (properties of entities or relationships)
What is the term for a relationship that connects more than two entities?
N-ary relationship
What is the term for inheritance in ER and how can it be represented?
Generalization: student -> person. Student IS-A person
ER. What are identifiers?
A collection of attributes that uniquely determine an entity. For example, a table has several legs and a flat surface.
ER. What is a composite attribute?
A composite attribute is an attribute that can be further divided into smaller sub-parts, each with its own meaning. An address can be divided into street name, city and post code.
What is a process?
A sequence of activities or a series of states
What is a workflow and what is it used for?
The definition, execution, and automation of business processes where tasks, information or documents are passed from one participant to another for action. They are used by organizations to coordinate tasks between people and to synchronize data between systems.
What four key benefits can a digital workflow provide to a company?
- Improved productivity
- Process transparency
- Faster business reaction time
- Improved accountability
What are the main elements that state diagram depicts and how are they represented(4)?
- Beginning: Dark circle
- States: rectangles with rounded corners
- Transitions: Arrows between states
- End: Dark circle with border
What is a DFD (data flow diagram) used for?
Mapping out the flow of information for any process or system. They can be used to analyse existing systems or to model new ones. They can describe things that would be difficult to explain in words.
What is functional analysis?
A function is a portion of the enterprise. Functional analysis is the modelling of working activities within the enterprise. It concentrates on understanding how it is used and exchanged by the functions. It is the first step to specification and design of applications that operate on the database.
What is the result of functional analysis?
A functional schema which contains a representation of activities, information flows and other features. A DFD is a functional schema.