ABSTRACT
Hands-on Database Design Tutorials are designed to enhance the understanding of Relational and Dimensional Database Systems. Since the mid-1980s Relational Database Management Systems (RDMS) from Major Database Software Vendors such as IBM, Oracle, Sybase, and others have been the predominant Database System used in Human Capital Management Systems and nearly all other Business Application Databases. In Two-Dimensional RDMS Table Structures, Rows represent Records, and Columns represent Data Fields. In RDMSs, Database Designers for Transactional Databases strive to achieve full normalization at the third Level. Use of Primary Keys and implementation of Third Normal Form eliminate duplication of records and repeating values in non-Primary Key Columns except for Foreign Keys needed for linkage to reference or child Tables. Data Modeling of RDMSs was covered, including Normalization using Third Normal Form Rules, and Referential Integrity enforced by RDMS software using Primary and Foreign Key Field Relationships discussed in concept and demonstrated through Hands-on Database Design Tutorials.
