Data correct answers 1. Raw facts
- 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 answers - Produced by processing raw data to reveal its meaning
- Req...
ITSS 4300 Exam 1 || A+ Guaranteed.
Data correct answers 1. Raw facts
- 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 answers - 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 answers -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 answers - Collection of programs
- Manages the database structure
- Controls access to data stored in the database
Roles of DBMS correct answers - 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 answers - Each database provides
different functions that cater specifically to the people or organizations using it
What are the challenges related to file systems? correct answers - Lengthy development times
- Difficulty of getting quick answers
- Complex system administration
- Lack of security and limited data sharing
- Extensive programming
Structural Independence correct answers - File structure is changed without affecting the
application's ability to access the data
Data Independence correct answers - Data storage characteristics is changed without affecting
the program's ability to access the data
Data Redundancy correct answers 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 answers - 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 answers 1. Update
2. Insertion
3. Deletion
Data Models correct answers - Simple representations of complex real-world data structures
- Useful for supporting a specific problem domain
Importance of Data Models correct answers - 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 answers 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 answers - 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 answers 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
Translating Business Rules into Data Model Components correct answers 1. Nouns translate into
entities
2. Verbs translate into relationships among entities
3. Relationships are bidirectional
4. Questions to identify the relationship type
- How many instances of B are related to one instance of A?
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 FullyFocus. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $11.49. You're not tied to anything after your purchase.
