Techniques For Validation And Testing Of RDBMS Functions Informatics Overload podcast

8:41

In this episode I discuss Unit 3 Outcome 2 Key Knowledge point 5; U3O2 KK05 – criteria to check the integrity of data including timeliness, authenticity, relevance, accuracy

1
Acquiring, manipulating, storing and referencing Data 6:14

6 years ago6:14

6:14

In this episode I discuss Unit 3 Outcome 2 Key Knowledge points 1, 2, 3 and 4; U3O2 KK01 – primary and secondary data sources (digital and non digital) and methods of data acquisition, including observation, interview and querying of resources U3O2 KK02 – suitability of quantitative and qualitative data for manipulation including comparisons (quantitative) and policy formation (qualitative) U3O2 KK03 – data types and data structures relevant to selected software tools U3O2 KK04 – one of the following methods for referencing primary and secondary sources: Harvard, American Psychological Association (latest edition), Chicago, Institute of Electrical and Electronics Engineers (IEEE)…

1
Reasons for acquiring and supplying data 2:48

6 years ago2:48

2:48

In this episode I discuss Unit 3 Outcome 1 Key Knowledge points 14 and 15 U3O1 KK 14 - reasons why organisations acquire data using online facilities, including 24-hour customer access, improved efficiencies through direct data entry by customers, improvements in effectiveness, and access to global markets, marketing opportunities and ongoing services U3O1 KK 15 - reasons why users supply data for online transactions, including convenience, variety of choice, reducing costs…

1
Techniques for validation and testing of RDBMS functions 7:14

6 years ago7:14

7:14

In this episode I discuss Unit 3 Outcome 1 Key Knowledge points 11, 12, and 13; U3O1 KK 11 – functions and techniques within an RDBMS to efficiently and effectively validate and manipulate data U3O1 KK 12 - functions and techniques to retrieve required information through searching, sorting, filtering and querying data sets U3O1 KK 13 - methods and techniques for testing that solutions perform as intended…

1
Design Principles and Tools for RDBMS' 7:07

6 years ago7:07

7:07

In this episode I discuss Unit 3 Outcome 1 Key Knowledge points 8, 9, and 10; U3O1 KK08 – design tools for describing data types and the value of entity relationship (ER) diagrams for representing the structure of an RDBMS U3O1 KK09 – design principles that influence the functionality and appearance of solutions (useability - including robustness, flexibility and ease of use-, accessibility -including navigation and error tolerance- Design principles related to appearance are -alignment, repetition,contrast, space, balance) U3O1 KK 10 – design tools for representing solutions…

1
Flat file VS RDBMS 5:26

6 years ago5:26

5:26

In this episode I discuss Unit 3 Outcome 1 Key Knowledge points 5 AND 7, purposes and structure of an RDBMS, including comparison with flat file databases, AND a methodology for creating an RDBMS structure: identifying entities, defining tables and fields to represent entities; defining relationships by identifying primary key and foreign key fields; defining data types and field sizes; normalisation to third level.…

1
Naming Conventions 1:39

6 years ago1:39

1:39

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 6, naming conventions to support efficient use and maintenance of an RDBMS

1
Controls for protecting data 2:06

6 years ago2:06

2:06

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 4, physical and software security controls used by organisations to protect their data

1
Characteristics of data types 2:06

6 years ago2:06

2:06

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 3, Characteristics of data types.

1
Efficient and Effective data collection 1:49

6 years ago1:49

1:49

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 2, Techniques for efficient and effective data collection

1
Acquiring Data 3:16

6 years ago3:16

3:16

In this episode I discuss Unit 3 Outcome 1 Key Knowledge point 1, Techniques used by organisations to acquire data through their interactive online solutions and reasons for their choice.

1
Introduction 0:15

6 years ago0:15