4. Databases & Information Management Flashcards
Can you explain the data hierarchy and traditional file processing?
Answer
Explain some issues with traditional file processing. Mention all of them please
Answer
Define a relational DBMS and explain how it organizes data - Give an example not from the textbook - be technical here
Answer
What is the function of a DBMS?
Answer
What is primary key and foreign key?
Answer
List and describe the three operations of relational DBMS
Answer
Explain what normalization is and Entity-Relationship diagrams - What are they important, do you have some examples?
Answer
What is non-relational databases and databases in the cloud?
Answer
What is querying and reporting?
Answer
Explain Big Data? How to orgs use it, give an example
Answer
Explain the infrastructure of BI - Come up with all of them and examples what they all do
Answer
What is data warehouses?
Answer
Analytical applications related to the database? Can you give some examples here and explain?
Answer
What is the relation between the web and databases?
Answer
What are the major things that is important related to the administration of data and keep up policies and quality?
Answer
What is SQL - explain the function of it…
Answer
What are the main principles of database design?
Answer
What is the importance of information policies to manage data?
Answer
Explain in details how the relational DBMS looks like. Be very specific here. Examples of how it can be used
Answer
What are some challenges with big data?
Answer
Blockchain database
Answer
Data mart and data lake
Answer
Sentiment analysis software
Answer
Data quality audit and data cleansing
Answer
Basic Operations:
Select – Join – Project
Answer
Analytical platforms
Data bases and the web
Users accessing an organizations internal database through the web
Ensuring data quality - talk about this
Multicore processor
Apps and mashups
