Shared Flashcard Set

Details

COP 4703 EXAM 1 TERMS STUDY GUIDE
Wells
77
Computer Science
Pre-School
03/01/2012
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Computer Science Flashcards

 

 

Cards

Term
Primary Key
 Definition
a column or collection of column of a table that uniquely identifies a given row in that table
Term
QUERY
 Definition
QUESTION REPRESENTED IN A WAY THE DBMS CAN RECOGNIZE AND PROCESS
Term
QUERY BY EXAMPLE
 Definition
VISUAL APPROACH TO WRITING QUERIES
Term
QUERY BY EXAMPLE
 Definition
USER ASKS THEIR QUESTIONS USING AN ONSCREEN GRID
Term
QUERY BY EXAMPLE
 Definition
DATA APPEARS ON THE SCREEN IN THE TABULAR FORM
Term
HOW MANY PANES ARE IN A QUERY WINDOW IN ACCESS
 Definition
2
Term
UPPER PANE
 Definition
CONTAINS A FIELD LIST FOR EACH TABLE YOU WANT TO QUERY
Term
LOWER PANE
 Definition
CONTAINS THE DESIGN GRID
Term
DESIGN GRID
 Definition
WHERE QUERY OUTPUT CAN BE FORMATTTED, SORTED, AND ADD CRITERIA
Term
CRITERIA
 Definition
CONDITIONS THAT DATA MUST SATISFY
Term
CRITERION
 Definition
SINGLE CONDITION THAT DATA MUST SATISFY
Term
AND
 Definition
BOTH CRITERIA MUST BE TRUE FOR THE CONDITION TO BE TRUE
Term
OR
 Definition
EITHER ONE CRITERIA MUST BE TRUE FOR THE CONDITION TO BE TRUE
Term
AGGREGATE FUNCTION
 Definition
COUNT, SUM, AVG, MIN, MAX
Term
COMPOUND CRITERIA
 Definition
AND, OR
Term
SIMPLE CRITERIA
 Definition
NOT, >, < =, - , >=, =<
Term
GROUPING
 Definition
CREATING GROUPS OF RECORDS THAT SHARE SOME COMMON CHARACTERISTIC
Term
SORTING
 Definition
LISTING RECORD IN QUERY RESULTS IN AN ORDERED WAY
Term
SORT KEY
 Definition
FIELD ON WHICH RECORDS ARE SORTED
Term
MAJOR KEY
 Definition
FIRST SORT FIELD, WHEN SORTING RECORDS BY MORE THAN ONE FIELD
Term
MINOR KEY
 Definition
SECOND SORT FIELD, WHEN SORTING RECORDS BY MORE THAN ONE FIELD
Term
MAJOR SORT KEY SORTS KEYS ON THE
 Definition
LEFT SIDE
Term
MINOR SORT KEY SORTS KEYS ON THE
 Definition
RIGHT SIDE
Term
JOIN
 Definition
JOINING TABLES BASED ON MATCHING FIELDS IN CORRESPONDING COLUMNS
Term
JOINING LINE
 Definition
LINE DRAWN BY ACESS BETWEEN MATCHING FIELDS IN THE TWO TABLES
Term
TO JOIN THREE OR MORE TABLES
 Definition
ADD THE FIELD LISTS FOR ALL THE TABLES IN THE JOIN TO UPPER PANE THEN ADD THE FIRLDS TO APPEAR IN QUERY RESULTS TO DESIGN GRID IN THE DESIRED ORDER
Term
UPDATE QUERY
 Definition
A QUERY THAT CHANGES DATA
Term
DELETE QUERY
 Definition
A QUERY THAT PERMANENTLY DELETES ALL RECORDS SATISFYING THE CRITERIA ENTERED IN THE QUERY
Term
MAKE TABLE QUERY
 Definition
A QUERY THAT CREATES A NEW TABLES USING RESULTS OF A QUERY
Term
SELECT
 Definition
TAKES HORIZONTAL SUBSET OF A TABLE THEN SAVES IT AS A NEW TABLE
Term
PROJECT
 Definition
TAKES A VERTICLE SUBSET OF A TABLE THEN SAVES THAT COLUMN AS A NEW TABLE
Term
JOINS
 Definition
ALLOWS EXTRACTION OF DATA FROM MORE THAN ONE TABLE
Term
NATURAL JOIN
 Definition
JOINS RECORDS FROM EACH ORIGINAL TABLE THAT IS COMMON TO BOTH TABLES
Term
OUTER JOIN
 Definition
JOINS RECORDS FROM EACH ORIGINAL TABLE INCLUDING RECORDS NOT COMMON TO BOTH TABLES
Term
UNISON
 Definition
WHEN TWO TABLES ARE JOINED THAT HAVE THE SAME NUMBER OF COLUMNS AND CORRESPONDING COLUMNS WITH THE SAME TYPE OF DATA . HINT OR
Term
INTERSECTION
 Definition
THE ADDITION OF TWO TABLES THAT ARE ADDED TOGETHER WITH SIMILAR HINT AND
Term
DIFFERENCE
 Definition
