Unit 1 : Introduction Flashcards
What is data? ( 2 )
- Raw facts, building blocks of information
- Unprocessed information
What is information?
- Data processed to reveal meaning
Fill in the blanks
___ , ____, and _____, information is key to good ______ making
- Accurate
- Relevant
- Timely
- Decision
- Good decision making is the key to survival in global environment
What is Database?
- Shared, integrated computer structure that stores End user data and Metadata
- Shared means that it is accessible to multiple users or applications simultaneously
- Integrated means that it combines data from various sources into a single, cohesive structure to provide a unified view of information, eliminatiing redundancy and ensuring consistency
What does database stores ? ( 2 )
- End user data ( raw facts, data )
- Metadata ( data about data )
- Example about metadata : EmployeeID itself is a piece of data, which tells us to store employee id number, this is a part of the metadata because it provides a description of what the data in that column represents
What is a DBMS and its main functions? ( 2 )
- It is a collection of programs that manages the database structure and controls access to data
- Manages the database structure and controls access to data
Can data be shared among multiple applications or users in a DBMS?
- Yes
How does DBMS benefit data management?
- It makes data management more efficient and effective
How does a DBMS benefit end users?
- They have better access to more and better-managed data
How does a DBMS affect the view of an organization’s operations? ( Role and Advantages of the DBMS )
- It promotes integrated view of organization’s operations
What impact does a DBMS have on data inconsistency? ( Role and Advantages of the DBMS )
1.It was greatly reduced with DBMS
How does DBMS handle ad hoc queries? ( Role and Advantages of the DBMS )
- DBMS makes it possible to produce quick answers to ad hoc queries
What is ad hoc queries?
- Is a query that is created on the fly to answer a specific question of obtain a particular piece of information from a database
- ad hoc means needed
- Example for an ad hoc queries
SELECT LastName, FirstName
FROM Person.Person;
What is the benefits of ad hoc queries?
- Quick Response
- Allow users to get answers quickly without waiting for a pre-built report
- Customization
- Users can ask a very specific questions that a standard report might not cover
How can we classified the types of location? ( 3 )
- Location
- User
- Use
List out all the types of databases ( classified by user )and a simple description ( 5 )
- Single-User
- Supports one user at a time
- Desktop
- Single-user database running on a personal computer
- Multi-User
- Supports multiple users at the same time
- Workgroup
- Multi-user database that supports a small group of usrs or a single department
- Enterprise
- Multi-user database that supports a large group of users or an entire organization
List out all the types of databases ( classified by location ) and a simple description ( 2 )
- Centralized
- Data located at a single site
- Distributed
- Data distributed across several sites
List out all the types of databases ( classified by use ) and a simple description ( 2 )
- Transactional ( Production )
- Data Warehouse
- Used to generate information required to make tactical or strategic decisions
What does Data Warehouse usually store?
- Historical Data
What database structure is quite different?
- Data Warehouse
Which database supports company’s day-to-day operations?
- Transactional ( Production ) Database
Which database stores data used to generate information required to make tactical or strategic decisions?
- Data Warehouse
