Search results

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)...

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...