THE REMOVAL OF THE TWO TABLES THAT HAVE SIMILAR ENTRIES VALUES HINT SUBTRACT
Term
SQL
 Definition
Structured Query Language
Term
CREATE TABLE
 Definition
Create a table by describing its layout
Term
SELECT
 Definition
LISTS FIELDS TO DISPLAY
Term
FROM
 Definition
LISTS TABLE OR TABLES THAT CONTAIN DATA TO DISPLAY IN QUERY RESULTS
Term
WHERE
 Definition
LISTS ANY CONDITIONS TO BE APPLIED TO THE DATA TO RETRIEEVE
Term
COMPOUND CONDITION
 Definition
CONNECTING TWO OR MORE SIMPLE CONDITIONS USING ONE OR BOTH OF THE FOLLOWING OPERATORS: AND & OR
Term
ALL
 Definition
___ OF THE SIMPLE CONDITIONS MUST BE TRUE FOR THE COMPOUND CONDITION TO BE TRUE
Term
ANY
 Definition
____ OF THE SIMPLE CONDITIONS MUST BE TRUE FOR THE COMPOUND CONDITION TO BE TRUE
Term
NOT
 Definition
REVERSES THE TRUTH OR FALSISITY OF THE ORIGINAL CONDITION
Term
BETWEEN
 Definition
VALUE MUST BE BETWEEN THE LISTED NUMBERS
Term
(*)
 Definition
COLLECTION OF CHARACTERS IN ACCESS
Term
(?)
 Definition
ANY INDIVIDUAL SINGLE CHARACTER IN ACESS
Term
(%)
 Definition
ANY COLLECTION OF CHARACTERS IN MYSQL
Term
(_)
 Definition
ANY INDIVIDUAL SINGLE CHARACTER IN MYSQL
Term
ORDER BY
 Definition
SORTING DATA IN SQL
Term
SORT KEY
 Definition
FIELD ON WHICH TO SORT DATA
Term
MAJOR SORT KEY
 Definition
MORE IMPORTANT SORT KEY
Term
MINOR KEY
 Definition
LESS IMPORTANT SORT KEY
Term
SUBQUERY
 Definition
INNER QUERY
Term
GROUP BY
 Definition
INDICATES GROUPING IN SQL
Term
HAVING
 Definition
GROUPS WHAT THE WHERE CLAUSE IS TO ROWS
Term
INTO
 Definition
SAVES THE RESULTS OF A QUERY AS A TABLE, SPECIFIED BEFORE FROM AND WHERE CLAUSES
Term
VIEW
 Definition
APPLICATION PROGRAM’S OR INDIVIDUAL USER’S PICTURE OF THE DATABASE. IMPLEMENTED BEFORE CREATE “CREATE VIEW Housewares AS SELECT…”
Term
INDEX KEY
 Definition
FIELD OR COMBINATION IF FIELDS ON WHICH INDEX IS BUILT
Term
SINGLE FIELD INDEX
 Definition
KEY IS SINGLE, OR ALSO CALLED SINGLE-COLUMN INDEX
Term
MULTIPLE- FIELD INDEX
 Definition
MORE THAN ONE KEY FIELD, ALSO CALLED MULTIPLE COLUMN INDEX
Term
GRANT
 Definition
PROVIDES PRIVLEDGES TO USER
Term
REVOKE
 Definition
REMOVES PRIVLEDGES FROM USER
Term
TO DESIGNATE A PRIMARY KEY IN ACCESS
 Definition
SELECT PRIMARY KEY FIELD IN TABLE VIEW
Term
TO DESIGNATE A PRIMARY KEY IN SQL
 Definition
PRIMARY KEY (….)
Term
FOREIGN KEY
 Definition
FIELD(S) WHOSE VALUE IS REQUIRED TO MATCH THE VALUE OF THE PRIMARY KEY FOR A SECOND TABLE
Term
REFERENTIAL INTEGRITY
 Definition
IF TABLE “A” CONTAINS A FOREIGN KEY THAT MATCHES THE PRIMARY KEY OF TABLE “B”, THE VALYE OF THIS FOREIGN KEY MUST MATCH THE VALUE OF THE PRIMARY KEY FOR SOME ROW IN TABLE “B” OR BE NULL
Term
TO DESIGNATE FOREIN KEY
 Definition
FOREIGN KEY (RepNum) REFERENCES Rep
Term
VALIDATION RULE
 Definition
,UST BE FOLLOWED BY DATA ENTERED
Term
VALIDATION TEXT
 Definition
INFORMS USER OF THE REASON FOR REJECTION OF DATA THAT VIOLOATES THE RULE
Term
ALTER TABLE
 Definition
COMMAND CHANGES TABLE’S STRUCTURE
Term
TO ADD A NEW FIELD TO THE CUSTOMER TABLE
 Definition
ALTER TABLE Customer
Term
CHANGING PROPERTIES OF EXISISTING FIELDS
 Definition
CHANGE CLUMN CustomerName to CHAR(40)
Term
DELETING A FIELD FROM A TABLE
 Definition
ALTER TABLE Part
Term
DROP TABLE COMMAND DELETES A TABLE
 Definition
DROP TABLE SmallCust
Supporting users have an ad free experience!