KEMBAR78
Fundamental Database Concepts | PDF | Object Oriented Programming | Databases
Scribd
Upload
414 views2 pages

Fundamental Database Concepts

Table/Relation is the fundamental object of a database structure used to store data. A table consists of rows and columns, with rows representing records of related data fields arranged horizontally and columns representing individual fields arranged vertically. There are different database structures for organizing data, including hierarchical, network, relational, and object-oriented. Relational databases represent data as a collection of relations in the form of tables, with each row representing a real-world entity or relationship. Object-oriented databases follow object-oriented programming principles by representing data as objects and classes. Database development involves obtaining requirements, analyzing and designing the data system, and implementing operations to meet an organization's business needs and provide information to shareholders.

Uploaded by

Zunii Warraich
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
414 views2 pages

Fundamental Database Concepts

Table/Relation is the fundamental object of a database structure used to store data. A table consists of rows and columns, with rows representing records of related data fields arranged horizontally and columns representing individual fields arranged vertically. There are different database structures for organizing data, including hierarchical, network, relational, and object-oriented. Relational databases represent data as a collection of relations in the form of tables, with each row representing a real-world entity or relationship. Object-oriented databases follow object-oriented programming principles by representing data as objects and classes. Database development involves obtaining requirements, analyzing and designing the data system, and implementing operations to meet an organization's business needs and provide information to shareholders.

Uploaded by

Zunii Warraich
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 2

Fundamental Database concepts:

Table/ Relation : Table is a fundamental object of the database structure. The basic
purpose of table is to store data. A table consists of rows and columns. Table is also called
relation.
Rows / Record: Rows are the horizontal part of the table. It is a collection of related
fields. Each row contains the record of different person.
Columns / field: Columns are the vertical part of the table. A field is the basic unit of
data entry in a record. A field is a single piece of information. e.g. student name , roll no.
File: a file is a collection of records. For example, a telephone book.

Database structures:
Hierarchical structure: A hierarchical database model is a data model in which the
data are organized into a tree-like structure. The data are stored as records which are
connected to one another through links. ... In order to retrieve data from a hierarchical
database the whole tree needs to be traversed starting from the root node.
Network structure: A network database is a type of database model wherein multiple
member records or files can be linked to multiple owner files and vice versa. The model
can be viewed as an upside-down tree where each member information is the branch
linked to the owner, which is the bottom of the tree.

Relational: The relational model represents the database as a collection of


relations. A relation is nothing but a table of values. Every row in the table
represents a collection of related data values. These rows in the table denote a real-
world entity or relationship.

Object-Oriented Databases
Object-oriented databases (OODB) are databases that represent data in the form of
objects and classes. In object-oriented terminology, an object is a real-world entity, and a
class is a collection of objects. Object-oriented databases follow the fundamental
principles of object-oriented programming (OOP). The combination of relational model
features (concurrency, transaction, and recovery) with object-oriented principles results in
an object-oriented database model.

The object-oriented database model (OODBM) is an alternative implementation to that


of a relational model.

Database Development : Database application development is the process of obtaining


real-world requirements, analyzing requirements, designing the data and functions of the
system, and then implementing the operations in the system.

Data resource management, also known as data administration, deals with computer
science and information systems. Workers in this field help design, control, protect,
store, administer and organize saved data. Normally, this information is stored on
databases with database management systems or software.

What is data resource management in MIS?


Data Resource management may be thought of as a managerial activity that applies
information system and other data management tools to the task of managing an
organization's data resource to meet a company's business needs, and the information
they provide to their shareholders.

You might also like