RelationalDBDesign
SiteMap
Database Analysis
Database Design
Extended DB Features
Oracle SQL Extensions
ER Diagrams
«Prev
Next»
Database Design
Database Structure
Linking Database Tables
RDBMS Functions
Database Model
Relationally Complete
Database Structure
Database Management System
Database Life Cycle
DBLC Design Stages
3 Schema Architecture
Post Design Stages
DBLC Stages
Design Tools
Application Approach DB Design
Database Design Strategy
Requirements Analysis
Business Rules Importance
Requirements Analysis
Customer Order Shipment
Define Business Objects
Data Flow Diagram
Interview Data Users
Attributes and Entities
Entities Conceptual Model
Multivalued Attribute(resolve)
Store Entity Values
Attribute Domains Types
Multivalued Attribute
Rules for Creating Identifiers
ER Diagrams
Three Relationship Types
Convert m:n to 1:n
One to One Relationships
Optional Participation Relationships
Mandatory Optional Relationship
Student Class Entities
ERD Conventions
idef1x Crowsfoot Chen Models
ER Diagram
ER diagram model Types
Three Model Types
One-to-one Relationships - Exercise
Objective:
Identify one-to-one relationships
Exercise scoring
This exercise is worth a total of 15 points. You will receive up to five points for each correctly composed and plausible business rule according to the instructions below.
Background/overview
You learned that a one-to-one relationship is defined as a relationship that exists when zero or one instance of entity A can be associated with zero or one instance of entity B, and zero or one instance of entity B can be associated with zero or one instance of entity A. You also learned that 1:1 relationships are rare in the business world.
Instructions
Compose three business rules that reflect a one-to-one relationship between two entities. Try to make your rules as realistic as possible.
Submitting your Exercise
Type or paste your answers into the text box below, then click
Submit
your answer and view a results page.
Submit