Cambridge International AS and A Level IT Coursebook with CD-ROM
The first year of Cambridge Assessment International Examination (CAIE). These series of Notes are comprehensive, Detailed, Summarized and Easy to Understand. Students finds it very helpful as they prepare for examination.
A lot of resources and research have been put together to develop this summ...
Chapter 9: database and file concepts (a level it 9626)
August 20, 2020
142
2020/2021
Summary
Subjects
accuracy of data
query selection
data dictionary
normalisation
database
file concepts
a level it 9626
normalisation to third normal form
database and file concepts
Connected book
Book Title:
Author(s):
Edition:
ISBN:
Edition:
More summaries for
Notes for Information Technology (9626) Cambridge International AS and A. Chapter1 "Data, Information, Knowledge and Processing"
Question & Answers organized by chapter for Information Technology IG, A level(9626) P1 Monitoring and Control
Class notes Information Technology (9626) Cambridge International AS and A Level IT Coursebook with CD-ROM, ISBN: 9781107577244
All for this textbook (20)
Written for
CIE
CAIE A Level IT 9626 (CIEIT9626)
All documents for this subject (1)
3
reviews
By: rhasselmhasho • 3 year ago
By: sameerseth • 3 year ago
By: prithvimadhu • 4 year ago
Seller
Follow
goziewilfredonuzurike
Reviews received
Content preview
Objectives
By the end of this chapter,
you will be able to:
m create a database with
tables, queries, forms,
reports and relationships
assign appropriate data
types to fields and set
primary, compound and
foreign keys
understand relationships,
Database and File Concep
entity relationship
diagrams and referential
integrity
evaluate the difference
between a flat file, and
relational and hierarchical
databases
A LEVEL ICT 20-Aug-20 MR
,Objectives
Create a database
By the end of this chapter, Key Terms
you will be able to:
m create a database with
tables, queries, forms, • Database: structured method of storing data
reports and relationships
assign appropriate data • Table: a set of similar data (about people, places, o
types to fields and set or events)
primary, compound and
foreign keys • Record: Within a table are rows known as records.
understand relationships,
entity relationship
common word for entity
diagrams and referential
integrity
• Entity: Each record is an entity which is a set of da
evaluate the difference one single thing (person, place, object or event).
between a flat file, and
relational and hierarchical • Each entity has categories of information. These
databases categories are known as attributes or fields.
• Attribute: a category of information within an enti
A LEVEL ICT 20-Aug-20 MR
,Objectives
Create a database
By the end of this chapter, Key Terms
you will be able to:
m create a database with
tables, queries, forms, • Field: a common word for attribute
reports and relationships
assign appropriate data • Primary key: a field that contains the unique ident
types to fields and set
primary, compound and a record
foreign keys
understand relationships, • One of the fields will be known as the primary key.
entity relationship primary key contains a unique value for each recor
diagrams and referential
integrity means that each value can only exist once in that t
evaluate the difference it is possible to identify each record using the prim
between a flat file, and
relational and hierarchical
databases
• Database management system: software used to m
a database
A LEVEL ICT 20-Aug-20 MR
, Objectives
File Formats
By the end of this chapter, Note:
you will be able to:
m create a database with • Generic file formats enable data to be transferred
tables, queries, forms,
reports and relationships between software.
assign appropriate data
types to fields and set
primary, compound and
foreign keys
understand relationships,
entity relationship
* They do not include any formatting and only include ess
diagrams and referential data.
integrity
evaluate the difference
• .txt and .csv are generic file formats
between a flat file, and
relational and hierarchical
databases
A LEVEL ICT 20-Aug-20 MR
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller goziewilfredonuzurike. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.48. You're not tied to anything after your purchase.
