Specific Help For Accessing The Database

Database content

You will use a single table from a mySQL database. The single database table (which is not well designed! - can you see why?) is designed to make the queries for this practical simple.

The database table contains 10 columns:

Field	Type
pdb_code	varchar(4)
name	varchar(255)
date	date
description	text
source	varchar(255)
authors	text
resolution	float
exp_method	enum('XR','NM','EM','SD','ND','FL','FD','TM')
n_chains	smallint(6)
n_residues	smallint(6)

Of these you will use 5:

pdb_code - the PDB code for a protein structure
name - a text description of the protein
source - the species from which the protein is opbtained
resolution - the resolution of the crystal structure
description - an extended text description of the protein

The database source

Database name:	`dbname`	biodb
Database host:	`dbhost`	pandora
Database username:	`username`	Ask a demonstrator!
Database password:	`password`	Ask a demonstrator!

Continue