COP 4710 Lecture Notes - Lecture 8: Data Definition Language, Double-Precision Floating-Point Format, Data Integrity
Document Summary
The schema for each relation, including attribute types. The set of indices to be maintained for each relations. The physical storage structure of each relation on disk. Di is the data type of attribute ai. Example: create table branch (branch_namechar(15), char(30), branch_city assets integer) Fixed length character string, with user-specified length n. Variable length character strings, with user-specified maximum length n. Integer (a finite subset of the integers that is machine-dependent). Domain types in sql: char(n). varchar(n) int smallint numeric(p,d). right of decimal point. real, double precision. machine-dependent precision. float(n). Integrity constraints on tables not null primary key (a1, , an ) Small integer (a machine-dependent subset of the integer domain type). Fixed point number, with user-specified precision of p digits, with n digits to the. Floating point and double-precision floating point numbers, with. Floating point number, with user-specified precision of at least n digits. Add a new tuple to account insert into account values ("a-9732", "perryridge", 1200)