1 / 7

DirtBike Order Database– ER Diagram

This document outlines the process of designing a Dirt Bike Order Database using Entity-Relationship (E-R) Diagrams. Prepared by Emily Cornell in Fall 2012, it covers four essential steps: defining entity classes and primary keys, establishing relationships among classes, specifying fields for each relationship, and creating the database in Microsoft Access. Key entities include customers, orders, products, distributors, and detailed order records, visually represented through standardized symbols in E-R diagrams to illustrate connectivity and cardinality.

keefe
Télécharger la présentation

DirtBike Order Database– ER Diagram

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DirtBike Order Database– ER Diagram Prepared by Emily Cornell Fall 2012

  2. Designing Databases with Entity Relationship Diagrams Step 1: Define Entity Classes and Primary Keys Step 2: Define Relationships Among Entity Classes Step 3: Define Fields for each Relationship Step 4: Create Database

  3. Step 1: Define Entity Classes and Primary Keys

  4. E-R Diagrams Use 5 symbols • Rectangle – entity class • Dotted line – relationship • | - single relationship • 0 – zero/optional relationship • Crow’s foot () – multiple relationship

  5. Step 2: Define Relationships Among Entity Classes CUSTOMER ORDER DETAILED ORDERS DISTRIBUTOR PRODUCT

  6. Step 3: Define Fields for each Relationship Customer Order Product Distributor Detailed Orders

  7. Step 4: Create Database (At this point we will begin working with our DBMS system, which will be Microsoft Access)

More Related