01969_PPT_ch14 - Programming Logic and Design Fifth...

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

View Full Document Right Arrow Icon
Programming Logic and Design Fifth Edition, Comprehensive Chapter 14 Using Relational Databases
Background image of page 1

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

View Full DocumentRight Arrow Icon
Programming Logic and Design, Fifth Edition, Comprehensive 2 Objectives Understand relational database fundamentals Create databases and table descriptions Be able to identify primary keys Understand database structure notation Understand the principles of adding, deleting, updating, and sorting records within a table
Background image of page 2
Programming Logic and Design, Fifth Edition, Comprehensive 3 Objectives (continued) Create queries Understand relationships between tables Recognize poor table design Understand anomalies, normal forms, and the normalization process Understand database performance and security issues
Background image of page 3

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

View Full DocumentRight Arrow Icon
Programming Logic and Design, Fifth Edition, Comprehensive 4 Understanding Relational Database Fundamentals Data hierarchy: Smallest unit of data is the character Characters form fields Fields form records Records form files Database : Group of files needed to support an organization Files in a database are called tables
Background image of page 4
Programming Logic and Design, Fifth Edition, Comprehensive 5 Understanding Relational Database Fundamentals (continued) Data in tables can be arranged in rows and columns Each column represents a field Each row represents a record Figure 14-1 A telephone book table
Background image of page 5

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

View Full DocumentRight Arrow Icon
Programming Logic and Design, Fifth Edition, Comprehensive 6 Understanding Relational Database Fundamentals (continued) Primary key (or key ): Uniquely identifies a record May be composed of one or multiple columns Compound key : constructed from multiple columns Also known as composite key
Background image of page 6
Programming Logic and Design, Fifth Edition, Comprehensive 7 Understanding Relational Database Fundamentals (continued) Database management software allows you to: Create table descriptions Identify keys Add, delete, and update records within a table Sort records by different fields Write questions to select specific records for viewing Write questions to combine information from multiple tables Relational database : tables with related columns Create reports Secure the data
Background image of page 7

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

View Full DocumentRight Arrow Icon
Programming Logic and Design, Fifth Edition, Comprehensive 8 Creating Databases and Table Descriptions Creating a database requires planning and analysis What data to store How to divide the data between tables How the tables will interrelate Designing a database table: Required columns And how they are named Type of data in each column
Background image of page 8
Programming Logic and Design, Fifth Edition, Comprehensive 9 Creating Databases and Table Descriptions (continued) Figure 14-2 Customer table description
Background image of page 9

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

View Full DocumentRight Arrow Icon
Programming Logic and Design, Fifth Edition, Comprehensive 10 Identifying Primary Keys Identify a column or combination of columns to be the primary key Values of primary keys must be unique, such as: Student ID number Inventory part number Social Security number
Background image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 50

01969_PPT_ch14 - Programming Logic and Design Fifth...

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

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