Database Structure

i had just a quick question about database structure. In order to maintain
referential integrity in a database how would i set up a database in
Microsoft Access 2007 for a DVD Movie Store. All the while, allowing tables
to be concise enough to allow for tables to be filled in by Genre (Comedy,
Action, Suspense, & etc). Also to allow for more movies to be added in
alphabetical order without messing up the ascending ID numbers assuming ID
numbers would be necessary. Maybe you could send me a typed up diagram of how
it should be set up to be accurate to Database Management Standards. I would
really appreciate any light you can shed on this if you would? I would
appreciate it if anyone would create the structure in Access and then email
it to me at . Thank you in advance.