ITSS 4301 Exam 1 Review || with A+ Guaranteed Solutions.
personal computer (PC) correct answers also known as a micro-computer; a small computer
intended for use by one person as his or her own computer
internet correct answers the network that connects the entire Earth, and the basis for much of
modern computing
web browser correct answers the software that is used to connect to and interact with web pages
web sites correct answers locations on the world wide web
world wide web correct answers the set of interconnected hypertext objects accessible on the
internet, organized into web sites
web 2.0 correct answers web sites that allow users to contribute content
android operating system correct answers an operating system (OS) developed by google and
widely used on tablets and smartphones
app correct answers a short term for application, normally applied to applications running on
tablets and smartphones
data correct answers the values stored in database tables
device correct answers any equipment, such as a personal computer, that is connected to the
internet
user correct answers a person using an application
client correct answers in client-server architecture, the software that resides on the user's
computer, tablet, or smartphone
client-server architecture correct answers a computer application architecture that divides the
application into two parts: the client, which resides on the users' device, and the server, which
resides on a centralized server computer. the server responds to requests from clients
server correct answers a robust computer operated by information systems staff and used to run
the server portion of client server application such as web pages and email. servers are thus said
to provide services to users.
modification problems correct answers a situation that exists when the storing of one row in a
table records facts about two themes or the deletion of a row removes facts about two themes, or
when a data change must be made in multiple rows for consistency
, null values correct answers an attribute value that has never been supplied. such values are
ambiguous and can mean the value is unknown, the value is not appropriate, or the value is
known to be blank
relational database correct answers a database that consists of relations. in practice, relational
databases contain relations with duplicate rows. most DBMS products include a feature that
removes duplicate rows when necessary and appropriate. such removal is not done as a matter of
course because it can be time-consuming and expensive
relational model correct answers a data model in which data are stored in relations and
relationships between rows are represented by data values
tables correct answers a database structure of tows and columns to create cells that hold data
values. also known as a relation in a relational database, although strictly only tables that meet
specific conditions can be called relations
row correct answers a group of columns in a table. all the columns in a row pertain to the same
entity. also known as a type or a record
record correct answers a group of fields pertaining to the same entity, used in file-processing
systems. or, in the relational model, a synonym for a type or row.
instance correct answers a specific occurrence of an object of interest
field correct answers a logical group of bytes in a record used with file processing. or, in the
context of the relational model, a synonym for attribute
column correct answers a logical group of bytes in a row of a relation or a table. the meaning of a
column is the same for every row of the relation, and represents an attribute of a relation
modification action correct answers an action that changes the value of a data item
relation correct answers a two-dimensional array that contains single-value entries and no
duplicate rows. the meaning of the columns is the same in every row. the order of the rows and
columns is immaterial
ID column correct answers a column used as a primary key that usually has surrogate key values
structured query language (SQL) correct answers a language for defining the structure and
processing of a relational database it can be used as a stand-alone query language, or it can be
embedded in application programs. SQL was developed by IBM and is accepted as a national
standard by the American national standards institute.
database correct answers a self-describing collection of related records or, for relational
databases, of related tables
personal computer (PC) correct answers also known as a micro-computer; a small computer
intended for use by one person as his or her own computer
internet correct answers the network that connects the entire Earth, and the basis for much of
modern computing
web browser correct answers the software that is used to connect to and interact with web pages
web sites correct answers locations on the world wide web
world wide web correct answers the set of interconnected hypertext objects accessible on the
internet, organized into web sites
web 2.0 correct answers web sites that allow users to contribute content
android operating system correct answers an operating system (OS) developed by google and
widely used on tablets and smartphones
app correct answers a short term for application, normally applied to applications running on
tablets and smartphones
data correct answers the values stored in database tables
device correct answers any equipment, such as a personal computer, that is connected to the
internet
user correct answers a person using an application
client correct answers in client-server architecture, the software that resides on the user's
computer, tablet, or smartphone
client-server architecture correct answers a computer application architecture that divides the
application into two parts: the client, which resides on the users' device, and the server, which
resides on a centralized server computer. the server responds to requests from clients
server correct answers a robust computer operated by information systems staff and used to run
the server portion of client server application such as web pages and email. servers are thus said
to provide services to users.
modification problems correct answers a situation that exists when the storing of one row in a
table records facts about two themes or the deletion of a row removes facts about two themes, or
when a data change must be made in multiple rows for consistency
, null values correct answers an attribute value that has never been supplied. such values are
ambiguous and can mean the value is unknown, the value is not appropriate, or the value is
known to be blank
relational database correct answers a database that consists of relations. in practice, relational
databases contain relations with duplicate rows. most DBMS products include a feature that
removes duplicate rows when necessary and appropriate. such removal is not done as a matter of
course because it can be time-consuming and expensive
relational model correct answers a data model in which data are stored in relations and
relationships between rows are represented by data values
tables correct answers a database structure of tows and columns to create cells that hold data
values. also known as a relation in a relational database, although strictly only tables that meet
specific conditions can be called relations
row correct answers a group of columns in a table. all the columns in a row pertain to the same
entity. also known as a type or a record
record correct answers a group of fields pertaining to the same entity, used in file-processing
systems. or, in the relational model, a synonym for a type or row.
instance correct answers a specific occurrence of an object of interest
field correct answers a logical group of bytes in a record used with file processing. or, in the
context of the relational model, a synonym for attribute
column correct answers a logical group of bytes in a row of a relation or a table. the meaning of a
column is the same for every row of the relation, and represents an attribute of a relation
modification action correct answers an action that changes the value of a data item
relation correct answers a two-dimensional array that contains single-value entries and no
duplicate rows. the meaning of the columns is the same in every row. the order of the rows and
columns is immaterial
ID column correct answers a column used as a primary key that usually has surrogate key values
structured query language (SQL) correct answers a language for defining the structure and
processing of a relational database it can be used as a stand-alone query language, or it can be
embedded in application programs. SQL was developed by IBM and is accepted as a national
standard by the American national standards institute.
database correct answers a self-describing collection of related records or, for relational
databases, of related tables
