Get your relationship correct and achieved distinction relationship is crucial part in Unit 2.
171 views 2 purchases
Course
Unit 2 - Creating Systems to Manage Information
Institution
PEARSON (PEARSON)
Ace Unit 2 with these top-notch notes. Covering all key concepts and topics, these notes are essential for understanding and excelling in the material. Perfect for students looking for an edge in their studies. Grab your copy now
database unit2creating and manage information btec it information technology
database unit 2 creating and manage information information technology
Written for
BTEC
PEARSON (PEARSON)
Information Technology 2016/2017 NQF
Unit 2 - Creating Systems to Manage Information
All documents for this subject (73)
Seller
Follow
jaspreetsingh1
Content preview
UNIT 2 NOTES
DATA BASE = COLLECTION RELATED DATA STORED IN ORGANISE OR STRUCTURED AND LOGICAL
MANNER.
ORGANISE, STRUCTURED MEAN TABLE THAT CONTAIN INFORMATION
RECORD A record is all the data or information about one person or one thing.
FIELD= a 'field' is one piece of data or information about a person or thing. Field is a unit of data
about something or someone.
Field name= field name is a first name or last name.
Flat file= when we store all the information into one table.
Field length = Most databases will have a default field length set up; in this case it is 50. This means
that each text field can store up to 50 letters, numbers, or symbols.
Primary key= is a unique field that is used to identify record. We can’t repeat in primary key for e.g.,
400, 400 NO we can’t do that
Foreign key: A foreign key is used to link tables together and create a relationship. It is a field in one
table that is linked to the primary key in another table. we can repeat in foreign key for eg 400, 400
YES
In the database above there are three tables:
Artists
Recordings
Genre
The primary key in the Artists table is Artist ID
The primary key in the Genre table is Genre ID
These primary keys link to identically named fields in the Recordings table. Each of those identically
named fields are known as a 'foreign key'.
Referential integrity
Every foreign key value has a matching value in the corresponding primary key. Referential integrity
to ensure the data is accurate or trusted. Because if there is an error it could create a problem.
, Referential integrity uses these to ensure that there are no orphan records i.e., it prevents you from
deleting related records.
Referential integrity can also alert you if you try to delete a record which is related to another one.
It can also be used to cascade changes made to the database.
Compound ley=A compound / composite primary key combines more than one field to
make a unique value.
Example 1
Sometimes, a single field is not enough to uniquely identify a record.
Consider a pack of cards. There are four suits, hearts, diamonds, clubs and spades. A single
primary key would not uniquely identify a particular card based just upon the suit.
There are also thirteen values from the Ace right through to the King. Again, this would not
be sufficient to uniquely identify a card.
But, if you made a primary key out of the suit and the value, then every card in the pack
could be uniquely identified.
Example 2
A student can only be in one place at a time.
Combining the student's name, date and period gives a unique value for each record.
The three fields: student, date and period make up the compound or composite primary key
in this table.
Advantages of flat file
1. All records are stored in one place.
2. Easy to understand and configure using various standard office applications.
3. It is an excellent option for small databases.
4. It requires less hardware and software components.
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 jaspreetsingh1. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $6.91. You're not tied to anything after your purchase.
