Stochastic Systems 3rd Edition By Vidyadhar G.
Kulkarni
What does Conceptual Data Modeling Represent? - ANSWER: Organizational Data
What is the purpose of Conceptual Data Modeling? - ANSWER: To show rules about
the meaning and interrelationships among data.
What diagrams are commonly used to show how data is organized? - ANSWER:
Entity-Relationship (ER) Diagrams
What is the main goal of conceptual data modeling? - ANSWER: To create more
accurate ER Diagrams
What methods are used to collect information? - ANSWER: Interviewing,
questionnaires, and JAD
What is the 1st step of Conceptual Data Modeling? - ANSWER: Develop a data model
for the system being replaced.
What is the 2nd step of Conceptual Data Modeling? - ANSWER: Build a new
conceptual data model that includes all requirements of the new system.
What happens in the design stage of conceptual data modeling? - ANSWER: The
conceptual data model is translated into a physical design.
What is the primary deliverable of a conceptual data model? - ANSWER: Entity-
Relationship (ER) Diagram
There can be up to _____ ER diagrams produced and analyzed during conceptual
data modeling. - ANSWER: 4
What are the 4 ER diagrams that can be produced during conceptual data modeling?
- ANSWER: 1. Diagram covering data needed in the project's application.
2. Diagram for system being replaced
3. Diagram for the whole database from which new application's data are being
extracted
4. Diagram for whole database from which data for the application system being
replaced
What is an entity shown as? - ANSWER: A rectangle with entity name in center
How many relationships on an ER diagram can there be? - ANSWER: 4
What does the mandatory 1 relationship look like? - ANSWER: a line with ||
, what does a mandatory many relationship look like? - ANSWER: a line with |<
What does an optional many relationship look like? - ANSWER: a line with O<
What does an optional one relationship look like? - ANSWER: A line with O|
What is a second deliverable from conceptual data modeling? - ANSWER: a set of
entries about data objects to be store in repository or project dictionary.
Data elements included in the _____ must appear in the ________. - ANSWER: DFD;
Data Model
Each data store in a process model must relate to _______ _______ represented in
the _____ ________. - ANSWER: business ojects; data model
What are the 2 perspectives for conceptual data modeling? - ANSWER: 1. Top Down
Perspective
2. Bottom Up Perspective
What is Top Down Perspective? - ANSWER: data model is derived from an intimate
understanding of the business.
What is Bottom Down Perspective? - ANSWER: Data model is derived by reviewing
specifications and business documents.
what are the 3 main constructs for notation? - ANSWER: 1. Data entities
2. Relationships
3. Attributes
What is an ER Diagram? - ANSWER: A detailed, logical, and graphical representation
of the entities, associations and data elements for an organization of business
What is an entity? - ANSWER: a person, place, object, event, or concept in the user
environment about which the organization wishes to maintain data.
How is an entity represented? - ANSWER: A rectangle (in some cases a diamond)
What is an entity type? - ANSWER: a collection of entities that share common
properties or characteristics
What is an entity instance? - ANSWER: A single occurrence of an entity type.
What is an attribute? - ANSWER: a named property or characteristic of an entity that
is of interest to an organization.