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
- 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?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get StartedRecommended Textbook for
Fundamentals of Cost Accounting
Authors: William Lanen, Shannon Anderson, Michael Maher
3rd Edition
9780078025525, 9780077517359, 77517350, 978-0077398194
Students also viewed these Databases questions
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
Question
Answered: 1 week ago
View Answer in SolutionInn App