Adobe PDF (1.7 MB)
Title Details:
Development and use of a relational Database
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
Keywords:
Data Bases
Description:
Abstract:
Creation of a Database in MS-Access. Starting from the initial design, the implementation of tables and definition of relationships are presented, followed by the process for creating simple and complex queries, forms and reports. An example of creating a small-scale database is included, starting from the requirements analysis and the ER-diagram, and proceeding step by step in its transformation into a real database. The environment provided by Access is presented for creating tables, queries, forms and reports, and figures are given which guide the reader to the implementation of the example in practice.
Table of Contents:
1. The implementation and use of a Database
1.1. The role of the Database
1.2. The usefulness of a Database in a few words
1.3. The environment of MS-Access 2007

2. Creation, opening and saving a Database in Access

3. Creation of Tables
3.1. Initial design
3.2. Creation of Tables
3.3. Inserting data

4. Creation of Queries
4.1. Usefulness and types of queries
4.2. Creation of a selection query
4.2.1. Simple queries with one table
4.2.2. Queries that combine data from more than one tables or queries
4.2.3. Queries that calculate aggregated data
4.2.4. Other types of queries

5. Creation of Forms and Reports
5.1. Forms
5.2. Reports

6. Bibliography/References
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/1165
Bibliographic Reference: Stalidis, G. (2015). Development and use of a relational Database [Chapter]. In Stalidis, G., & Kardaras, D. 2015. Data Management and Business Intelligence [Undergraduate textbook]. Kallipos, Open Academic Editions. chapter 4. http://hdl.handle.net/11419/1165
Language: Greek
Is Part of: Data Management and Business Intelligence
Publication Origin: Kallipos, Open Academic Editions