Recent content by ratchet

So I re-configured my tables and set out as follows, and linked them accordingly in their relationships. Customer:CustomerID(PK)Suburb(FK).. details SuburbuburbID(PK),Suburb,Code Item:ItemID(PK),Title,PlatformID(FK),Quantity Platform:PlatformID(PK),Platform,GenreID(FK) Genre:GenreID(PK),Genre...

Just I wondering if my table requires a Primary key, when the table already has a foreign key ? Here's an Items table which contains a primary key. Now I want to link this table to 2 separate tables.. Items:ItemsID(PK),Title(FK) Movies:Title(FK), Category, Type(DVD,VHS,Bluray)...

Yes, no anyone? Just really wanting to know If I'm in the right direction, and if not point out the flaws in my tables - the unnecessary stuff.

So I'm a beginner and am struggling with the tables. I need to have at least 7 and based on what the client wants i.e as much Customer info, keep track on what movies and games(also their genre) were rented, quantities hired on what dates,and sales income on each date. Also determine how many...