Validation - Used to check that the data entered for an attribute is what is expected, Presence check - Checks that the attribute is not empty, Length check - A validation rule that makes sure the minimum and/or maximum number of characters have been entered for attributes with a text data type, Restricted choice - A validation rule that limits the values for an attribute to a selection of predefined options. Ensures that data integrity is maintained, Range check - A validation rule that ensures data entered is between two values, Data dictionary - The detailed design for one or more entities, and defines the structure of the database. Contains meta data, INSERT INTO - Used to add new record into the database, EQUI-JOIN - example: WHERE Owner.OwnerID = Pet.OwnerID, Input - What the user will enter into the system, Process - What the program performs, Output - What the program displays back to the user, Flowchart - A graphical design notation, Concatenation - The joining of two or more Strings, AND - A logical operator. All conditions must be true, OR - A logical operator. At least one condition must be true, Complex condition - A conditional statement that contains more than one condition. Uses logical operators, Fixed loop - A loop that runs a fixed number of times, Conditional loop - A loop that will run until a condition is met, Length - example: len("Hello"), Syntax error - An error that may or may not cause the program to crash. Usually caused by typing or spelling mistakes, Logic error - An error that will not cause the program to crash, but will produce unexpected results, Execution error - An error that will cause the program to crash, Normal - Test data within acceptable range, Extreme - Test data on the boundary of the acceptable range, Exceptional - Test data out-with the acceptable range, Software specification - A legally binding document, Integer - A whole number, Real - A decimal number, Pre-defined functions - Small tasks that are often carried out by programmers, usually repeated across programs, that have been made as efficient as possible, Pseudocode - A textual design notation,

SDD & DDD Key Terms

by
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?