Lesson 1 (Week 1-2) Flashcards
____ is the management of organizational processes and systems that acquire, create, organize, distribute, and use information.
Information management
A Database (DB) is structure that can store information about:
- multiple types of entities,
- attributes that describe entities
- relationships among entities
A Database (DB) is collection of related data - with the following properties:
- A DB is logically coherent and has some relevant meaning
- A DB is designed, built and populated with data for a specific purpose
- A DB represents some aspect of the real world.
____ Models which show how the users recognize the business
User or Conceptual Models
____ implies the logic of business operations. The relationship between different components and the flow of data through the organization are examples of this model
Logical Models
____ which denotes the actual methods in implementing the database on a computer system based on the logical model
Physical Models
____ is a collection of software programs used to define, create, operate and maintain data in a database
Database Management System
refers to a structure which contains the database, the database management system, and the application programs in which the users interact.
Database System
A ____ consists of isolated data which makes it difficult to organize and represent.
File system
Advantages of a DBMS
- Data Consistency and Integrity
- Application program independence
- Data Sharing
- Backup and Recovery
- Security and Privacy
Multiple views of data
A Database usually consists of:
- User Data
- Metadata
- Indexes
- Application metadata
Users of data operate directly by inserting, modifying and viewing data. We will use tables as storages for data having some relationships between them. Each table contains one or more columns. A set of columns create a database record.
User Data
A database is self-describing. ____ refers to data about data. It describes the means of storing user data in terms of table and column name, length, data type, primary keys, etc.
Metadata
____ give us alternative means of accessing user data by sorting and searching.
Indexes
____ can be accessed through database development programs and provide facilities for storing forms, reports, queries and other modules of an application.
Application Metadata
____ refers to the activity of identifying the schema of a database in a given data model.
Database Design
____ is the database structure that depicts the relationships, data types and constraints, which is not dependent on any application.
Database Schema
A set of activities for defining the structure of a database is called a ____.
data model
The term ____ or state is used for the actual data in a database at a given time.
database instance
The Database Development Process
- Determining user requirements and evaluating their needs
- Data Modeling
- Implementation
- Testing
- Deployment
