Dagmar Kusiak - PowerPoint PPT Presentation

1 / 16
About This Presentation
Title:

Dagmar Kusiak

Description:

Identify users of new system and interview them. Gather existing forms, ... Entity A is associated with many entity B's and entity B is associated with many A's. ... – PowerPoint PPT presentation

Number of Views:71
Avg rating:3.0/5.0
Slides: 17
Provided by: dagmar3
Category:
Tags: dagmar | kusiak | manya

less

Transcript and Presenter's Notes

Title: Dagmar Kusiak


1
Chapter 4
  • Dagmar Kusiak

2
Chapter Objectives
  • Requirement Stage
  • Figure out the requirements for the project
  • Conceptual Design
  • Entities
  • Attributes
  • Relationships

3
Requirements
  • Identify users of new system and interview them
  • Gather existing forms, reports, queries
  • Build Use Cases
  • Build Business Rules

4
Conceptual Design
  • Entities

5
Conceptual design continued
  • Entity Instances

6
Conceptual design continued
  • Attributes

7
Conceptual design continued
  • Identifiers
  • Primary key

8
Conceptual design continued
  • Relationships
  • Cardinality
  • 11
  • 1M
  • MM

9
Conceptual design continued
  • 11
  • Entity A is associated with at most one entity B
    and entity B is associated with at most one
    entity A.
  • Foreign Key can be in either table

10
Conceptual design continued
  • 1M
  • Entity A is associated with many entity Bs and
    entity B is associated with at most one entity A.
  • Foreign key is primary key in 1 table

11
Conceptual design continued
  • MM
  • Entity A is associated with many entity Bs and
    entity B is associated with many As.
  • RULE Break into one to many tables

12
Conceptual design continued
  • MM

13
Conceptual design continued
  • Recursive Relationship

14
Conceptual design continued
  • Recursive Relationship

15
Conceptual design continued
  • Weak Entities
  • Entity dependant on another entity
  • Courses is dependant on professor, so courses is
    a weak entity
  • The foreign key is also the primary key

16
Conceptual Design
Write a Comment
User Comments (0)
About PowerShow.com