Get premium membership and access questions with answers, video lessons as well as revision papers.
(i) A primary Key is a key field that is used to uniquely identify each record in a database table to avoid duplication or null values.
(ii) Foreign key is a key that contains values that correspond to values in the primary key of another table and is used to create relationships between the various tables.
maurice.mutuku answered the question on April 11, 2018 at 09:14
- What are the data types used in Ms Access?(Solved)
List and explain examples of data types used in Ms Access.
Date posted: April 11, 2018. Answers (1)
- What is a "data type" as used in databases?(Solved)
Define what a "data type" is as used in databases.
Date posted: April 11, 2018. Answers (1)
- What guidelines should a database designer consider before setting up a good database?(Solved)
Give the main guidelines that a database designer should consider before setting up a good database.
Date posted: April 11, 2018. Answers (1)
- What are the steps needed to open an existing database and entering a new record?(Solved)
Outline the steps needed to open an existing database and to enter a new record.
Date posted: April 11, 2018. Answers (1)
- What is a "Field" in relation to databases?(Solved)
Define a "Field" in relation to databases.
Date posted: April 11, 2018. Answers (1)
- What is a "File" in relation to databases?(Solved)
Define a "File" in relation to databases.
Date posted: April 11, 2018. Answers (1)
- What is a "Record" in relation to databases?(Solved)
Define a "Record" in relation to databases.
Date posted: April 11, 2018. Answers (1)
- What are the major features of a database management software objects acting as a means to manipulation of data contained in the database?(Solved)
Discuss the major features of database management software objects which act as a means to manipulation of data contained in the database.
Date posted: April 11, 2018. Answers (1)
- What is SQL?(Solved)
Define SQL.
Date posted: April 11, 2018. Answers (1)
- What are the main components of a database system?(Solved)
Explain the main components of a database system.
Date posted: April 11, 2018. Answers (1)
- What is the difference between database application and database system?(Solved)
Distinguish between database application and database system.
Date posted: April 11, 2018. Answers (1)
- What are the major functions of DBMS in a computerized information processing?(Solved)
Give the major functions of DBMS in a computerized information processing.
Date posted: April 11, 2018. Answers (1)
- What are the examples of DBMS software?(Solved)
Highlight the examples of DBMS software.
Date posted: April 11, 2018. Answers (1)
- What is "Database Management System" (DBMS)?(Solved)
Define the term "Database Management System" (DBMS)
Date posted: April 11, 2018. Answers (1)
- What are the advantages of modern database systems over paper-based systems?(Solved)
Discuss the advantages modern database systems have over paper-based systems.
Date posted: April 11, 2018. Answers (1)
- In what areas may databases be used in a business enterprise?(Solved)
Highlight areas where databases may be used in a business enterprise.
Date posted: April 11, 2018. Answers (1)
- What is a Database?(Solved)
Define a Database.
Date posted: April 11, 2018. Answers (1)
- What is the procedure for printing a group of worksheets at the same time in Ms Excel?(Solved)
Describe the procedure for printing a group of worksheets at the same time in Ms Excel.
Date posted: April 11, 2018. Answers (1)
- What is "collating copy printing" and how can you control it?(Solved)
Define "collating copy printing" and show how to control it.
Date posted: April 10, 2018. Answers (1)
- What are the types of page orientation?(Solved)
Give the main types of page orientation.
Date posted: April 10, 2018. Answers (1)