Topic 4 - Topic 4: The Conceptual Design This topic focuses...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Topic 4: The Conceptual Design This topic focuses on the techniques for organizing and documenting the conceptual database design. Many experts consider database design to be the most important component of information system development. As a basis for the database design, it is imperative that the design team study, document, and communicate the organization's information requirements, the relationships between data items, and the organization's rules governing the data. The methodology that is recommended to achieve an effective design is discussed. Students learn how to model the structure of the data and the relationships, using the Entity-Relationship Diagram and the relational schema. After reading this topic, you should be able to: Describe the database design process. Discuss the concepts of entities, attributes, and entity sets. Determine relationships between entities. Develop Entity-Relationship Diagrams. Create a relational schema view of a database design Lesson 1: Overview of Database Design Creating a database is no simple task. When faced with a problem that requires a database to be built, a certain process is frequently used to go about creating a database or database application. This process is called systems analysis and design , which focuses on the conceptual, logical, and physical schemas of the database design. After reading this lesson, you should be able to: Explain the importance of collecting organizational information for providing the foundation of a database design. Identify the individuals who are involved in the database design process within an organization. Discuss the steps in the systems life cycle. Define the conceptual, logical, and physical schemas of the database. Discuss the difference between database design and database implementation. System Analysis Database Design is part of a larger process called Systems Analysis and Design . The stages of the systems analysis and design life cycle are analysis, design, development and testing, implementation, and maintenance.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The analysis process begins with a study of the strategic goals of the organization, the means by which those goals can be accomplished, the information requirements that must be satisfied to reach those goals, and the systems necessary to meet those requirements. To fully exploit the advantages of database technology, the information requirements of the organization must be carefully studied and used to form the database design. Subject-matter experts, management, and users must study the organization, the procedures for processing the data used by the organization, and communicate the project requirements to the design team. In order to build an effective database and related applications, the Design Team must thoroughly understand
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 08/02/2009 for the course IST 210 taught by Professor Mcconn,charlotteryoo,jungwoo during the Summer '08 term at Pennsylvania State University, University Park.

Page1 / 13

Topic 4 - Topic 4: The Conceptual Design This topic focuses...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online