LE2 Flashcards
A worldwide collection of networks
that links millions of businesses, government
agencies, educational institutions, and individuals
Internet
The Internet originated as _______ in September
1969
ARPANET
Two main goals of ARPANET
Allow scientists to share information and function even when the network is disabled
What year did the ARPANET become the internet?
1986
When did the ARPANET become functional?
1969
When did the internet2 founded?
1996
A business that provides individuals
and organizations access to the Internet free or for a fee
Access provider
What does ISP, OSP, and WISP mean?
Internet service provider, online services provider, and wireless isp
A number that uniquely identifies each
computer or device connected to the Internet
IP address
It is the text version of an IP address
Domain name
What do you call the “.com”, “.net”, “.edu”, and etc.
TLD or top level domain
It translates the domain name into its
associated IP address
DNS server
Give some examples of generic TLD
biz, edu, com, net, org, gov, edu, aero, mil, travel
It consists of a
worldwide collection of electronic documents
World Wide Web or Web
It is a collection of related Web pages
and associated items
Web site
It is a computer that delivers
requested Web pages to your computer
Web Server
It refers to Web sites that provide a means
for users to interact
Web 2.0
It allows users to access Web pages and Web 2.0 programs
Web browser or browser
It is the first page that a Web site displays
Home page
____ is the process of receiving information
Downloading
A Web page has a unique address called a _____
URL or web address
It allows you to open and view multiple
Web pages in a single Web browser window
Tabbed browsing
What are the two types of search tools?
Search engine and subject directory
A search engine is helpful in locating items such
as:
Images, vidoes, audio, blogs, maps, people, and or business
What are the 13 types of websites?
Social network Wiki Blog Education Personal News Business Portal Informational Entertainment Advocay Web application Content aggregator
Refers to any application that
combines text with: Graphics, Animations, Audio, Video, and Virtual reality
Multimedia
It is a digital representation of nontext information
Graphic
It is a small version of a larger graphic
Thumbnail
It is the appearance of motion created
by displaying a series of still images in sequence
Animation
It is the process of transferring data in a
continuous and even flow
Streaming
It is the use of computers to
simulate a real or imagined environment that
appears as a three‐dimensional space
Virtual Reality
It is a program that extends the capability
of a Web browser
Plug-in
It is the development and
maintenance of Web pages
Web Publishing
What are the steps in web publishing?
Plan a website - analyze and design a website - create a website - deploy a website - maintain a website
It is a business transaction that occurs
over an electronic network
E-Commerce
It is the transmission of messages and files via a It computer network
It is a group of e‐mail names and addresses given a single name
Mailing list
It is a real‐time Internet communications service
Instant messaging
It is a real‐time typed conversation that takes place on a
computer
Chat
It is alocation on an Internet server that permits users to chat with each other
Chat room
It enables users to speak to other users over the Internet
VoIP
It is an online area in which users have written discussions about a particular subject
Newsgroup
It is a Web‐based type of discussion group
Message board
It is an Internet standard that permits file uploading and downloading with other computers on the Internet
FTP
It is the code of acceptable Internet
behavior
Netiquette
Collection of data organized in a manner that allows access, retrieval, and use of that data
Database
Collection of unprocessed items • Text • Numbers • Images • Audio •Video
Data
Processed data •Documents • Audio • Images •Video
Information
It allows a user to create computerized database, add, delete, and modify data, sort and retrieve data, and create forms andreports from the data
Database software or DBMS - database management system
Characteristics of valuable informations:
Accuracy, Verifiable, Timely, Organized, Accesible, Useful, Cost-Effective
True or False:
Data may not be organized in layers
False
True or False:
A character is one byte
True
It is a combination of one or more related characters
Field
What are the 10 common data types?
Text Numeric AutoNumber Currency Date Memo Yes/No Hyperlink Object Attachment
It is a group of related fields
Record
It is a collection of related records
Data File
It refers to the procedures that keep data current
File Maintenance
Data can be maintained in 3 different ways:
Add, Delete, Modify
It compares data with a set of rules or
values to find out if the data is correct
Validation
What are the 5 validation checks?
Alphabetic/Numeric check Range check Consistency check Completeness check Check digit
It contains data about each file in
the database and each field in those files
Data dictionary
It consists of simple, English‐like
statements that allow users to specify the data to
display, print, or store
Query Language
provides a GUI to assist
users with retrieving data
Query By Example (QBE)
It is a window on the screen that provides
areas for entering or modifying data in a database
Form
It allows users to design a report
on the screen, retrieve data into the report
design, and then display or print the report
Report generator
What are the 2 DBMS privileges provide to
ensure that only authorized users
access data at permitted times
Access privileges
Principle of least privileges
A DMBS provides a variety of techniques to
restore the database to a usable form in case it is
damaged or destroyed. Give 4
Backup
Log
Recover Utility
Continuous Backup
It consists of rules and standards that
define how the database organizes data
Data Model
It is a query
language that allows users to manage, update,
and retrieve data
Structured Query Language (SQL)
It stores data in objects
Object‐oriented database (OODB)
It can store data in more
than two dimensions of data
Multidimensional database
Multidimensional Database is also called as ____
Hypercube
It is a huge database that stores and
manages the data required to analyze historical and
current transactions
Data Warehouse
Databases on the Web allow you to:
Shop for products or services Buy or sell sotcks Search of a job Make airlines reservations Register for college class Check smester grades
Decides on proper field
placement, defines data
relationship, and identifies
users’ access privileges
Database Analyst (DA)
Creates and maintains the data dictionary, manages security, monitors performance, and checks backup and recovery procedures
Database Administrator (DBA)
The ANSI standard language for the definition and manipulation of relational database.
SQL
Includes data definition language (DDL), statements that specify and modify database schemas.
Includes a data manipulation language (DML), statements that manipulate database content.
SQL
SQL data are Case Sensitive, but commands are not.
True or False.
True
Used to create tables
Create table ( , etc.);
Modifies table after it was created
Alter Table (add );
Alter Table ( drop );
Removes a table from database
Drop Table ;
Used to insert data in rows in a table
INSERT into VALUES(‘value1’, ‘value2’, NULL);
used to update data in a table
UPDATE SET =
WHERE;
used to delete data in a table
DELETE FROM
WHERE;
