chapter 5

chapter 5 - COP 4710: Database Systems Fall 2009 Chapter 5...

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

View Full Document Right Arrow Icon
COP 4710: Database Systems (Chapter 5) Page 1 Mark Llewellyn COP 4710: Database Systems Fall 2009 Chapter 5 – Introduction To SQL School of Electrical Engineering and Computer Science University of Central Florida Instructor : Dr. Mark Llewellyn markl@cs.ucf.edu HEC 236, 407-823-2790 http://www.cs.ucf.edu/courses/cop4710/fall2009
Background image of page 1

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

View Full DocumentRight Arrow Icon
COP 4710: Database Systems (Chapter 5) Page 2 Mark Llewellyn The Physical Design Stage of SDLC Purpose –programming, testing, training, installation, documenting Deliverable – operational programs, documentation, training materials, program/data structures Database activity – physical database design and database implementation Project Identification and Selection Project Initiation and Planning Analysis Physical Design Implementation Maintenance Logical Design Implementation Physical Design
Background image of page 2
COP 4710: Database Systems (Chapter 5) Page 3 Mark Llewellyn SQL Overview SQL ≡ Structured Query Language. The standard for relational database management systems (RDBMS). SQL: 2007 Standards – Purpose: Specify syntax/semantics for data definition and manipulation. Define data structures. Enable portability. Specify minimal (level 1) and complete (level 2) standards. Allow for later growth/enhancement to standard.
Background image of page 3

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

View Full DocumentRight Arrow Icon
COP 4710: Database Systems (Chapter 5) Page 4 Mark Llewellyn Benefits of a Standardized Relational Language Reduced training costs Productivity Application portability Application longevity Reduced dependence on a single vendor Cross-system communication
Background image of page 4
COP 4710: Database Systems (Chapter 5) Page 5 Mark Llewellyn The SQL Environment Catalog A set of schemas that constitute the description of a database. Schema The structure that contains descriptions of objects created by a user (base tables, views, constraints). Data Definition Language (DDL) Commands that define a database, including creating, altering, and dropping tables and establishing constraints. Data Manipulation Language (DML) Commands that maintain and query a database. Data Control Language (DCL) Commands that control a database, including administering privileges and committing data.
Background image of page 5

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

View Full DocumentRight Arrow Icon
COP 4710: Database Systems (Chapter 5) Page 6 Mark Llewellyn A simplified schematic of a typical SQL environment, as described by the SQL:2007 standard Developmental database Production database
Background image of page 6
COP 4710: Database Systems (Chapter 5) Page 7 Mark Llewellyn Some SQL Data Types (from Oracle 11g) String types CHAR(n) – fixed-length character data, n characters long Maximum length = 2000 bytes VARCHAR2(n) – variable length character data, maximum 4000 bytes LONG – variable-length character data, up to 4GB. Maximum 1 per table Numeric types NUMBER(p,q) – general purpose numeric data type INTEGER(p) – signed integer, p digits wide FLOAT(p) – floating point in scientific notation with p binary digits precision Date/time type DATE – fixed-length date/time in dd-mm-yy form
Background image of page 7

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

View Full DocumentRight Arrow Icon
COP 4710: Database Systems (Chapter 5) Page 8 Mark Llewellyn DDL, DML, DCL, and the database development process
Background image of page 8
Image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 84

chapter 5 - COP 4710: Database Systems Fall 2009 Chapter 5...

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

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