what is a database? - an organised store of related information, what is a table? - a collection of records on a particular subject, what is a record? - a collection of fields, what are the different types of data stored in a database? - text, numbers,date,time,boolean, what is an entity relationship diagram? - used to plan the structure and links required by the database, what is a primary key? - a field used to uniquely identify each record in a table, what is a foreign key? - a field in one table which acts as a primary key in another table, data dictionary - used to plan the entities and their attributes including keys, types, size, validations, one to many relationship - exists when a record in one table can match with several records in the related table, referential integrity - a foreign key value must already exist as a primary key in the related table, attribute types - text, number, date, boolean, time, object, relational database - a database with two or more tables, flat file database - a database with only one table, sorting - to arrange records in order of the values in a field or fields, ascending - place records in low to high order, descending - places records in high to low order, 28/06/2022 - date, 14:00 - time, TRUE/FALSE - boolean, validation checks - applies rules to check that data entered is sensible, range check - checks data entered is within upper and/or lower limits, restricted choice - data entered must be from a limited list, presence check - forces the user to enter data in a particular field, length check - data entered must contain a certain number of characters, SQL stands for ... - structured query language, SQL query order... - select, From, Where, Order by, equi-joins are... - used in an SQL query where you are selecting data from 2 linked tables,

N5 DDD TERMS

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?