• thinkigcse.com

What is a table?

A single store of related information. A table consists of records, and each record is made up of a number of fields.

What is a record?

A table consists of records, and each record is made up of a number of fields. A record contains all the information about a single 'member' of a table. In a students table, each student's details (name, date of birth, contact details, and so on) will be contained in its own record.

What is a field?

Fields describe a single aspect of each member of a table. A student record, for instance, might contains a last name field, a first name field, a date of birth field and so on.

Let’s take the example of Student’s database in a School

What is a Key Field?

Keys are crucial to a table structure for many reasons, some of which are identified below:

They ensure that each record in a table is precisely identified.

They help establish and enforce various types of integrity.

They serve to establish table relationships.

Primary key will uniquely identify each record. It may or may not provide information about the record it identifies. It must not be Null-able, that is if it exists in a record it cannot have the value Null. It must be unique. It cannot be changed.

database-table

Exciting News!

IMPORTANT MESSAGE

Quizzes and worksheets on this website have been developed in Flash format. Flash is no more supported by browsers. Therefore, you might see blank pages on some instances. Install Flash player plugin for Chrome from Chrome Web Store. Click here 

Similarly, for other web browsers you will have to activate the relevant flash player plugins.

JOIN OUR ONLINE COURSES

New Youtube Channel - ThinkIGCSE

Hi Everyone, I have launched a new YouTube channel with more than a 100 videos on  Economics and Business Studies, tailored specifically for IGCSE and A Level and IBDP students.

Subscribe now and join us on this learning journey: @thinkIGCSE

Save
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Read more
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Our website uses Google Analytics to understand how you interact with our site and improve your browsing experience. These cookies collect information in an anonymous form, including the number of visitors to the site, where visitors have come from, and the pages they visited. The data helps us analyze trends and user behavior to enhance our website's functionality and content.
Accept
Decline
Marketing
Set of techniques which have for object the commercial strategy and in particular the market study.
Marketing
Our website uses Google marketing cookies to deliver personalized ads and measure the effectiveness of our advertising campaigns. These cookies track your online activity to help us show you relevant ads on Google services and partner websites.
Accept
Decline