Topic 6a - Topic 6: Implementing the Design: An...

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

View Full Document Right Arrow Icon
Topic 6: Implementing the Design: An Introduction to SQL The purpose of creating a database is to store data efficiently and allow its users to locate and retrieve information effectively. This topic focuses on taking the E- R Diagram and building the database out using SQL. Also, techniques are discussed that deal with how to efficiently store data in the database so it can be easily retrieved by users at a later time. After reading this topic, you should be able to: Create a physical database design from a conceptual design. Discuss the importance of meta-data and the data dictionary. Discuss the importance of data definitions and data types. Use SQL to create a database. Describe how to utilize primary keys. Lesson 1: Design Implementation Basics This lesson focuses on preparing a database to go from the conceptual design to the actual physical design. To do this, you must understand how to utilize the data definition and data manipulation language, which are both discussed in this lesson. After reading this lesson, you should be able to: Identify the steps necessary to create a database from the conceptual design. Explain the purpose of the data definition language. Explain the purpose of the data manipulation language. Design Implementation Basics A good database design is one that also addresses the information storage requirements and reporting needs of the organization. Design teams often include business analysts from user areas to ensure that the design is one that end users can understand and put to use. Because the design process has involved the eventual user, these designs are often easy to implement. The current topic will present the methods and processes involved in building the physical database.
Background image of page 1

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

View Full DocumentRight Arrow Icon
During physical implementation the analyst is defining the design to the database management system. This section discusses the preparation for physical implementation and then the actual steps that are taken to create the database and its tables from the conceptual design. These steps include defining the data, creating tables, defining constraints (i.e. primary and foreign keys), inserting data into the tables and granting access to the data. Preparation As the data model has been designed the analyst and the eventual users have been considering the following issues: How many entities are there? What are the major entities? What are the attributes of each entity? Is there a unique identifier for one or more of these entities? How are the entities related to each other? What queries and/or reports will be produced with the data? These questions will influence the way that the database is implemented. Generally the design progresses from data model to table implementation
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.

Page1 / 19

Topic 6a - Topic 6: Implementing the Design: An...

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