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
Identify Business Objects - Exercise
Business objects and their characteristics
Identify business objects and their characteristics.
This exercise is worth of total of 10 points. You will receive up to five points for each correctly completed task described below.
In the previous lesson, you learned about business objects and their characteristics. You also learned that a major task of the database designer is to examine an organization's existing database(s) as the starting point in needs analysis. This exercise gives you the opportunity to test your ability to perform that task.
This exercise requires a copy of the sample case study.
If you have not downloaded it already, click the following link to download the case study.
ERD Case Study
Assuming the role of database designer, you begin your analysis by examining the data-entry form from Stories on CD, Inc. Your task is twofold:
Identify three business objects associated with the form
List two characteristics for each business object you find
Hints on Submitting your Exercise
As you examine the data-entry form looking for business objects and their characteristics, consider the form itself. Type or paste your responses to the tasks described above into the text box below. Then click
to submit your responses and view a results page.