SQL Database Design u SQL u Relational Database

SQL & Database Design u SQL u Relational Database Design u Steve Perry u E-mail: sqlclass@yahoo. com u Messages: 714/582 -4900 (x 3066) 1

Class Survey u How people consider themselves to be. . . – Programmers – System Analysts – Computer Users 2

Rules & Regulations u Please whisper if you need to talk during a lecture. u Attendance is Optional – Read Book – Do assignments 3

Class Format u 7: 00 -8: 00 u 8: 00 -8: 15 u 8: 15 -9: 15 u 9: 15 -9: 45 u 9: 45 Lecture & Exercises Break Lecture & Exercises Question & Answer Period Class Dismissed 4

Class Breakdown u 17 Lectures - No Final u SQL - 9 Lectures u Embedded SQL - 1 Lecture u Database Design - 5 Lectures u Review - 2 Lectures 5

We're on the Web u u u saddleback. cc. ca. us http: //iserver. saddleback. cc. ca. us/spring 99/22730. shtml iserver. saddleback. cc. ca. us/faculty/sperry/sql/ 6

Assignments u 10 Assignments (on the web) u 5 Questions (each worth 2 points) - There is only one correct answer! u Submit Assignments on the Web 7

Using SQLAnywhere u. A runtime version of SQLAnywhere is included on the CD in back of your book u Install it on your own PC or use the Lab u Assignment answers are designed to run on SQL Anywhere u Note: the Bookbiz database is in a separate directory on the CD (Examples folder) [ bookbiz. db ] 8

Assignment Grading u 1 point may deducted from assignment grade for each week past due. u Questions are from the Book and Instructor Notes (on the Web Page). 9

Class Grading u 10 Assignments (10 points each) u No Final u 10 point Bonus if you complete all assignments Points 100 -85 84 -70 69 -60 59 -50 49 -0 Letter Grade A B C D F 10

Questions u Can ask during class or during Breaks u Can ask during the Q&A Period u Do NOT ask before class while I’m busy setting up. 11

Connecting to the Database u See Web Instructions u Start SQLAnywhere u Menu: Command|Connect u User. Id: dba Password: sql u Database File: c: /sql/bookbiz. db 12

Class Exercises u No individual computers provided u Hand write the class exercise solutions u Work together 13

Covered in SQL Book u Database queries using the SQL Select statement u Database manipulation using the Insert, Delete and Update statements. u Basic Database Design u Using Views u Fundamental Database Management 14

Covered from Instructor Notes u Embedded SQL u Advanced Database Design (Optional: Data Modeling Essentials by Graeme Simison) 15

Separated at Birth? 16

Last Slide - Introduction 17