Valuing and Storing Information, Intro to ER Diagrams

erocespinel
Mind Map by , created about 6 years ago

IS201 Mind Map on Valuing and Storing Information, Intro to ER Diagrams, created by erocespinel on 10/14/2013.

19
1
0
Tags
erocespinel
Created by erocespinel about 6 years ago
IS Security and Privacy
erocespinel
Entity-Relationship Diagrams, Database Design
erocespinel
OPTIMIZATION MODELING WITH SOLVER
erocespinel
Weimar Revision
Tom Mitchell
Quick tips to improve your Exam Preparation
James Timpson
Systems Development Life Cycle
erocespinel
USING EXCEL TO MEASURE THE SUCCESS OF STRATEGIC INITIATIVES
erocespinel
Untitled
erocespinel
Paradigms
erocespinel
HARDWARE/NETWORKING
erocespinel
Valuing and Storing Information, Intro to ER Diagrams
1 CONCEPTS
1.1 Fundamental concepts and benefits of the relational database model
1.1.1 Increased Flexibility

Annotations:

  • One Physical view but can have multiple logical views
1.1.1.1 PHYSICAL VIEW

Annotations:

  • The physical storage of information on a storage device like a hard drive
1.1.1.2 LOGICAL VIEW

Annotations:

  • How users logically access their information to meet their business needs; You can use the info differently and thereby have multiple logical views
1.1.1.2.1 RELATIONAL INTEGRITY CONSTRAINTS
1.1.1.2.1.1 BUSINESS-CRITICAL INTEGRITY CONSTRAINTS

Annotations:

  • Enforce business rules vital to an organizations success;  often requires more insight and knowledge than RI constraints Like a supplier of produce putting a return policy on produce that was delivered 15 days ago
1.1.1.2.1.1.1 DBMS DATA BASE MANAGEMENT SYSTEM

Annotations:

  • A software through which users and applications interact with a database
1.1.1.2.1.1.1.1 INTEGRATION

Annotations:

  • Allows separate systems to communicate directly with each other-WITHOUT IT, an org will spend a lot of time inputting the data in multiple systems AND suffer with low quality or inconsistent data
1.1.1.2.1.1.1.1.1 FORWARD vs BACKWARD INTEGRATION

Annotations:

  • Takes info and sends it automatically to all downstream systems and processes; vice versa
1.1.1.2.1.1.1.2 USER CAN INTERACT
1.1.1.2.1.1.1.2.1 DIRECTLY
1.1.1.2.1.1.1.2.2 INDIRECTLY
1.1.1.2.1.1.2 VS

Annotations:

  • Businesses that use constraints usually see fewer information errors and more use of organizational information
1.1.1.3 Increased Scalability and Performance

Annotations:

  • Scalability is how well a system can adapt to different demands How quickly a system performs a certain process or transaction
1.1.1.3.1 Reduced Information and Redundancy
1.1.1.3.1.1 Increased Information Integrity
1.1.1.3.1.1.1 Increased Information Security
1.1.1.3.1.1.2 RELATIONAL INTEGRITY CONSTRAINTS

Annotations:

  • Rules that enforce basic and fundamental information based constraints i.e NOt allowing to buy 0 of one product, or place an order for a non-existent customer
1.1.2 RELATIONAL DATABASE

Annotations:

  • A database the stores information in the form of logically related two-dimensional tables
2 KEY TERMS
2.1 INFORMATION GRANULARITIES

Annotations:

  • extent of DETAIL within the information
2.1.1 TRANSACTIONAL INFO

Annotations:

  • day to day operations-sales, purchases, updates
2.1.1.1 ANALYTICAL INFO

Annotations:

  • take some sort of transactional data and summarize it to make decisions
2.1.1.1.1 REAL-TIME IS

Annotations:

  • Immediate, up-to-date information per query requests
2.1.1.1.1.1 5 MEASURES OF INFO QUALITY
2.1.1.1.1.1.1 ACCURACY

Annotations:

  • Are all values correct? Name spelling, dollar amount recorded properly
2.1.1.1.1.1.2 COMPLETENESS

Annotations:

  • Are any values missing? Is address complete?
2.1.1.1.1.1.3 CONSISTENCY

Annotations:

  • Is aggregate or summary info in agreement with detailed info?
2.1.1.1.1.1.4 UNIQUENESS

Annotations:

  • Is each transaction, entity, an event only entered once in the info? Duplicate customers?
2.1.1.1.1.1.5 TIMELINESS

Annotations:

  • Is the info current with respect to the business requirements? Is info update, weekly, monthly, etc?
2.1.1.1.1.1.6 DATABASES
2.1.1.1.1.1.6.1
2.1.1.1.1.1.6.1.1 ENTITY

Annotations:

  • A table;
2.1.1.1.1.1.6.1.1.1 ATTRIBUTE

Annotations:

  • A column; A person, place, event, thing, transaction, or event about which information is stored
2.1.1.1.1.1.6.1.1.1.1 INSTANCE

Annotations:

  • ROWS of data
2.1.1.1.1.1.6.2 PRIMARY KEY

Annotations:

  • A field or group of fields that uniquely identifies an attribute
2.1.1.1.1.1.6.2.1 FOREIGN KEY

Annotations:

  • A primary key in one table that appears as an attribute in another table; Acts to provide a logical relationship between tables
2.1.1.1.1.1.7 ACCUT

Media attachments