AI + Databases

Question 1

Artificial Intelligence Definition

Answer 1

Science and engineering of making intelligent computer programs capable of performing tasks that require subtleties of judgement, interpretation and generalisation that we associate with human intelligence

Question 2

Narrow AI

Answer 2

AI systems built to perform a single task without any skills that can be transferred to other tasks

Question 3

AGI and definition

Answer 3

Artificial General Intelligence. AI systems that can autonomously solve a variety of complex problems in a variety of different domains and learn and adapt autonomously

Question 4

Generative AI

Answer 4

Artificial Intelligence technology that automatically generates new/original content in response to prompts typed in by the user. Should be used with caution as not always correct(phenomena called hallucination)

Question 5

Generative AI outputs

Answer 5

Text
Images
Videos
Music
Software code

Question 6

Computer vision percentages meaning

Answer 6

Level of confidence returned by model that the image has been correctly classified as the associate label.

Question 7

Applications of computer vision

Answer 7

1. Self driving cars to detect dangers and reduce accidents
2. Track endangered species
3. Early detection of diseases through medical imaging
4. Facial recognition enhances security by tracking individuals

Question 8

Database definition

Answer 8

Collection of structured data organised in a way such that the data can be easily and efficiently retrieved and maintained

Question 9

Record definition

Answer 9

(Aka tuple)
Single row of data containing related elements

Question 10

Primary key

Answer 10

a column in a relational database table that’s distinctive for each record

Question 11

Foreign Key

Answer 11

a column in one table that references the primary key of another table

Question 12

Machine learning societal benefits

Answer 12

1. Early detection of diseases
2. Recommendations for entertainment (movies, tv, music)
3. Facial recognition in security systems
4. Online shopping recommendations

Question 13

bias

Answer 13

a systematic error or prejudice within a model that leads to skewed or unfair predictions. If the data on which the algorithm makes its decision contains bias, the algorithm’s output will also be biased.

Question 14

Raw data

Answer 14

data that hasn’t been processed, coded, formatted, or yet analyzed for useful information.

Question 15

Methods of cleaning data

Answer 15

1. Removing/ replacing “NA” values
2. Checking/ removing/ replacing outlier values
3. Changing strings to integers/ floating point numbers