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.
This preview has intentionally blurred sections.
Sign up to view the full version.