Copyright 2012 Pearson Education, Inc. publishing as Prentice Hall

Copyright © 2012 Pearson Education, Inc. publishing as Prentice Hall 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 1e Steve Conger) (Solution Manual, For Complete File, Download link at the end of this File) 1 / 4

2 Copyright © 2012 Pearson Education, Inc. publishing as Prentice Hall

• 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

3 Copyright © 2012 Pearson Education, Inc. publishing as Prentice Hall 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 j. A short statement of one or more paragraphs

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

• 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 3 / 4

4 Copyright © 2012 Pearson Education, Inc. publishing as Prentice Hall comma or tab, but can be any non alphanumeric 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 e. Files where the length in characters of each

column is the same Things to Look Up The Things to Look Up section is meant to spur discussion. Many of the questions do not have precise answers. World Wide Web links are volatile and may not persist. They are meant only to suggest possible responses.

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

Codd’s 12(13) rules are available in many places but perhaps the easiest place to access them is at http://en.wikipedia.org/wiki/Codd's_12_rules. The student can choose any one of them and discuss it briefly. For example, Rule 1, the information rule, requires that all data, even data about data such as column names and data types, must be stored in tables. A student might note that this makes all the

• / 4