chapter 7 - CGS 2545: Database Concepts Spring 2010 Chapter...

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

View Full Document Right Arrow Icon
CGS 2545: Database Concepts (Chapter 7) Page 1 Mark Llewellyn CGS 2545: Database Concepts Spring 2010 Chapter 7 – Introduction To SQL School of Electrical Engineering and Computer Science University of Central Florida Instructor : Dr. Mark Llewellyn [email protected] HEC 236, 407-823-2790 http://www.cs.ucf.edu/courses/cgs2545/spr2010
Background image of page 1

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

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Chapter 7) Page 2 Mark Llewellyn Objectives Definition of terms. Discuss advantages of standardized SQL. Define a database using SQL data definition language. Write single table queries using SQL. Establish referential integrity using SQL. Work with Views.
Background image of page 2
CGS 2545: Database Concepts (Chapter 7) Page 3 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 3

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

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Chapter 7) Page 4 Mark Llewellyn SQL Overview SQL ≡ Structured Query Language. The standard for relational database management systems (RDBMS). SQL-99 and SQL: 2003 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 4
CGS 2545: Database Concepts (Chapter 7) Page 5 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 5

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

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Chapter 7) Page 6 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 6
CGS 2545: Database Concepts (Chapter 7) Page 7 Mark Llewellyn A simplified schematic of a typical SQL environment, as described by the SQL:2003 standard Developmental database Production database
Background image of page 7

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

View Full DocumentRight Arrow Icon
CGS 2545: Database Concepts (Chapter 7) Page 8 Mark Llewellyn Some SQL Data Types (from Oracle 10g) String types CHAR(n) – fixed-length character data, n characters long Maximum length = 2000 bytes
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.

This note was uploaded on 10/05/2010 for the course CGS 2545C CGS 2545c taught by Professor L during the Spring '10 term at University of Central Florida.

Page1 / 38

chapter 7 - CGS 2545: Database Concepts Spring 2010 Chapter...

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