Flashcards
Database Design and Development
Cards in this deck (24)
- 1THE PURPOSE FOR SEARCHING AND SORTING DATABASE RECORDS IS...TO ARRANGE INFORMATION IN DIFFERENT WAYS
- 2WHAT IS THE MAIN AND VISUAL DIFFERENCE BETWEEN SEARCH AND SORT PERFORMED ON A DATABASE?SORT WILL ALWAYS DISPLAY ALL RECORDS
SEARCH WILL USUALLY REDUCE THEM - 3IN WHAT WAYS SORT OPERATION ARRANGES DISPLAYED RECORDS?ALPHABETICAL
NUMERICAL
CHRONOLOGICAL
IN ASCENDING OR DESCENDING ORDER - 4WHAT RECORDS WILL BE DISPLAYED WITHIN DATABASE AS A RESULT OF SEARCH OPERATION?ONLY RECORDS THAT CONTAIN DATA FIELDS MATCHING THE CRITERIA.
THE CRITERIA SEARCH FOR DATA FIELD WITHIN RECORD MUST BE TRUE. - 5What is the purpose of setting the second SORT criteria for the same data table?To sort records with identical values only after performing the first sort
- 6What two tables need to have to be linked?Common column
- 7What is the name of common column which is used to link two tables together?Foreign Key Column
- 8What is Foreign Key and its purpose?Primary Key column for one of the two linked tables and one of the column name inside another which acts as a connector between them.
- 9One to many relationship between table is when:Single record in first table can be repeated within one or many records inside second table
- 10To set up relationship between tables in Microsoft Access you need to go to:Database Tools tab
- 11Flat database file is:Database which stores data in one table only
- 12Database with linked tables is called also:Relational database
- 13One of the major issue of flat database file is:Data can be duplicated which can cause errors
- 14What is Database?Structured collection of information which contains records made up of fields
- 15What is Data Table?Collection of related data, It consists of columns and rows.
A table is a set of data elements using a model of vertical columns and horizontal rows - 16What is Database Table Column?Data collection of one and specific type.
Can be in text, number, date format. - 17What are four types of data validation used:Presence Check
Range Check
Restricted Check
Length Check - 18What is the purpose of the Length Check?To SET CERTAIN LIMIT FOR SIZE OF DATA
- 19What is the purpose of the Range Check?SET THE UPPER AND LOWER LIMITS FOR ACCEPTABLE DATA
- 20What is the purpose of the Restricted Check?TO INCLUDE ONLY CERTAIN OPTIONS TO CHOICE FROM EX. DROP DOWN LIST OF ACCEPTED DATA
- 21What is the purpose of the Presence Check?TO CHECK IF DATA EXIST WITHIN FIELD – PROMPT FOR DATA INPUT IF EMPTY
- 22What is the Primary Key Column?A column with data fields that is unique for each record and allows to identify one amongst all.
- 23What is Data Row?Single and structured data item within the table.
- 24WHAT IS THE PURPOSE OF THIS FORMULA? >=DD/MM/YYYY AND <=DD/MM/YYYYTo search and display for records starting
with DATE VALUE AND ending on a date with DATE VALUE
Information
- Description
- A level Computing Flashcards on Database Design and Development , created by ADRIANNA DAR on 12/11/2020.
- Created by
- ADRIANNA DAR
- Views
- 8
- Rating