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:
?
