Chapter 13 - Database design. This chapter teaches the design and construction of physical databases. You will know that you have mastered the tools and techniques of database design when you can: Compare and contrast conventional files and modern, relational databases; define and give examples of fields, records, files, and databases; describe a modern data architecture that includes files, operational databases, data warehouses, personal databases, and work group databases;. | Chapter 13 Database Design This repository of slides is intended to support the named chapter. The slide repository should be used as follows: Copy the file to a unique name for your course and unit. Edit the file by deleting those slides you don’t want to cover, editing other slides as appropriate to your course, and adding slides as desired. Print the slides to produce transparency masters or print directly to film or present the slides using a computer image projector. Each slide includes instructor notes. To view those notes in PowerPoint, click-left on the View Menu; then click left on Notes View sub-menu. You may need to scroll down to see the instructor notes. The instructor notes are also available in hardcopy as the Instructor Guide to Accompany Systems Analysis and Design Methods, 6/ed. Chapter 14 – Database Design Objectives Define and give examples of fields, records, files, and databases. Describe modern data architecture of files, operational databases, data warehouses, | Chapter 13 Database Design This repository of slides is intended to support the named chapter. The slide repository should be used as follows: Copy the file to a unique name for your course and unit. Edit the file by deleting those slides you don’t want to cover, editing other slides as appropriate to your course, and adding slides as desired. Print the slides to produce transparency masters or print directly to film or present the slides using a computer image projector. Each slide includes instructor notes. To view those notes in PowerPoint, click-left on the View Menu; then click left on Notes View sub-menu. You may need to scroll down to see the instructor notes. The instructor notes are also available in hardcopy as the Instructor Guide to Accompany Systems Analysis and Design Methods, 6/ed. Chapter 14 – Database Design Objectives Define and give examples of fields, records, files, and databases. Describe modern data architecture of files, operational databases, data warehouses, personal databases, and work group databases. Compare roles of systems analyst, database administrator, and data administrator. Describe architecture of database management system Describe how a relational database implements entities, attributes, and relationships from a logical data model. Transform a logical data model into a physical, relational database schema. Generate SQL to create the database structure in a schema. No additional notes Chapter 14 – Database Design Fields Field – the smallest unit of meaningful data to be stored in a database the physical implementation of a data attribute No additional notes. Chapter 14 – Database Design Fields (continued) Primary key – a field that uniquely identifies a record. Secondary key – a field that identifies a single record or a subset of related records. Foreign key – a field that points to records in a different file. Descriptive field – any nonkey field. No additional notes. Chapter 14 – Database Design Records Record – a .
