
Introduction to Database Concepts
Quiz by LUCY FELIX
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Stored representations of objects and events that have meaning and importance in the user’s environment.
Data that have been processed in such a way as to increase the knowledge of the person who uses it.
Data that describes the properties or characteristics of end-user data and the context of that data.
An application program (or set of related programs) that is used to perform a series of database activities (create, read, update, and delete) on behalf of database users.
An integrated decision support database whose content is derived from the various operational databases.
A rule that cannot be violated by database users*
An organized collection of logically related data.
A person, place, object,event, or concept in the user environment about which the organization wishes to maintain data.
A software system that is used to create, maintain, and provide controlled access to user databases.
A traditional methodology used to develop, maintain, and replace informationsystems.
The first step in database development, in which the scope and general contents of organizational databases are specified.
A detailed,technology-independent specification of the overall structure of organizational data.
Data representation for a particular data management technology (such as the relational model). In the case of a relational data model, elements include tables, columns, rows, primary and foreign keys, and constraints.
A set of specifications that details how data from a logical data model (or schema) are stored in a computer’s secondary memory for a specific database management system. There is one physical data model (or schema)for each logical data model.
A conceptual blueprint or plan that expresses the desired future structure for the information systems in an organization.
Data descriptions are included with the application programs that use the data
A centralized storehouse for all data definitions, data relationships, and other system components
It stores historical data at a chosen level of granularity or detail and are used for data analysis purposes, to discover relationships and correlations about customers, products, and so forth that may be used in strategic decision making
It is a system that integrates operational data at the enterprise level, integrating all facets of the business, including marketing, production, sales, and so forth
It is a disadvantage of File Processing where different systems/programs have separate copies of the same data.
Give one (1) disadvantage of File Processing?
How do you convert data to information
A database designed for one user, may be located on a desktop or laptop PC, PDAs, or other handheld devices
A database designed for a small team of people (< 25)collaborating on projects or applications
A database designed for a functional unit in an organization and services between 25 to 100 people
A database designed to support the entire organization orenterprise for operations and decision-making; usually supports multipledepartments
A database designed to support Web browser access to applications and databases
Give one of the major components of a typical database environment
Give one of the benefits of a Database Approach
Give one of the costs or risks of Database Approach
What database technologies were used in the first generation?
What database technologies were used in the second generation?
What database technologies were used in 1960s?
What database technologies were used in the third generation?
Name the five phases of the traditional System's Development Life Cycle
One of the advantages of program-data dependence is the flexible formats for files.
Data redundancy supports data integrity.
All database technologies involve tables (relations) representing entities and primary/foreign keys representing relationships.
A project data model is a more detailed view, matching datastructure in database or data warehouse
In the traditional SDLC, the different phases can be performed in any order.
Program-data independence allows changes to application programs without requiring changes in data storage structure