ISDD Unit Flashcards
What are the problems with a flat-file database?
> Can cause unnecessary duplication
It’s time consuming for the data operator
to finish
What is a primary key?
A primary key is a field in a table that contains a piece of data that is unique for every record
What is a surrogate key?
A surrogate key is a field in a table which has been created by the system to ensure that a unique field exists for every record - a surrogate key is used instead of a primary key if no existing field is suitable.
What is a compound key?
A compound key is a primary key made up of two or more attributes to identify each record, row or instance.
What is a foreign key?
A foreign key is a field in a table that is the primary key of another table.
What are the benefits of using CSS?
> Saves time by reusing code
Find errors quicker
More organised
Loads faster - for an entire website, all you need is one CSS file to be loaded.
What are the three ways in which you can apply CSS to a webpage?
> Inside a HTML tag
Add a style tag to the head section
Create a style sheet and add a link to the head
What is metadata?
Metadata is data about data. For example, the file size and author of a sound file are examples of metadata. It is found in the head section of a webpage.
What is a static webpage?
A static webpage is a webpage that does not change every time it is loaded, or if the user clicks on a button.
What is a dynamic webpage?
A dynamic webpage is a webpage that displays different content each time it is viewed.
What is client-side validation?
Client-side validation is when the information that the user enters is checked by the user’s browser, possibly using a scripting language like JavaScript.
What is server-side validation?
Server-side validation is when all the information is checked and verified by the server, not on the user’s computer.
What is a database-driven website?
A database driven website is one that pulls information from a database each time it is loaded.
