What do I mean by structure in a database Whats the payoff 8 Databases

What do i mean by structure in a database whats the

This preview shows page 4 - 11 out of 16 pages.

What do I mean by “structure” in a database? What’s the payoff? 8 Databases – Structured Data
CS 200 Spring 2018 SQL9Use of DatabasesWhat databases are you a part of?What are some of the benefits of belonging to a database?What are some of the drawbacks?Why/when do I use a database?How are the databases I am part of used? Data entry “validation” Sophisticated searching (aka “queries” ) Sophisticated summarizing and reporting Safe simultaneous updates by multiple users The REAL power of a relational database appears when you have multiple related tables what does “related” mean? why have multiple tables? Key DBMS Functionality CS 200 Spring 2018 Database Introduction 10
CS 200 Spring 2018 Database Introduction Table (Entity) Field (Attribute) Record 11 Database Terminology (1) CS 200 Spring 2018 Database Introduction Database Terminology (2) Report Query 12
CS 200 Spring 2018 Database Introduction Creation of a TableConsider the following example:You would like to create a database with all of the Albums you have downloaded onto your Phone.What info would be relevant to have in a table?What types of fields will each of these be?What are limitations, validations we want the fields to have? 13 CS 200 Spring 2018 Database Introduction Types of Fields Text Numbers (real or integer) Date Time Timestamp Media Calculation Summary 14
CS 200 Spring 2018 Database Introduction Data Entry Validation Auto Entry Number/Dates Ranges Value Lists Unique Values Required Fields and more…. 15 It’s easier to catch & correct errors when data is entered than it is to find and correct later CS 200 Spring 2018 Database Introduction Creating a Database 16
CS 200 Spring 2018 Database Introduction Album Table Fields 17 Field Name Album Title Album Type Medium Recording Year Label Purchase Price Album Artist Purchase Date CS 200 Spring 2018 Database Introduction Album Table Field Types 18 Field Name Field Type Album Title Album Type Medium Recording Year Label Purchase Price Album Artist Purchase Date Text Text Text Number Text Number Text Date
CS 200 Spring 2018 Database Introduction Album Table Field Definitions 19 Field Name Field Type Options Album Title Album Type Medium Recording Year Label Purchase Price Album Artist Purchase Date Text Text

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture