Transcript Slides

David M. Kroenke’s
Database Processing:
Fundamentals, Design, and Implementation
Chapter Eleven:
Managing Databases with
SQL Server 2000
Part Two
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-1
SQL Server CREATE TABLE Statements
for the View Ridge Schema
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-2
SQL Server CREATE TABLE Statements
for the View Ridge Schema
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-3
SQL Server CREATE TABLE Statements
for the View Ridge Schema
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-4
SQL Server CREATE TABLE Statements
for the View Ridge Schema
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-5
Viewing Tables
in Enterprise Manager
Right-Click
the table
name, then
click Design
Table to view
table
columns and
properties.
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-6
Viewing Table Columns and
Properties in Enterprise Manager
Right-click
the white
space and
then click
Properties to
see table
constraints.
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-7
Viewing Table Constraints in
Enterprise Manager
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-8
Creating a Relationship Diagram in
Enterprise Manager
Right-click
Diagrams,
then click
New
Database
Diagram to
create a
relationships
diagram.
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-9
Table Relationship Diagram
Right-click a
relationship
line, then
click
Properties to
see the
properties.
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-10
WORK – TRANS Relationship Properties
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-11
Creating Views:
By SQL in SQL Query Analyzer
Do NOT put a
semi-colon (;)
at the end of
a CREATE
VIEW
statement in
SQL Query
Analyzer!
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-12
Creating Views:
By GUI in Enterprise Manager
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-13
David M. Kroenke’s
Database Processing
Fundamentals, Design, and Implementation
(10th Edition)
End of Presentation:
Chapter Eleven Part Two
DAVID M. KROENKE’S DATABASE PROCESSING, 10th Edition
© 2006 Pearson Prentice Hall
11-14