Differentiate between a foreign key and primary in a relational database.(Answered) Mention two advantages of entering data into a database using a form.(Answered) Define the following terms as used in database:
a)Record
b)File
c)Database(Answered) State one function of each of these objects in a database.
a)Table
b)Query
c)Forms
d)Reports(Answered) List three types of relationships that can be used to link tables in a database.(Answered) Define the term database management system (DBMS).(Answered) List three database management system objects.(Answered) Explain these database models:
a)Relational
b)Hierarchical(Answered) Distinguish between relational database and flat file model.(Answered) Define the term dynaset as used in database.(Answered) List four features of database software.(Answered) Differentiate between database and database management software.(Answered) Explain these database models:
a)Network model
b)Flat file(Answered) State one disadvantages of flat file database model.(Answered) Give three functions of a database management system.(Answered) State three ways in which a primary key field can be used in a database.(Answered) Define the term normalisation as used in a database.(Answered) Differentiate between an index and a primary key.(Answered) Mention three objectives of normalisation.(Answered) Differentiate between a report and a form.(Answered) List two types of form layout available in a database form wizard dialog box.(Answered) List any six general field properties that can be set on a field in a table.(Answered) Name any two examples of a database package.(Answered) Differentiate between the term entity and attribute in a database.(Answered) State two qualities of a primary key field.(Answered) A form two student wishes to create a field named ADM. No in a table. This field will be used to store admission numbers of students in a class. Outline the steps to follow to achieve this.(Answered) Define the term control as used in database forms.(Answered) Explain three categories of database controls.(Answered) State three disadvantages of traditional file management system over electronic file management system.(Answered) Name four types of Action Queries.(Answered) Give the function of each of the following queries.
-Make table query
-Delete query
-Append query
-Update query;(Answered) Differentiate between an action query and a select query.(Answered) Give three ways of opening Ms-Access program.(Answered) Differentiate between single and double types of integer field size as used in database.(Answered) Expand the term OLE objects as used in database.(Answered) Give the function of Object Linking and Embedding (OLE) object data type.(Answered) State two ways of enforcing referential integrity in a database.(Answered) List two properties of a primary key.(Answered) State three views in a Microsoft database window.(Answered) Name and explain 3 database models(Answered) Explain importance of using DBMS in storage of data in an organization(Answered) Write short note on;
-Database
-Database maintenance
-Databank(Answered) State the components of database hierarchy.(Answered) State two classes of database software(Answered) Give four widely used DBMS today(Answered) State 5 functions of Database Management System(Answered) Describe functions of the following tools found in DBMS
-Data definition language
-Data manipulation language(Answered) Define the following terms:
-Database
-Database management system
-Relational database
-Hierarchical database
-Network database(Answered)