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