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. https://hdl.handle.net/11419/1165 |
| Language: |
Greek |
| Is Part of: |
Data Management and Business Intelligence |
| Number of pages |
31 |
| Publication Origin: |
Kallipos, Open Academic Editions |