Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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




  1. 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?
  2. 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?
  3. "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?).
  4. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals of Cost Accounting

Authors: William Lanen, Shannon Anderson, Michael Maher

3rd Edition

9780078025525, 9780077517359, 77517350, 978-0077398194

More Books

Students also viewed these Databases questions

Question

b. Who is the program director?

Answered: 1 week ago