INTRO RO DATABASW Flashcards
(20 cards)
What is a Database?
A database is a collection of organized data, information, and records.
What is the purpose of a Database?
Database is information that a person needs in their personal, business, social, and religious life. The power and purpose of information are not only in collecting and finding them but more importantly in using them.
What are the kinds of databases?
- Structured database
- Free-form database
What is a Structured database?
It is also called the structured data in which a record or file of information arranged in uniform format. These databases are usually storage of information with similar entries such as a list of persons born in a
country, a medical database of patients’ data, an inventory database of a company and many others.
What is a Free-form database?
It is a loose collection of information, such as those you will find on the World Wide Web. A collection of your documents in the computer made from several programs can be considered as free-form database.
What are the types of databases?
- Operational database
- Analytical database
What is an Operational database?
It is a dynamic database that is used by any organization in its day-to-day operation. They are used to collect data, maintain, modify and delete data.
What is an Analytical database?
It is a static database, where data is rarely modified.
This database is often used to store and track historical data to make long term projections and analysis.
What are Structured Database Models?
Different models of databases help organize and store data efficiently.
What is the Hierarchical Model?
This model can be visualized as a parent -child relationship wherein a child may only have one parent but parent can have several other
chllaren.
Another way of looking at this model is by visualizing an inverted tree. The single table acts as the root of the inverted tree and the other tables act as branches.
To access the data from one of the tables, one has to pass through the root table. This model was popular in the many IBM Information Management Systems in the 1970s using mainframe computers.
How does the Hierarchical Model access data?
To access data from one of the tables, one has to pass through the root table.
What is the Network Model?
This model was developed to address in part the problems of the hierarchical model. As with heirarchical model, it could be visualized as an inverted tree; however, this model allows many inverted tress sharing branches but are still part of the same database structure.
As with the parent-child model, the child is allowed to have multiple parents. Unlike in the heirarchical model access data begins from the root table.
In the network model, it allows access of data from any table. This model was eventually replaced by the relational database model.
How does the Network Model differ from the Hierarchical Model?
In the Network Model, the child is allowed to have multiple parents.
What is the Relational Model?
Developed by Dr. E.F. Codd, it consists of tables, which are collections of rows and columns.
What are attributes and domains in the Relational Model?
Attributes are the names given to each column, and domains represent the possible values of attributes.
What is the Entity-Relationship Model?
An abstract and conceptual representation of data written by Peter Chen in 1976.
What is the Dimensional Model?
A specialized adaptation of the relational model used to represent data in data warehouses.
What is the Object-Relational Model?
A model that utilizes the relational model as well as the object-oriented programming paradigm.
What is RDBMS?
RDBMS is designed to create, maintain, manipulate, modify, and delete information in a relational database.
What is the significance of RDBMS?
Modern databases utilize the relational database model, and many of today’s software caters to this type of structured database.
