4. Databases & Information Management

Question 1

Can you explain the data hierarchy and traditional file processing?

Answer 1

Answer

Question 2

Explain some issues with traditional file processing. Mention all of them please

Answer 2

Answer

Question 3

Define a relational DBMS and explain how it organizes data - Give an example not from the textbook - be technical here

Answer 3

Answer

Question 4

What is the function of a DBMS?

Answer 4

Answer

Question 5

What is primary key and foreign key?

Answer 5

Answer

Question 6

List and describe the three operations of relational DBMS

Answer 6

Answer

Question 7

Explain what normalization is and Entity-Relationship diagrams - What are they important, do you have some examples?

Answer 7

Answer

Question 8

What is non-relational databases and databases in the cloud?

Answer 8

Answer

Question 9

What is querying and reporting?

Answer 9

Answer

Question 10

Explain Big Data? How to orgs use it, give an example

Answer 10

Answer

Question 11

Explain the infrastructure of BI - Come up with all of them and examples what they all do

Answer 11

Answer

Question 12

What is data warehouses?

Answer 12

Answer

Question 13

Analytical applications related to the database? Can you give some examples here and explain?

Answer 13

Answer

Question 14

What is the relation between the web and databases?

Answer 14

Answer

Question 15

What are the major things that is important related to the administration of data and keep up policies and quality?

Answer 15

Answer

Question 16

What is SQL - explain the function of it…

Answer 16

Answer

Question 17

What are the main principles of database design?

Answer 17

Answer

Question 18

What is the importance of information policies to manage data?

Answer 18

Answer

Question 19

Explain in details how the relational DBMS looks like. Be very specific here. Examples of how it can be used

Answer 19

Answer

Question 20

What are some challenges with big data?

Answer 20

Answer

Question 21

Blockchain database

Answer 21

Answer

Question 22

Data mart and data lake

Answer 22

Answer

Question 23

Sentiment analysis software

Answer 23

Answer

Question 24

Data quality audit and data cleansing

Answer 24

Answer

Question 25

Basic Operations:

Select – Join – Project

Answer 25

Answer

Question 26

Analytical platforms

Question 27

Data bases and the web

Answer 27

Users accessing an organizations internal database through the web

Question 28

Ensuring data quality - talk about this

Question 29

Multicore processor

Question 30

Apps and mashups