Databases make data, easy to store, organise and search, Data is organised into a, a table structure, A table consists of, records, A field is part of, a record, A field stores, a single data item, A primary key field, uniquely identifies one record, Linking tables together in a database, creates a relationship, To create a database relationship, there must be, a common field between tables, Relationships can be classified as, ONE to ONE, ONE to MANY or MANY to MANY, Primary key appears in another table it is know as, a foreign key, Data duplication, occurs when the same data is entered more than once, Data redundancy, occurs when there is unnecessary duplication of data in a database, Referential integrity, ensures that records linked to another table cannot be deleted, Data type, is a description of the kind of data held in a field, Field properties/attributes, further define a field in a record, exporting data, is sending data out of an application to another, importing data, is bringing data from one application into another, Data integrity, ensures the accuracy and consistency of data, Captions, allow proper English to be used in user interfaces
0%
Database fundamentals
Share
Share
Share
by
Jbarr2
KS3
Computing
Databases
I-edit ang Content
I-Print kini
Embed
Uban pa
Assignments
Leaderboard
Show more
Show less
Kini nga leaderboard naka-pribado. Pag-klik sa
Share
aron himuon kini nga publiko.
Kini nga leaderboard gi-disable sa tag-iya sa resource.
Kini nga leaderboard gi-disable tungod ang imong mga kapilian lahi ra sa tag-iya sa resource.
I-revert ang mga Kapilian
Ang
Match up
usa ka open-ended nga template. Dili kini makamugna ug mga marka sa leaderboard.
Kinahanglan mag log in
Visual style
Fonts
Subscription required
Mga Option
I-switch ang template
Ipakita tanan
Daghang mga format ang mugawas samtang gidula nimo ang activity.
Open results
Copy link
QR code
Mag-delete
I-restore ang gi-autosave:
?
