Keywords Final - Database Intro data validation setting down options for the fields so that when we are entering data into those fields we can be sure

Keywords Final - Database Intro data validation setting...

This preview shows page 1 - 2 out of 4 pages.

Database Introdata validationsetting down options for the fields so that when we are entering data into those fields, we can be sure that it is the type of data that we want. We have this check in place as it is easier to catch and correct dataerrors when we are inputting data rather than to find the errors and correct them later.databasea collection of related data, where the data consists of information on a specific topicfield (aka column)a basic unit of data entry in a recordforeign keyfor relational tables; the field in table A that matches the unique key of table Bone-to-many/many-to-one relationshipone-to-many: each row in the related table can be related to many rows in the relating table (the 'one' is usually the primary key while the 'many' is the foreign key)many-to-one: the other way around...primary keyfor relational tables; uniquely identifies each record in a tableportalfor relational databases, a layout object in one table where you place one or more realted fields to display in the rows the data from one or more related recordsrecord (aka row)one set of fields in a database table; each record contains data about a single activity, individual, etc.
Background image
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture