slides8 - Schedule Today: Jan. 29 (T) x x Modifications,...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Winter 2002 Arthur Keller – CS 180 8–1 Schedule Today: Jan. 29 (T) Modifications, Schemas, Views. Read Sections 6.5-6.7. Assignment 3 due. Jan. 31 (TH) Constraints. Read Sections 7.1-7.3, 7.4.1. Project Part 3 due. Feb. 5 (T) Triggers, PL/SQL. Read Sections 7.4, 8.2. Assignment 4 due. Feb. 7 (TH) PL/SQL, Embedded SQL, CLI, JDBC. Read Sections 8.1, 8.3-8.5. Reminder: Midterm is Feb. 14 (TH)
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Winter 2002 Arthur Keller – CS 180 8–2 Defining a Database Schema CREATE TABLE name (list of elements). Principal elements are attributes and their types, but key declarations and constraints also appear. Similar CREATE X commands for other schema elements X : views, indexes, assertions, triggers. DROP X name” deletes the created element of kind X with that name. Example CREATE TABLE Sells ( bar CHAR(20), beer VARCHAR(20), price REAL ); DROP TABLE Sells;
Background image of page 2
Winter 2002 Arthur Keller – CS 180 8–3 Types 1.INT or INTEGER . 2.REAL or FLOAT . 3.CHAR( n ) = fixed length character string, padded with “pad characters.” 4.VARCHAR ( n ) = variable-length strings up to n characters. Oracle uses VARCHAR2 ( n ) as well. PostgreSQL uses VARCHAR and does not support VARCHAR2 .
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Winter 2002 Arthur Keller – CS 180 8–4 5. NUMERIC( precision, decimal ) is a number with precision digits with the decimal point
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/21/2011 for the course CS CS 180 taught by Professor Dr.arthur during the Fall '01 term at The University of Akron.

Page1 / 18

slides8 - Schedule Today: Jan. 29 (T) x x Modifications,...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online