Database Reference
In-Depth Information
7. What are the two major activities in the logical design phase?
8. Instead of considering the creation of a semantic data model as part of the
logical design, can this considered as part of the requirements definition
phase? If you do so, what are some of the advantages and disadvantages?
9. How are CASE tools useful in the logical design phase? List any three major
benefits.
10. List the major contents expected to be part of logical design documentation.
EXERCISES
1. Match the columns:
1. output of logical design A. data as segments
2. logical schema B. files, blocks, records
3. data views C. consists of two-dimensional tables
4. consolidated semantic model D. input to physical design
5. hierarchical data model E. transformation of semantic data model
6. CASE tools F. representation at conceptual level
7. logical design of relational DB G. useful for communicating with users
8. second part of logical design H. translate into subschemas
9. physical data structure I. simplify data modeling
10. logical data model J. represents all relevant information
2. You are the senior analyst in the database project building a relational data-
base for a large bank. Write a memorandum to the CIO explaining the sig-
nificance of the logical design phase and describe the major activities in that
phase.
3. As the project manager for the database project for an insurance company,
what special measures will you take to ensure the completeness of the design
by end of the logical design phase?
4. Create a semantic data model for a small bakery and transform the semantic
data model into a relational data model. Produce the logical schema.
5. Describe the forward and backward engineering features found in most CASE
tools. As the lead database designer for a fast-food chain, describe how you
propose to use these features of your CASE tool.
Search WWH ::
Custom Search