File, Collection of information on a specific topic, Record, All information on a person or thing, Field, A single piece of data, Entity, Person/thing/object we store information about, Attribute, Data used to describe each entity, Text, Phone numbers are stored as this, Number, 720, 35.6, Date, 25/12/1990, Time, 06:07, Boolean, Yes/No, Primary Key, Uniquely identifies a record, Foreign Key, Links two tables together, One-to-Many, The only cardinality at N5, ER Diagram, Used to design databases, Data dictionary, Defines the structure of the database, Validation, Rules to control the type of data entered, Presence Check, Ensures fields are not left blank, Restricted Choice, Presents the user with a list of options to choose from, Length Check, Specify the maximum length of the field, Range Check, Specify the range of values a field can hold
0%
Database Lesson 4 Starter
Share
Share
by
Mrwaltonshawlands
Edit Content
Print
Embed
More
Assignments
Leaderboard
Show more
Show less
This leaderboard is currently private. Click
Share
to make it public.
This leaderboard has been disabled by the resource owner.
This leaderboard is disabled as your options are different to the resource owner.
Revert Options
Crossword
is an open-ended template. It does not generate scores for a leaderboard.
Log in required
Visual style
Fonts
Subscription required
Options
Switch template
Show all
Open results
Copy link
QR code
Delete
Continue editing:
?
