Designing a Relational Database
Download
Report
Transcript Designing a Relational Database
Designing a Relational
Database
13.4
Page 13-4
A database should be created
based on a design
Three steps
Determine what information should be stored
Know the purpose of your database
Divide information into named tables
Grouping the related information
Define fields and determine the primary key
Field names (p 13-2)
Primary key given to fields that cannot be
duplicated (p 13-4)
Creating a new relational database
You MUST name the database
BEFORE you save it.
Start
Programs, Microsoft Office Access
Create new file, blank database
Navigate to YOUR folder
Give the database a name
Create
Database Window (13-6)
Parts of the screen
Toolbar – contains buttons that represent
different actions
Database Window – used to display and
create objects for the open database
Buttons – used to display database objects
and icons
Window toolbar – buttons that represent
different actions
See picture 13-6
Creating tables
Click tables
Double-Click create
table in design
view
Create tables
Type in a field name
Select the field type
Type a description IF NECESSARY
Field Properties
Once you have entered a field
name, field properties options
are available
Primary Key
To complete a table, a primary key
must be designated.
Put your insertion point inside the
field name
Click the primary key button on the
toolbar
That field is now the primary key
Save and Close the table
Click the Save button on the toolbar
Name the table
Close the table (little X)
Table is now ready for
you to open and input
data
Assignment
Complete Practice 1 on page 13-4
Yes, you must write down and plan the
database
Sample database planning sheets are on
the center tables
Complete Practice 2 on page 13-8-11
Read each step carefully
Save with correct names