1 / 7

DirtBike Order Database– ER Diagram

DirtBike Order Database– ER Diagram. Prepared by Katrina B. ‘Luna’ Martin Fall 2012. 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.

sakura
Download Presentation

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 Katrina B. ‘Luna’ Martin 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