IML PRELIMS

0.0(0)
studied byStudied by 0 people
linked notesView linked note
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
Card Sorting

1/49

encourage image

There's no tags or description

Looks like no tags are added yet.

Study Analytics
Name
Mastery
Learn
Test
Matching
Spaced

No study sessions yet.

50 Terms

1
New cards
Data
raw facts
2
New cards
Data
building blocks of information
3
New cards
Information
Not raw facts
4
New cards
Information
Processed data
5
New cards
Information
used to reveal the meaning of data
6
New cards
Good decision making
High chance to succeed
7
New cards
Database
Data that resides in the base
8
New cards
End User Data, Meta Data
two things inside the database
9
New cards
Meta data
data about data
10
New cards
DMS
Database Management System
11
New cards
Database Management System
used to communicate to data
12
New cards
Database Management System
used to manage data
13
New cards
Database Management System
to restrict some data
14
New cards
Single User
1 at a time, Desktop Database
15
New cards
Multi User
2 or more, Workgroup, Enterprise
16
New cards
Data Location
Centralized or Distributed
17
New cards
Centralized
placed in a single unit
18
New cards
Distributed
supports data across several units
19
New cards
Operational Database
day to day transaction
20
New cards
Data Warehouse
where data lives
21
New cards
Extensive Markup Language
XML meaning
22
New cards
Extensive Markup Language
used for manipulation index form
23
New cards
Database Design
Many components
24
New cards
Requirements Gathering
need to meet requirement
25
New cards
Conceptual Design
ERD
26
New cards
Logical Design
increment
27
New cards
Physical Design
all is applied to DMS
28
New cards
Normalization
organized. avoids redundancy
29
New cards
Inducing
used index to have faster data retrieval
30
New cards
Structured Query Language
meaning of SQL
31
New cards
SQL
Computer language aimed to store, manipulate, and query data stored in relational databases.
32
New cards
1974
SQL first appeared in this year
33
New cards
SQL statements
Most of the actions you need to perform on a database are done with _____________
34
New cards
SQL statements
consist of keywords that are easy to understand.
35
New cards
DATA DEFINITION LANGUAGE
DDL meaning
36
New cards
DDL
It consists of SQL commands that can be used to define the database schema.
37
New cards
DDL
It simply deals with descriptions of the database schema and is used to create and modify the structure of database objects in the database.
38
New cards
CREATE
Create database or its objects (table, index, function, views, store, procedure, and triggers)
39
New cards
DROP
Deletes objects from the database
40
New cards
ALTER
Alter the structure of the database
41
New cards
TRUNCATE
Remove all records from a table, including all spaces allocated for the records are removed
42
New cards
COMMENT
Add comments to the data dictionary
43
New cards
RENAME
Rename an object existing in the database
44
New cards
DATA MANIPULATION LANGUAGE
DML meaning
45
New cards
SQL commands that deal with the manipulation of data present in the database belong to DML or Data Manipulation Language and this includes most of the
46
New cards
SQL statements.
47
New cards
SELECT
It is used to retrieve data from the database
48
New cards
INSERT
Insert data into a table
49
New cards
UPDATE
Update existing data within a table
50
New cards
DELETE
Delete records from a database table