Data in Super Video System
			~~~~~~~~~~~~~~~~~~~~~~~~~~
			    3rd Normal Form
			    ~~~~~~~~~~~~~~~

 Order Data
 ~~~~~~~~~~
Resolve Partial Key of Order to New Primary Key Order Number.
Orders:
	Order Number	Primary Key
	Member Number	Foreign Key
	Quantity
	Total Cost
	Date Ordered
	Credit Balence after order

Extract Dependent Data from Partial Keys:-
Members:
	Member Number	Primary key
	Sort Code       Foreign key
	Title
	First Name
	Middle Initials
	Surname
	Address
	PostCode
	Country
	DoB
	Telephone
	e-mail Address
	Credit Limit

Extract Dependent Data from Non Keys:-
Bank:
	Sort Code	Primary Key
	Bank Name
	Bank Address
	Post Code
	Country
	Telephone Number

Repeated Data extracted form Un-Normalised Data:
There are no Dependencies of Compound Keys.
The compound Key is best resolved to a new Primary Key
Catalog Number.
Catalogue:
        Catalouge Number 	Primary Key
	Title         	
	Studio          
	Release Date    
	URL of Review
	Unit Price
	Genre
	BBFC Certificate
	Duration
cast:
	Lead Actor
	Lead Actress
	Director
	Producer
	Supporting Cast
	SFX
	sound