Unit 5 - Chapter 14

Question 1

E-commerce decision - The first major decision is choosing between in-house development ( doing the work within your own company) and

Answer 1

outsourcing ( hiring an outsider to do the work)

Question 2

ASP

Answer 2

Application Service Provider

Question 3

How can you get customers to your website? Steps

Answer 3

The customer hooks up to the Internet through his or her ISP(Internet Service Provider) and puts the URL into his or her Web browser. The browser works with DNS(Domain Name System) to find the unique IP ( Internet Protocol) address for this URL. Using this address, the TCP ( Transport Control Protocol) routes a connection through the Internet from the customer’s machine to the appropriate server. The browser uses this connection to send an HTTP GET message for the desired Web Page., which is then transmitted from the Web server back to the browser and displayed on the user’s screen, at which time the TCP/IP connection is broken. ( All of this with a single click of the mouse button!)

Question 4

Domain name

Answer 4

The home page URL

Question 5

ICANN ( Internet Corporation for Assigned Names and Numbers)

Answer 5

a nonprofit corporation that took over the task of domain name management from the U.S. government in 1998.

Question 6

Portal

Answer 6

A portal is an entry-point web page with links to other pages on the same topic.

Question 7

Cookie

Answer 7

a small text file that the Web server sends to the user’s browser and that gets stored on the user’s hard drive. It contains personal information about the user, such as name, address, time of visit, and what was looked at or brought.

Question 8

Transmission of Web pages between a client and server is stateless; that is, no information about this exchange is permanently

Answer 8

retained by the server.

Question 9

taxonomy

Answer 9

How information is classified and organized so customers can easily find what they want.

Question 10

middleware

Answer 10

software that allows a separate, existing programs to communicate and work together seamlessly

Question 11

Byte

Answer 11

a single unit of addressable memory

Question 12

A group of bytes is called

Answer 12

a field

Question 13

A collection of related fields is called

Answer 13

a record

Question 14

Reminder about bit, bytes, fields

Answer 14

Bits combine to form bytes
Bytes combine to form fields
Fields combine to form records
Records combine to form files
Files combine to form databases

Question 15

A database management system ( DBMS)

Answer 15

manages the files in a database

Question 16

Edgar F Codd

Answer 16

proposed the conception model of a file as simply a two-dimensional table.

Question 17

Relational database

Answer 17

a digital database based on the relational data as proposed by Edgar F codd

Question 18

In a database, a row of the table contains data about one instance of an entity - for example, one employee in an employees table, and the row is called

Answer 18

a tuple

Question 19

Primary key ( database)

Answer 19

is an attribute or combination of attributes that uniquely identifies a tuple.

Question 20

Database management systems usually require specialized query languages to enable the user or another application program to query ( ask questions of) the database

Answer 20

in order to retrieve information.

Question 21

SQL ( Structured Query Language)

Answer 21

A specialized query language created for database management systems.

Question 22

Each value of EmployeeID on another table ( for example Insurance Policies table) exists as an ID value in a tuple of the Employees table, where it is a primary key. Because of this, the EmployeeID attribute of the Insurance Policies table is called a

Answer 22

foreign key into the Employees table. This foreign key establishes the relationships that employees may have insurance plans.

Question 23

Relational Database operation - Project

Answer 23

Pick our certain attributes (columns) from a set of tupples

SELECT * FROM

Question 24

Relational Database operations - Restrict

Answer 24

Pick out tuples that meet a certain condition

WHERE ____ AND _____

Question 25

Relational Database operations - JOIN

Answer 25

Match tuples from two different relational tables using a common attribute
ID = EmployeeID ===» This is doing a join operation

Question 26

Relational database operations must be done with care, to be sure the data remains correct and consistent throughout the database.

Answer 26

In database terminology, the integrity of the data must be preserved.

Question 27

Entity integrity rule says that no primary key value, or no component, of a primary key value

Answer 27

can be missing (“null”)

Question 28

Data integrity rule specifies that values for a particular attribute must come from

Answer 28

the appropriate category of information for that attribute.

Question 29

referential integrity rule

Answer 29

specifies that any value of a foreign key attribute in a given table must match a value in the corresponding primary keys of the related table

Question 30

Distributed databases

Answer 30

allow the physical data to reside at separate and independent locations that are electronically networked together