IDS 200 – Fall 2016: Test #2 Review
Chapter Extension 3 – Mobile Systems
Mobile Systems - Information systems that support users in motion.
Mobile System’s Four Major Elements
1. Users in 2. Mobile 3. Wireless Connectivity 4. Cloud-based Resources
User Interface (UI) - The presentation format of an application that consists of windows,
menus, icons, dialog boxes, toolbars, and so on, as well as user content.
User Experience (UX) - Not only refers to the user interface (UI) but also the way the
application affects the user’s emotions and motivation to continue to use the interface.
Chrome - Visual overhead, such as menus, status bars, and scroll bars, in a computer display.
Roaming - Occurs when users move their activities, especially long-running transactions,
BYOD Policy - A statement concerning employees’ permissions and responsibilities when they
use their own device for organization business.
Mobile Systems’ Implications on Information Systems Thin (Web) vs. Thick (Native) Applications
Quality Mobile User Experience
Employees Using Mobile Systems at
Work Six Common BYOD Policies
Chapter Extension 5 – Database Design
Data Model - A logical representation of the data in a database that describes the data and
relationships that will be stored in the database. Akin to a blueprint.
Data Design - The process of designing a detailed logical data model of a database.
Entity-Relationship (E-R) Data Model and Diagram
Entity - Something that the users want to track. Attributes - Describe characteristics of the entity.
Identifier - An attribute or group of attributes whose value is associated with one and only one
Crow’s Feet - Lines on an entity-relationship diagram that indicate a 1:N relationship between
two entities. (Vertical bars on a line means at least one entity is required in the relationship,
while an oval means that an entity is optional.)
One-to-Many Relationship (1:N) - Relationships involving two entity types in which an instance
of one type can relate to many instances of the second type, but an instance of the second type
can relate to at most one instance of the first.
Many-to-Many Relationship (N:M) - Relationships involving two entity types in which an
instance of one type can relate to many instances of the second type and an instance of the
second type can relate to many instances of the first.
Maximum Cardinality - The maximum number of entities that can be involved in a relationship.
Minimum Cardinality - The minimum number of entities in a relationship.
Three steps to transforming Data Models to Data
Normalization - The process of converting poorly
structured tables into two or more well-structured tables.
The goal of normalization is to construct tables with a
single theme or entity, while minimizing data integrity
Represent Relationships: 1:N & N:M Relationships
Foreign Key for 1:N Relationships - To represent a
1:N relationship, a foreign key (primary key to another
entity table) is added to the related entity to establish
Intersection Tables for N:M Relationships - To
represent a N:M relationship, an intersection table
(simply a third table using an identifier from each of the
involved entities) is created and filled with the various
relationships between the attributes of the entities.
Create numeric identifiers (if necessary) - Using
numerical identifiers instead of actual words or phrases
can help avoid data integrity problems. By substituting
certain identifiers it can avoid instances of repeated
data or data that has two different identifiers with the same meaning.
User’s Role - Users are the final judges as to what data is contained in the database and how
the records in that database should be related to one another. Users need to thoroughly review
the data model. Chapter Extension 8 – Network and Cloud Technology
Computer Network - A collection of computers that communicate with one another over
transmission lines or wirelessly.
Local Area Network (LAN) - A network that connects computers that reside in a single
geographic location on the premises of the company that operates the LAN. The number of
connected computers can range from two to several hundred.
Wide Area Network (WAN) - A network that connects computers at different geographic
locations; computers in two separated company sites must be connected using a WAN.
“The Internet” vs internet - An internet is a private network of networks; they can connect
LANs, WANs, and other internets. “The Internet” (always an uppercase “I”) is the public
collection of networks.
Intranet - A private internet used within a corporation or other organization.
Protocol - A set of rules that programs on two communicating devices follow.
Wired Connections Wireless Connections
IEEE 802.3 Protocol IEEE 802.11 Protocol - A Bluetooth - A common
(Ethernet) - A standard for standard for packaging and wireless protocol designed for
packaging and managing managing traffic on wireless transmitting data over short
traffic on wire local area local area network. Allow for distances, replacing cables.
networks. Allow for transmission speeds up to Usually used to make
transmission at a rate of 10, 1.3 Gbps. Personal Area Networks
100, or 1000 Mbps. (PAN) connections.
Router - A networking device that
forwards data packets between computer
Switch - A computer networking device
that connects devices together on a
computer network, by using packet
switching to receive, process and forward
data to the destination device.
Access point - A station that transmits
and receives data, connecting users to
other users within the network. Internet Service Provider (ISP) - An ISP provides a user with a legitimate Internet address; it
serves as the user’s gateway to the Internet; and it passes communications back and forth
between the user and the Internet. ISPs also pay for the Internet. They collect money from their
customers and pay access fees and other charges on the users’ behalf.
Digital Subscriber Line (DSL) - A communications line that operates on the same lines as
voice telephones, but does so in such a manner that its signals do not interfere with voice
Cable Lines - Cable television lines that provide high-speed data transmission.
WAN Wireless Connection - A communication system that provides wireless connectivity to a
wide area network.
Packets - A formatted message that passes through networks.
Hops - In an internet, the movement from one network to another.
Net Neutrality - The idea that all data should be treated equally as it passes between networks
regardless of its type, source, or quantity.
Public IP Addresses - An IP address used to identify a particular device on the Internet. Such
IP addresses are assigned to major institutions in blocks by the Internet Corporation for
Assigned Names and Numbers (ICANN). Each IP address is unique across all computers on
Private IP Addresses - A type of IP address used within private networks and internets. Private
IP addresses are assigned and managed by the company that operates the private network or
IPv4 vs IPv6 - IPv4 is the most commonly used Internet layer protocol; it has a four-decimal
dotted notation, such as “184.108.40.206.502” IPv6 is another Internet layer protocol that uses
128-bit addresses and is gradually replacing IPv4.
ICANN (Internet Corporation for Assigned Names and Numbers) - The organization
responsible for managing the assignment of public IP addresses and domain names for use on
the Internet. Each public IP address is unique across all computers on the Internet.
Domain Name - A worldwide-unique name that is affiliated with a public IP address. Several
domain names can point to the same IP address, and the affiliation of domain names with IP
addresses is dynamic.
Uniform Resource Locator (URL) - An address on the Internet. Commonly, it consists of a
protocol, such as “http://” or “ftp://” followed by a domain name or public IP address. Three-tier Architecture:
User Tier - Consists of users’ computers, phones, other devices that have browsers that
request and process Web pages.
Server Tier (Web Servers and Commerce Servers) - Consists of computers that run Web
servers and applications, and in the process generate Web pages and other data in response to
requests from browsers. Web Servers are programs that run on a server-tier computer and
manage traffic by sending and receiving Web pages to and from clients. Commerce Server is
an application program that runs on a server-tier computer; their functions are to obtain product
data from a database, manag