Introduction to Data Analysis

A set of flashcards covering key concepts from the Introduction to Data Analysis lecture, focusing on data forms, databases, DBMS, and data types.

What can data be considered as?

The smallest units of factual information that can be used as a basis for calculation, reasoning, or discussion.

What are the two primary forms of gathered data?

Structured and Unstructured data.

What is structured data?

Data that is well-organized and accurately formatted, typically found in relational databases.

What is unstructured data?

Data that doesn’t have any pre-defined structure, including images, text files, and multimedia.

What are some examples of data types?

Text, Numbers, Boolean, and Datetime.

What is a Database?

An organized collection of structured information or data, typically stored electronically.

What function does a Database Management System (DBMS) serve?

It interacts with the database, applications, and users to capture and analyze data.

What are the two main types of DBMS mentioned?

Relational DBMS and NoSQL DBMS.

Why is using a DBMS important?

It ensures data integrity, security, control, and efficient query processing.

What is database design?

The structure a database uses to plan, store, and manage data.

How do databases compare to file systems?

Databases consist of logically related data stored in a single repository, eliminating inconsistencies and providing structured access.

What are the different types of databases mentioned?

Single-user vs. Multiuser, Centralized vs. Distributed.

What are the main functions of a DBMS?

Data dictionary management, data storage management, security management, and data integrity management.

What are the three types of relationships in Conceptual Models?

One-to-one (1:1), One-to-many (1:M), Many-to-many (M:N).