06_DatabaseIntro_2up.pdf - CS 200 Lecture 06 Database Introduction CS 200 Spring 2018 1 Database Introduction Miscellaneous Notes Abbreviations \u2022 \u2022

06_DatabaseIntro_2up.pdf - CS 200 Lecture 06 Database...

This preview shows page 1 - 5 out of 16 pages.

CS 200 CS 200 Spring 2018 Database Introduction 1 Lecture 06 Database Introduction CS 200 Spring 2018 Database Introduction Abbreviations aka also known as DBMS DataBase Management System mutatis mutantis with the necessary changes having been made 2 Miscellaneous Notes
Image of page 1
CS 200 Spring 2018 Database Introduction Please read and highlight BEFORE lab Assignment 6 This week’s lecture slides Reading Database Design (on Learn > Database Resources > Database Design) Adapted from Access Database Design and Programming by Steven Roman Today Database basics and Design Creation of a database Reports and Queries Relationships Please ask questions! 3 Administrativia CS 200 Spring 2018 Database Introduction Assumptions You have used a database before You understand basic data management 4
Image of page 2
CS 200 Spring 2018 Database Introduction Things to think aboutWhat are the data objects in a database?What are different databases you use?How are the databases you are part of used?Is the way data is displayed important? 5 CS 200 Spring 2018 Database Introduction This is your first pass at databases. By the end of this section you will be able to: design a simple database think about queries and reports understand database terminology and create relationships with a database Our objectives are to introduce you to database fundamentals 6 Databases
Image of page 3
CS 200 Spring 2018 Database Introduction 7 What is a Database? CS 200 Spring 2018 SQL Why use a database at all? You have to decide if that effort is worthwhile Obvious questions:
Image of page 4
Image of page 5

You've reached the end of your free preview.

Want to read all 16 pages?

  • Spring '14
  • BarbaraDaly
  • Relational model

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture