Save
Busy. Please wait.
Log in with Clever
or
show password
Forgot Password?
Don't have an account?  Sign up 
Sign up using Clever
or
Username is available taken
show password


Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account. Your email address is only used to allow you to reset your password. See our Privacy Policy and Terms of Service.

Already a StudyStack user? Log In

Reset Password
Enter the associated with your account, and we'll email you a link to reset your password.
focusNode
Didn't know it?
click below
 
Knew it?
click below
Don't Know
Remaining cards (0)
Know
0:00
edit
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

  Normal Size     Small Size show me how

WJEC CG3.6

Topic 6: Databases and Distributed Systems

TermDefinition
Foreign key A foreign key is a primary key from one table; appearing in another table; used to form links between tables.
1NF no repeating groups of attributes.
Data warehouse A data warehouse is a large collection of data stored together logically for further processing. Examples: An insurance company might use data warehousing to check claims histories together with other insurance companies’ data to try to detect fraud.
Data mining Data mining is the analysis of a (large) amount of data in a data warehouse. Example: A supermarket might use data from a loyalty card scheme to send information to particular customers with special offers etc.
Primary key A primary key is a field which uniquely identifies a record in a database, for instance in a membership database membership-number might be used to uniquely identify each member.
3NF Third normal form means that data items are dependent on the whole key and nothing except the key (or the key, the whole key and nothing but the key).
Data duplication/redundancy (storing of the same data more than once) is likely to occur if a database is not normalised.
Flat File System? A flat file system may contain a number of single tables with no links between them, whereas a relational database normally contains a number of linked tables (/relations).
Why normalise a DB? data independence; reduces data duplication / redundancy; reduces the danger of inconsistency / improves data integrity; reduces the danger of data being lost during update.
Database administrator A database administrator is the person in a company who is responsible for the structure and management of the database system and the data in it.
Database Management System (security) The DMBS may allow certain users read and/or write access to certain records or fields only.
Why is an index often used by a database management system? An index is used to improve read access times to records, and also to sort the records for viewing.
Distributed database? Databases often contain huge amounts of data. It is often more efficient to store data on a number of different computers (probably in different locations) to maximise performance.
State two advantages of a relational database over a flat file system. Redundancy (data duplication) is reduced (therefore saving space); Risk of inconsistent data is reduced (better integrity of data); Data independence allows different views of the same data.
Created by: mcounsell
Popular Computers sets

 

 



Voices

Use these flashcards to help memorize information. Look at the large card and try to recall what is on the other side. Then click the card to flip it. If you knew the answer, click the green Know box. Otherwise, click the red Don't know box.

When you've placed seven or more cards in the Don't know box, click "retry" to try those cards again.

If you've accidentally put the card in the wrong box, just click on the card to take it out of the box.

You can also use your keyboard to move the cards as follows:

If you are logged in to your account, this website will remember which cards you know and don't know so that they are in the same box the next time you log in.

When you need a break, try one of the other activities listed below the flashcards like Matching, Snowman, or Hungry Bug. Although it may feel like you're playing a game, your brain is still making more connections with the information to help you out.

To see how well you know the information, try the Quiz or Test activity.

Pass complete!
"Know" box contains:
Time elapsed:
Retries:
restart all cards