ACC 444 Study Guide - Midterm Guide: First Normal Form, Sql, Foreign Key
Document Summary
Business logic: thin server (data access logic, thin client (presentation logic, fat server (business & data. Logic: three-tier client server architecture, places application tier with business logic in-between client & database tier, advantages: better security; easier maintenance; data changed w/o affecting client; scalability (more clients and servers added easily) Structured query language (sql: programming language for communicating with rdbms, queries: user requests for information from the database, select (something), from tablename, where (condition) Customization: fitti(cid:374)g erp soft(cid:449)are (cid:271)y addi(cid:374)g (cid:272)ode (cid:449)he(cid:374) (cid:272)o(cid:373)pa(cid:374)y"s (cid:374)eeds fall outside (cid:271)ou(cid:374)ds of a(cid:374) Erp: ex: a missing field, form, need to link tables not already linked. Best of breed: middleware: software that facilitates sharing data and business logic across systems, requires it support to maintain. System landscape: system landscape: layout or architecture of servers. Instance: installation of erp software and related components on a server(s: purchase multiple servers and install erp and database several times, three systems:
