Chapter 14In this chapter, you will learn:What is Electronic Commerce?E-Commerce ImpactE-Commerce StylesE-Commerce ArchitectureE-Commerce Architecture (Con’t.)Internet Basic ServicesSlide 9Business Enabling ServicesSecuritySample E-Commerce TransactionPayment ProcessingDatabase Design for E-CommerceBasic Business RulesBasic Business Rules (Con’t.)Slide 17CUSTOMER TablePRODUCT TableORDER TablePRODTYPE TableSHOPCART TableSHIPTYPE TableSTATE TablePRICEWATCH TableExtensible Markup Language (XML)XML CharacteristicsContents of ProductList.xmlDocument Type Definition (DTD)XML SchemaExtensible Style Language (XSL)Framework for XML TransformationsXML Applications14Chapter 14Databases in Electronic CommerceDatabase Systems: Design, Implementation, and Management, Fifth Edition, Rob and CoronelDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel214In this chapter, you will learn:•What electronic commerce (e-commerce) is•How e-commerce affects the new economy•About the different e-commerce styles•About the Internet architectural components required to conduct electronic commerce•About database design and implementation issues for electronic commerce applications•What Extensible Markup Language (XML) is and why it is importantDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel314•Definition–Bring new products, services, or ideas to market–Support and enhance business operations (including sales of products/services over the Web)•Generally identified with Internet use•External evidence is corporate Web site•Prime revenue source•Not an end in itselfWhat is Electronic Commerce?Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel414•Changed business environment•New economy •Benefits–Ability to provide quick and convenient comparison shopping–24X7X365 operations–Global access–Lower entry barriers–Increased customer market knowledge•Disadvantages–Hidden costs–Technology is not perfect–Thin profit margins–Security, loss of privacy, service levels, and legal issuesE-Commerce ImpactDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel514E-Commerce StylesFigure 14.1Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel614•Managerial issues–Establishing partnerships•Suppliers•Distributors•Vendors–Design and development of business plans•Technological issues–Hardware and software–Well-planned architectureE-Commerce ArchitectureDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel714E-Commerce Architecture (Con’t.)Figure 14.2Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel814Internet Basic Services•Internet•TCP/IP•Router•WWW•Web Page•HTML•Hyperlink•URL•HTTP•Web Browser•Web Server•Web Site•Static Web Page•Dynamic Web Page•FTP•E-Mail•News and Discussion Group ServicesDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel914Internet Basic ServicesFigure 14.3Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1014Business Enabling Services•Search Services•Security•Site Monitoring and Data Analysis•Load Testing, Balancing, and Web Caching•Usability Testing•Personalization•Web Development•Database Integration•Transaction Processing•Content Management•Messaging•Wireless Device SupportDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1114Security•Procedures and technology uses–Protection against accidental and intentional access–Warrantee identity of transaction’s participants•Buyer •Seller–Protect transaction data from unauthorized modifications during Internet travel–Protect resources (data and computer) •Customers’ personal data•Privacy issues•Property against criminal activitiesDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1214Sample E-Commerce TransactionFigure 14.4Database Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1314Payment Processing•Digital Cash–Digital equivalent of hard cash–Digital certificates verify identity of transaction participants–Low transaction costs–Lack of customer acceptance•Credit Card purchasing–Most common for online purchasing–Secure Electronic Transaction (SET) •Electronic walletsDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1414•Don’t reinvent the wheel•No need for ‘new’ design techniques•Scope–Facilitate sales of products and services–Show products and services–Conduct basic sales transactions–Customer service–Product returns–Web customer profilingDatabase Design for E-CommerceDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1514Basic Business Rules•Sell products–PRODUCT and CUSTOMER Tables•Customer may place multiple orders–1:M relationship between CUSTOMER and ORDER•Order contains multiple lines–1:M relationship between ORDER and ORDLINE•Order lines refer to one product–1:M between PRODUCT and ORDLINEDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1614Basic Business Rules (Con’t.)•Customer browses catalog by category–Each PRODUCT belongs to PRODTYPE •Customer places products in shopping cart–SHOPCART belongs to one CUSTOMER and references one or more PRODUCTS•Customer checks out and enters credit card and shipping info–Added to ORDER•After credit card authorization order created–SHOPCARD used to create ORDER with ORDLINEsDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1714Basic Business Rules (Con’t.)•Merchant offers shipping options–SHIPOPTION stores details•Merchant offers many payment options–PMTOPTION stores details•States may have different tax rates–Stored in STATE and TAXRATEDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1814CUSTOMER Table•Details for each registered customer•Some customers prefer not to register•Primary table contents–Name and address information–Login information–Credit card information–Billing information –Shipping information–Membership typeDatabase Systems: Design, Implementation, & Management, 5th Edition, Rob & Coronel1914PRODUCT Table•Central entity in