Copyright 2014 Pearson Education, Inc.

Copyright © 2014 Pearson Education, Inc.Chapter 1

Outcomes • Define relational databases • Understand the position of relational databases in the history of databases • Identify major relational database management systems • Identify main characteristics of relational databases • Understand SQL’s role in relational database • Recognize some indications of where a database could be useful • Define a statement of work for a given database scenario

Outline

• Database Overview
• What is a Database?
• Flat File Databases
• Delimited
• Fixed width
• Spreadsheets
• Hierarchical Databases

II. Relational Databases

• All data is stored in tables
• Each row has a primary key

(Hands-On Database 2e Steve Conger ) (Solution Manual, For Complete File, Download link at the end of this File) 1 / 4

1-2 Copyright © 2014 Pearson Education, Inc.

• Foreign Keys

D. SQL

III. Relational Management Systems

• Definition
• Functions
• Some Popular RDMSs

IV. Opportunities for Database Development

• Initial Interview
• Being Prepared
• Listening to the Client
• Focusing on the Broad Topics

VI. Identifying the Big Topics

• Identify nouns
• Group by themes
• Entities and Attributes

VII. Statement of Work

• History
• Scope
• Objectives
• Tasks and Timeline

VIII. Documentation

• Importance
• Documenting the Structure
• Documenting the Process
• Project Notebook 2 / 4

1-3 Copyright © 2014 Pearson Education, Inc.IX. Things We Have Done

• Things to Look Up

XI. Vocabulary XII. Practices XIII. Scenarios

Vocabulary

• Attribute l. Things that define aspects of entities
• Foreign Key i. This key is the primary key repeated in another

table to create a link between the tables.

• Statement of Work n. A document including the scope, objectives,

and timelines for a given project

• Primary Key h. This key uniquely identifies each row in the

table.

• Data Integrity f. Refers to the accuracy and the correctness of

the data in the database

• Redundancy g. Refers to storing the same data in more than

one place in the database

• Delimited Files d. These files have some sort of character

separating columns of data. The delimiter is often a comma or tab, but can be any non-alphanumeric 3 / 4

1-4 Copyright © 2014 Pearson Education, Inc.character.

• Relational Database a. A type of database that uses “relations,” tables,

to store and relate tables

• Entity k. Something that the database is concerned with,

about which data can be stored 10.Relational Design b. The process of organizing data into tables or entities and then determining the relations among them

• SQL c. The language relational databases use to create

their objects and to modify and retrieve data

• Constraints m. Limits on what the database will do
• Fixed Width Files

• Statement of Scope
• Files where the length in characters of each

column is the same

• A short statement of one or more paragraphs

that says in clear, but general, terms what the project will do

Things to Look Up The Things to Look Up section is meant to spur discussion. Many of the questions do not have precise answers. All links provided can change or go away.

• Look up Codd’s twelve rules. Choose one of the rules to explain to your fellow students.
• / 4