- Have not yet been processed to reveal their meaning to the end user
2. Building blocks of information
3. Data management: generation, storage, and retrieval of data
Information - correct answer ✔✔- Produced by processing raw data to reveal its meaning
- Requires context
- Bedrock of knowledge
- Should be accurate, relevant, and timely to enable good decision making
Database - correct answer ✔✔-Shared, integrated computer structure that stores a collection of:
1. End-user data: raw facts of interest to end user
2. Metadata
-Data about data, which the end-user data are integrated and managed
- Describe data characteristics and relationships
Database management system (DBMS) - correct answer ✔✔- Collection of programs
- Manages the database structure
- Controls access to data stored in the database
Roles of DBMS - correct answer ✔✔- Intermediary between the user and the database
- Enables data to be shared
- Presents the end user with an integrated view of the data
- Receives and translates application requests into operations required to fulfill the requests
- Hides database's internal complexity from the application programs and users
,Why are there so many different types of databases? - correct answer ✔✔- Each database provides
different functions that cater specifically to the people or organizations using it
What are the challenges related to file systems? - correct answer ✔✔- Lengthy development times
- Difficulty of getting quick answers
- Complex system administration
- Lack of security and limited data sharing
- Extensive programming
Structural Independence - correct answer ✔✔- File structure is changed without affecting the
application's ability to access the data
Data Independence - correct answer ✔✔- Data storage characteristics is changed without affecting the
program's ability to access the data
Data Redundancy - correct answer ✔✔1. Unnecessarily storing same data at different places
2. Islands of information: Scattered data locations
- Increases the probability of having different versions of the same data
Problems with data redundancy - correct answer ✔✔- Poor data security
- Data inconsistency
- Increased likelihood of data-entry errors when complex entries are made in different files
- Data anomaly: Develops when not all of the required changes in the redundant data are made
successfully
Types of data anomaly - correct answer ✔✔1. Update
2. Insertion
3. Deletion
, Data Models - correct answer ✔✔- Simple representations of complex real-world data structures
- Useful for supporting a specific problem domain
Importance of Data Models - correct answer ✔✔- Are a communication tool
- Give an overall view of the database
- Organize data for various users
- Are an abstraction for the creation of good database
Building Blocks of Data Models - correct answer ✔✔1. Entity: Unique and distinct object used to collect
and store data
- Attribute: Characteristic of an entity
2. Relationship: Describes an association among entities
- One-to-many (1:M)
- Many-to-many (M:N or M:M)
- One-to-one (1:1)
3. Constraint: Set of rules to ensure data integrity
Business Rules - correct answer ✔✔- brief, precise, and unambiguous description of a policy, procedure,
or principle
- enable defining the basic building blocks
- describe the main and distinguishing characteristics of the data
Why are Business Rules important - correct answer ✔✔1. Help standardize company's view of data
2. Communications tool between users and designers
3. Allow designer to:
- Understand the nature, role, scope of data, and business processes
- Develop appropriate relationship participation rules and constraints
- Create an accurate data model
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller BravelRadon. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $19.99. You're not tied to anything after your purchase.