Adobe PDF (771.29 kB)
Title Details:
The relational Database model
Authors: Stalidis, Georgios
Reviewer: Diamantaras, Konstantinos
Subject: MATHEMATICS AND COMPUTER SCIENCE > COMPUTER SCIENCE > INFORMATION MANAGEMENT
MATHEMATICS AND COMPUTER SCIENCE > COMPUTER SCIENCE > INFORMATION MANAGEMENT > DATABASE SYSTEMS
MATHEMATICS AND COMPUTER SCIENCE > COMPUTER SCIENCE > INFORMATION MANAGEMENT > DATA MODELING
MATHEMATICS AND COMPUTER SCIENCE > COMPUTER SCIENCE > INFORMATION MANAGEMENT > RELATIONAL DATABASES
Keywords:
Data Bases
Relational Model
Entity-relationship Diagram
Tables
Data Redundancy
Description:
Abstract:
This chapter focuses on the basic concepts of the Relational Model, which is the most common and widely used data management model. The Relational Model is based on organizing data in tables (or relations) which are linked with each other through common attributes. The purpose of the chapter is that the reader understands the philosophy of organizing data and the basic elements of the model, such as the tables, relationships and keys. The Entity-Relationship Diagram is also presented as a tool for capturing the informational needs of a data base, as well as the step-by-step process of designing a data base. Reference is also made to issues of normalization, data redundancy and integrity.
Table of Contents:
1. Introduction to data modeling
2. The basic concepts of the relational data model
2.1. What is the relational model
2.2. The main elements of the model
2.2.1. Entity
2.2.2. Attribute
2.2.3. Table
2.2.4. Table relationships
3. Entity-Relationship Diagram
3.1. Introduction to the Entity-Relationship Diagram
3.2. Identification of entities
3.3. Identification of relationships
4. Designing the tables of a Data Base
5. Restrictions and principles for avoiding problems
5.1. Data redundancy
5.2. Data integrity
5.3. Table normalization
Graphic Editors: Triantafillou, Sotirios
Type: Chapter
Creation Date: 2015
Item Details:
License: http://creativecommons.org/licenses/by-nc-nd/3.0/gr
Handle http://hdl.handle.net/11419/1164
Bibliographic Reference: Stalidis, G. (2015). The relational Database model [Chapter]. In Stalidis, G., & Kardaras, D. 2015. Data Management and Business Intelligence [Undergraduate textbook]. Kallipos, Open Academic Editions. chapter 3. http://hdl.handle.net/11419/1164
Language: Greek
Is Part of: Data Management and Business Intelligence
Publication Origin: Kallipos, Open Academic Editions