MIS 325 Lecture Notes - Lecture 4: Local Area Network, Wide Area Network, Unique Key
Document Summary
Local area network (lan): devices connected to one another. Client/server: processing is divided between client and server. File-handling system: all of the processing is done on the clients. Application servers: typically used to store business components that do part of the processing of the application. Web browser: runs on the client and sends request to a web application running on a web server. Web application: uses web services to perform some of its processing. Traditional mainframe systems and thin client systems also use sql. Relational databases: database technology involving tables (relations) representing entities and primary/foreign keys representing relationships. Can view and manipulate data in a way that is both intuitive and efficient. Primary key: column(s) that uniquely identify each row in the table. When a primary key consists of two or more columns. Indexes: provide an efficient way of accessing the rows in a table based on the values in one or more columns.