Designing Databases

This week's prac was about databases. In working through the idea of a video store database, here's a possible solution:

Id	Name	Address	Telephone No	Driver’s Licence No	Email address	Password
0001	Amber Jones	23 Bla bla la	01283471050	12893140509384	calksjdopfwn@nsfaadf.com	secret

Id	Title	Copy No	Year	Genre	Actors	Release to shelf date	Current rental code	Current status
0001	The Negotiator	1	2009	Action	Joe Blow	3.4.2010	Newrelease	On shelf

Id	Rental Period (days)	Daily price within rental period	Daily price overdue	Auto assign at x weeks after release to shelf date
Newrelease	1	5.00	5.00	0
Weekly	7	1.00	0.50	16

Customer id	Title id	Date out	Date in
0001	0001	6.4.10	7.4.10