Schema for the Title Table

title_id	name	price	edition
1	Programming Perl	24.99	4th

Four columns
title_id is the primary key
name and edition are strings
price is a floating point value
No field is allowed to be NULL

Schema for the Transaction Table

transact_id	title_id	number_transacted	cust_name	cust_address	card_type	card_number
1	101	3	Fred Smith	123 Main Street, Anytown, AnyState 00000	Visa	123456789

Seven columns
transact_id is the primary key
cust_name, cust_address, and card_type are strings
title_id, number_transacted, and card_number are numbers
No field is allowed to be NULL

Determining the Schema of a Database

Sadly, there is no vendor-neutral way to query a database about its schema. However, for Microsoft Access, you can run the GUI and look at each table to determine what columns it has.

Review

Should we allow some of the fields to be NULL?