CSE 385 Chapter Notes - Chapter 1: Relational Model, Unique Key, Database

• School: Miami University
• Department: Computer Science & Software Engineering
• Course: CSE 385
• Professor: Mr. Michael Stahr

Document Summary

1 - an introduction to relational databases and sql. Three hardware components: clients (pcs on desk), network(wiring and everything connecting clients to server), server (high powered pc or mainframe storing information). Server requires a database management system (dbms) to store and manage database (back end). Client requires application software to do the work and a data access api (front end) Communicate with server through queries in sql (structured query language) Client/server systems share the processing done by an application, where file-handling systems have all processing done on the client. Client/server systems can have additional servers like application servers and web servers in addition to database servers and clients. Relational model allows for reduced data redundancy, saving storage and making retrieval efficient. Data stored in 1+ tables that are modeled from real world entities. Primary key of the table is one or more columns that uniquely identify each row. How tables in relational database are related.