1) DEFINITION OF TABLE a) A collection of related records that identify a category of data, such as students, lecturers or academic b) Several tools that allow users and program to retrieve and maintain data in a database. c) A window on the screen that provides areas for entering or modifying data in a database. d) Allows viewing data one record at a time. 2) Refer to the employee table : How many fields are there ?  a) 6 b) 7 c) 4 d) 5 3) FUNCTION OF TABLE a) Can specify the fields to be displayed b) To arrange data in rows and columns c) Allows viewing data one record at a time d) A request for specific data from the database (retrieve data) 4) DEFINITION OF FORM a) The basic buildinv blocks of all models are entities,attributes and relationships b) groups of related fields c) consists of a group of related tables d) A window on the screen that provides areas for entering or modifying data in a database 5) What is the example of form ?  a) b) 6) FUNCTION OF FORM a) Specifies which records should be retrieved by specifying criteria b) Allows viewing data one record at a time  c) To describe the characteristics of data d) To display or print the data in the database 7) DEFINITION OF REPORT a) A request for specific data from the database b) A report generator allow users to design a report on the screen,retrieve data into the report design and then display or print the report c) Store data that is not manipulated arithmetically d) File/table made up of related records 8) FUNCTION OF REPORT a) To display or print the data in the database b) To arrange data in rows and columns c) Can specify the fields to be displayed d) To add/insert,retrieve and maintaining,viewing and printing records in a database 9) What is the example of report ?  a) b) 10) DEFINITION OF QUERY a) Consists of a group of related tables b) Ensures the consistency of data c) A window on the screen that provides areas for entering or modifying data in a database d) A request for specific data from the database (retrieved data) 11) FUNCTION OF QUERY a) To display or print the data in the database b) Can specify the fields to be displayed c) To describes the characteristics of data in a database d) Backup and recovery

DATABASE OBJECT

Afdrukken
Embedden

Scorebord

Visuele stijl

Opties

Template wisselen

Automatisch opgeslagen activiteit "" herstellen?