RELATIONAL DATABASES

RELATIONAL DATABASES
DATABASE
DATABASE USER AND DESIGNERS
What Is a Database
Advantage of Database
Different users of the database information are at an external level of the database. These users have logical views of the data.
Designers of a database need to understand user’s needs and the conceptual level of the entire database as well as the physical view.
A set interrelated, centrally coordinate data files that are stored with as litle data redundancy
Data is integrated
Data sharing
Minimize data redundancy and inconsistencies
A database consolidates records previously stored in separate files into a common pool and serves a variety of users and data processing applications
SCEMA
Data is independent of the programs that use the data
Data is easily accessed for reporting and cross-functional analysis
A schema is a description of the data elements in a database, the relationships among them, and the logical model used to organize and describe the data
The conceptual-level schema
The external-level schema
The internal-level schema
the organization-wide view of the entire database, lists all data elements and the relationships among them.
an individual user’s view of portions of a database
a low-level view of the database, describes how the data are stored and accessed, including record layouts, definitions, addresses, and indexes.
DATABASE DESIGN
Sub Topic
To design a database, you need to have a conceptual view of the entire database. The conceptual view illustrates the different files and relationships between the files
DBMS LANGUAGE
Data Definition Language (DDL)
Data Manipulation Language (DML)
Data Query Language (DQL)
Builds the data dictionary
Creates the database
Describes logical views for each user
Specifies record or field security constraints
Changes the content in the database
Enables users to retrieve, sort, and display specific data from the database
Sub Topic
RELATIONAL DATABASE
Represents the conceptual and external schema as if that “data view” were truly stored in one table
TABLE
Each row called a tuple, contains data about a specific item in a database table. This is equivalent to a record
Each column contains data about an attribute of of an entity. This is equivalent to a field
QUERIES
Users may want specific information found in a relational database and not have to sort through all the files to get that information. So they query (ask a question) the data.
CLARISHA RIEZKY AMALIA (08)
4-44 / 1302190556
34