Extended DB Features
Oracle SQL Extensions
Linking Database Tables
Database Management System
Database Life Cycle
DBLC Design Stages
3 Schema Architecture
Post Design Stages
Application Approach DB Design
Database Design Strategy
Business Rules Importance
Customer Order Shipment
Define Business Objects
Data Flow Diagram
Interview Data Users
Attributes and Entities
Entities Conceptual Model
Store Entity Values
Attribute Domains Types
Rules for Creating Identifiers
Three Relationship Types
Convert m:n to 1:n
One to One Relationships
Optional Participation Relationships
Mandatory Optional Relationship
Student Class Entities
idef1x Crowsfoot Chen Models
ER diagram model Types
Three Model Types
ER Diagram Participation - Exercise
Diagramming types of participation
Diagramming relationships and types of participation (course project exercise 3)
Complete an ER diagram for the Stories on CD case study.
This exercise is worth a total of 60 points. You will receive up to five points for each correctly submitted piece of information according to the instructions below.
The preceding two lessons identified the constructs used to diagram relationship types between entities (1:1, 1:N, and M:N) and the symbols placed on the constructs to indicate mandatory and optional entity participation in the various relationships. In this exercise, you will use these symbols and constructs to create an ER diagram for the Stories on CD case study.
Below are the five entities for Stories on CD, with attributes added.
Five entities for Stories on CD
Next are five possible relationship constructs labeled A through E, with participation type included on the construct.
Five possible relationships
Your task, moving left to right through the Stories on CD entities, is to select the appropriate construct for each relationship. There are four relationships to consider:
For each entity, you must also identify all key types
for that relationship
. Use the sample format below for your answers.
Use construct D
VENDOR: VendID=PK PRODUCT: ProdID=PK, VendID=FK
Do not forget about the CPK/FK key types.
Submitting your exercise
Type or paste your answers into the text box below, then click
to submit them and view a results page. You will receive a response as you submit the form.