PROCESSING INFORMATION SYSTEMS OVERVIEW
- Defining information system and computing system
- Architecture of computer systems
- Introducing network computer
- Relational Database Management Systems (transactions, processing, languages)
- Relational Model (relations, keys, check contraints)
MODELLING A DATABASE
- Collecting requirements
- Conceptual model: the entity-relationship diagrams
- Logical model
- Data types (data dictionary)
SQL LANGUAGE
- Introducing SQL language (select statement)
IMPLEMENTATION IN MICROSOFT ACCESS
- Database creation
- Implementation of a logical model
- forms and subforms creations
- combobox
- Queries and queries with parameters
- Reports