Unit 5 - Chapter 14 Flashcards
E-commerce decision - The first major decision is choosing between in-house development ( doing the work within your own company) and
outsourcing ( hiring an outsider to do the work)
ASP
Application Service Provider
How can you get customers to your website? Steps
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!)
Domain name
The home page URL
ICANN ( Internet Corporation for Assigned Names and Numbers)
a nonprofit corporation that took over the task of domain name management from the U.S. government in 1998.
Portal
A portal is an entry-point web page with links to other pages on the same topic.
Cookie
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.
Transmission of Web pages between a client and server is stateless; that is, no information about this exchange is permanently
retained by the server.
taxonomy
How information is classified and organized so customers can easily find what they want.
middleware
software that allows a separate, existing programs to communicate and work together seamlessly
Byte
a single unit of addressable memory
A group of bytes is called
a field
A collection of related fields is called
a record
Reminder about bit, bytes, fields
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
A database management system ( DBMS)
manages the files in a database
Edgar F Codd
proposed the conception model of a file as simply a two-dimensional table.
Relational database
a digital database based on the relational data as proposed by Edgar F codd
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
a tuple
Primary key ( database)
is an attribute or combination of attributes that uniquely identifies a tuple.
Database management systems usually require specialized query languages to enable the user or another application program to query ( ask questions of) the database
in order to retrieve information.
SQL ( Structured Query Language)
A specialized query language created for database management systems.
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
foreign key into the Employees table. This foreign key establishes the relationships that employees may have insurance plans.
Relational Database operation - Project
Pick our certain attributes (columns) from a set of tupples
SELECT * FROM
Relational Database operations - Restrict
Pick out tuples that meet a certain condition
WHERE ____ AND _____
