Relational Database Management Systems are the main component of modern information storage and retrieval. There are many different computer programs that allow you to create and use Relational Databases, however they all use the same principles of design as a foundation. This test measures skill in theoretical design, rather than the code-based implementation. Tests for Relational Database Design Entry Level and Oracle Designer 2000 are also available. Total Questions 30 Question Types Multiple Choice Competencies Tested Logical DesignPhysical DesignRelational Database Concepts Tasks Tested Relationships DiagramsNormalizationERD- ImplementationERD UseSuper/Sub TypesIndex UseNull Primary KeyArc RelationshipsCascading DeleteQuery performanceIndex FunctionUnique Primary KeyForeign KeyNull Unique KeyPrimary KeyCompound KeyDe-Normalization UseIndex EffectivenessCascading UpdatePhysical DesignDatabase TriggerSQLDatabase ViewsReferential IntegrityDatabase Trigger UseStored ProceduresDomainsJoinsOuter JoinsCartesian Products
