This preview shows pages 1–3. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: MIS Exam II Study Guide SQL: GROUP BY- use with an aggregation HAVING- use with an aggregation; must be used with a GROUP BY clause; it will select rows based on certain conditions presented Table Joins : FROM table 1, table 2 WHERE table 1.foreign (or primary) key = table 2. Primary (foreign) key E-Business: Internet vs. World Wide Web • The World Wide Web uses the internet as a transport mechanism • The WWW has a client-server architecture • WWW provides standardized protocols for creating, naming, linking, and accessing the internet content • Hypertext Transport Protocol (HTTP)- the communication protocol for web server-client interaction E-Business Models- an approach to conducting business on the internet • Business-to-Business (B2B)- businesses buying and selling to each other over the internet. o tremendous efficiency o improved collaboration between employees and business partners • Business-to-Consumer- any business that sells its products or services to consumers via the internet. o new distribution channels o improved communication with customers o The Long Tail o E-Shop- version of a retailer where customers can shop any time (J. Crew) o E-Mall- a number of e-shops • Consumer-to-Business (C2B)- any consumer that sells to a business online (i.e. Priceline.com---selling airline tickets or hotel rooms and seller decides where to supply them) • Consumer-to-Consumer (C2C)- sites where goods and services are offered to consumers interacting with each other (i.e. eBay) Benefits of E-Business : • Customer loyalty due to accessibility, convenience, rich info content • Global reach • Reduced costs Risks of E-Business- • Security- protect against unsolicited goods, illegal goods, cyberfraud • Privacy • Legal requirements- exposes suppliers to unknown liabilitites due to internet...
View Full Document
This document was uploaded on 11/02/2011 for the course MIS 235 at Miami University.
- Spring '08