SYS 2202 Lecture Notes - Lecture 8: P Money, Database, Mysql

• School: University of Virginia
• Department: Systems & Information Engineering
• Course: SYS 2202
• Professor: Bass Ellen

Document Summary

Client-server architecture: mysql: stores and manages databases b. c. d. Client processes manipulate databases by interacting with the server. Interact with server using client application-> command line interface. Siedb1 server: server machine named siedb1. sys. virginia. edu on network. 2: mysql cli, used to work with databases b. Create table: create table () a: delete table: drop table ; c. Character strings: fixed-> char(n) / varying length-> varchar(n) up to n characters. Integers declared with int/integer or shortint (less bits/range) Floating point numbers: decimal numbers, declared with float/real or double precision. Declaring single-attribute keys: primary key after type declaration, ex: dname in department table above. Key declaration can be element in list of elements of create table statement, can be used for single attribute keys. Foreign keys: primary key (cnum, sectum) a. Constraint: a value appearing in one relation must appear as a primary key of another relation.