Database Modeling and basic sql syntax.pdf

(165 KB) Pobierz

296126479 UNPDF

Database Modeling and

Basic SQL Syntax

CS 492 Presentation

By: David Zazeski

Goals for this Presentation

1) Learn how to create data models

(specifically E-R diagrams)

2) Understand important SQL syntax

Questions about Data Modeling



What is Data Modeling?



Why do I need it?



How to make a data model?

What is an Entity?

a repeatable event, person, place, or

concept which will be stored and

retrieved. 1

1 Source: Modern Database Management by

Hoffer, Prescott, and McFadden

Definition: A noun which describes

Examples of Entities

Examples:

●

Student

●

Teacher

●

Purchase Order

●

Book