Database Systems
Candidates should be able to:
Distributed databases
- Explain the terms data consistency, data redundancy, data integrity and data independence.
- Explain the terms relational database organisation and data normalisation.
- Restructure data into normalised form.
- Describe the use of primary keys, foreign keys and links.
- Describe the advantages of different users having different views of data.
- Database security. Recognise that the individual user of a database may be prevented from accessing particular elements of the information.
- Data warehousing and data mining.
- The purpose of a database management system (DBMS), query languages and data dictionaries.
Distributed databases
- Candidates should be able to define a distributed database and discuss their advantages and disadvantages with reference to suitable examples.
I'm having trouble uploading files - until tomorrow focus on Past Paper questions to cover the missing theory. Sorry, Mr Lynch.
databases_1.pptx |