Answered step by step
Verified Expert Solution
Question
00
1 Approved Answer
We will need a table to keep track of user clicks . Below is a rough structure of the table, but it is incomplete in
We will need a table to keep track of user clicks. Below is a rough structure of the table, but it is incomplete in the following ways:
There are no primary keys,
More columns may need to be added,
The data types are not all specified.
userID: long | sessionID: __________ | timestamp: dateTime | clickedPoint: coordinate | missionID: _________ | isHit: _________ | _________: _________ |
100 | 4356 | 10/12/2015::14:15:09 | (4,8) | 13 | yes | _________ |
101 | 3241 | 10/23/2015::14:15:19 | (20,5) | 18 | no | _________ |
102 | 4537 | 11/4/2015::14:15:20 | (17,43) | 21 | no | _________ |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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 Started