This work provides an introduction to all aspects of the database process, from analysis and design to programming. It enables the reader to learn how to ascertain system requirements, to design Access relational databases, SQL queries and to produce Visual Basic and associated applications. This work makes the important link between VB programs, databases and database programming. It includes many examples and exercises with solutions to reinforce learning.
Auflage
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Für höhere Schule und Studium
Für Beruf und Forschung
Illustrationen
Maße
Gewicht
ISBN-13
978-0-07-709585-7 (9780077095857)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
Part 1 Introduction: how to develop a database application - what this book contains problem analysis; database design; query design; database programming; Visual Basic and Access; versions of Visual Basic and Access; compatibility between versions of Visual Basic and Access; exercises. Part 2 Problem analysis: the system life cycle; defining objectives; feasibility; analysis; dataflow diagramming; context diagrams; dataflow diagrams; sources and slinks of data; dataflow lines; processes; data stores; process specification; structured English and pseudo-code; business rules; decision tables and rule verification; exercises. Part 3 Database design: introduction; link to dataflow diagramming; entity modelling; entity types and relationships; replacing M - N; relationships with new entity types; replacing relationships involving more than two entity types with a new entity type; parallel relationships; mutually exclusive relationships; unnecessary relationships; relational modelling; selecting an initial set of attributes; terminology; primary keys; foreign keys; normalisation; first normal form; second normal form; third normal form; fourth normal form; fifth normal form; exercises. Part 4 Database schema design in Access: introduction; organising an application; the facilities of Access; creating a database; creating tables; in-built field; integrity checks; keys and indexing; creating relationships; referential integrity; join type; exercises. Part 5 Query design in Access: query by example - the query design Window; SQL with examples; single table queries; joins; subqueries; union queries; exercises. Part 6 Forms and reports in Access: Access form design; form Wizards; custom form design; Access report design; report Wizards; custom form design; Access report design; report Wizards; macros; modules; strengths and weakness of Access for process design; exercises. (Part contents).
