1 / 11

Database Design

Database Design. Chapter 6 Database Design Sections Q1-Q4 Skip Sections Q5 & Q6. Today’s Topic. Security. Hardware & Software. IS Basics. Information Quality. Types of IS. Telecommu-nications. Systems Development. PowerPoint. Functional, Crossfunctional & Interorganizational.

leroy
Download Presentation

Database Design

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. Database Design Chapter 6Database Design Sections Q1-Q4 Skip Sections Q5 & Q6

  2. Today’s Topic Security Hardware & Software IS Basics Information Quality Types of IS Telecommu-nications Systems Development PowerPoint Functional, Crossfunctional & Interorganizational Database Processing & Design Spreadsheet Design E-commerce Access Excel Business Intelligence

  3. Database Design Database Design Entities Relationships Cardinality

  4. Objectives • Discuss the purpose of using an ERD. • Demonstrate the ability to read the details of an ERD.

  5. Source Document

  6. Source Data

  7. What is an E-R Model or ERD? Logical representation of database

  8. How are Relationships Specified?

  9. How Do I Read a Relationship? • A Customer may have a minimum of zero and a maximum of many Orders. • An Order may belong to a minimum of one and a maximum of one Customer.

  10. Reading ERD’s How many observations can a participant have at most? What is the minimum number of participants a given observation can be associated with? When is a person stored as a participant?

  11. ERD Activity You are a very busy plumber. You do only subcontract work which means you don’t work for individual homeowners, you work for contractors. You are so successful now that you’d like to be selective about the contractors you work for. You’d like to develop a database to help you analyze which contractors give you the best work. You prefer commercial jobs to residential, and jobs that are clearly specified with few changes after the project begins. You prefer local jobs. You’ll need to keep track of basic contact information about each contractor as well as qualitative aspects of each job.

More Related