for some attribute like (GameType primary key of Games), should I use GameType TEXT PRIMARY KEY AUTOINCREMENT
Fantastic news! We've Found the answer you've been seeking!
Question:
- for some attribute like (GameType primary key of Games), should I use GameType TEXT PRIMARY KEY AUTOINCREMENT or GameType INTEGER PRIMARY KEY AUTOINCREMENT or something else?
- in the many-to-many relation what should i do with the FK(foreign key) ? like they are going to get each other's FK?
- "Game-Publisher's (2 entities) relation has an attribute (payment)", should i build a new table called Invest, with FK from Game and Publisher or just a table with one attribute called payment(primary key?).
- for Primary key and Unique keys in the ERD, Are they all underlined(single underline) in the chart?
Related Book For
Fundamentals of Cost Accounting
ISBN: 978-0077398194
3rd Edition
Authors: William Lanen, Shannon Anderson, Michael Maher
Posted Date: