Chap 1,2,3

Question 1

Database:

Answer 1

A collection of organized data used for storage, management, and retrieval.

Question 2

Forms

Answer 2

Online pages for user input, including checkboxes, text boxes, and drop-down lists.

Question 2

DBMS (Database Management System):

Answer 2

Software used to create, manage, and secure databases (e.g., MySQL, Access).

Question 3

Tags:

Answer 3

Electronic devices used to identify and track items, often using RFID technology.

Question 4

RFID (Radio Frequency Identification):

Answer 4

Tiny chips that store and transmit information to readers for database entry.

Question 5

Digital Sensors:

Answer 5

Devices that detect environmental data (e.g., temperature, light) and transmit it digitally.

Question 6

Cookies

Answer 6

Small text files stored by web browsers to identify users and personalize web pages.

Question 7

Transaction Tracking:

Answer 7

Recording transaction details, like store location, payment info, and employee involvement.

Question 8

Location-Based Data:

Answer 8

Data that provides location info, such as maps, traffic patterns, and GPS tracking.

Question 9

LBS (Location-Based Services):

Answer 9

Software apps that use location data for services like navigation and ride-sharing.

Question 10

Data Warehouse:

Answer 10

A central storage system for historical data from multiple databases, used for analysis.

Question 10

Normalization:

Answer 10

Organizing database structure to reduce redundancy and improve efficiency.

Question 11

ETL (Extract, Transform, Load):

Answer 11

The process of transferring data from sources to a warehouse for analysis.

Question 12

Data Mining:

Answer 12

Analyzing large datasets to find patterns and trends for decision-making.

Question 13

Data Extraction:

Answer 13

Selecting relevant data from large datasets for analysis

Question 14

Pattern Recognition:

Answer 14

Identifying trends and relationships between data points.

Question 15

Data Integrity

Answer 15

Ensuring data is accurate, consistent, and reliable throughout its lifecycle.

Question 16

Data Validation:

Answer 16

Checking data accuracy and format before it is entered into a database.

Question 17

Data Verification:

Answer 17

Manually confirming that database entries are correct.

Question 18

Access Control:

Answer 18

Restricting database access based on user roles and passwords.

Question 19

Parallel Data Sets:

Answer 19

Backup copies of databases used to detect corruption or data loss.

Question 20

Field:

Answer 20

A single piece of information about an item or person (e.g., Name, Age).

Question 20

Primary Key:

Answer 20

A unique field used to identify each record in a table.

Question 21

Data Integrity:

Answer 21

Ensuring accuracy, consistency, and reliability of data throughout its lifecycle.

Question 21

Record

Answer 21

A collection of related fields representing one entry (e.g., a student’s info).

Question 22

Data Security:

Answer 22

Protecting data from unauthorized access, corruption, or loss.

Question 22

Data Redundancy:

Answer 22

Storing the same data in multiple places, increasing size and errors.

Question 23

Data Independence:

Answer 23

Separation between data and the application using it.

Question 24

Database Administrator:

Answer 24

Manages user access, database maintenance, and security

Question 24

Database Developer:

Answer 24

Designs and develops the structure of a database.

Question 25

End User:

Answer 25

Individuals who interact with the database, like teachers or customers.

Question 26

Insertion Anomaly:

Answer 26

Inability to add data without other related data (e.g., can’t add a student without an enrollment date).

Question 26

Modification Anomaly:

Answer 26

Changing one piece of data requires updating multiple records, risking inconsistencies.

Question 26

Deletion Anomaly:

Answer 26

Deleting one record accidentally removes related important data.

Question 26

Data Redundancy:

Answer 26

Storing the same data in multiple places, causing inefficiency

Question 27

Normalization:

Answer 27

The process of organizing data to reduce redundancy and anomalies.

Question 27

Third Normal Form (3NF):

Answer 27

Remove transitive dependencies; non-primary fields should not depend on other non-primary fields.

Question 27

First Normal Form (1NF)

Answer 27

Ensure each field contains only one value (atomicity).

Question 28

Second Normal Form (2NF)

Answer 28

Remove partial dependencies; every field must depend on the whole primary key.

Question 29

Alternative Key:

Answer 29

A unique field that could act as a primary key but isn’t chosen as one.

Question 30

Foreign Key:

Answer 30

A field in one table that links to the primary key of another table.

Question 31

Composite Key:

Answer 31

A combination of multiple fields used together to uniquely identify a record.

Question 32

Mobile Technology:

Answer 32

Portable computing devices like smartphones, tablets, and laptops.

Question 33

Location-Based Computing:

Answer 33

Software that adjusts based on the user’s location (e.g., GPS navigation).

Question 34

Advantages of Mobility:

Answer 34

Portability, internet access anywhere, and convenience for tasks like emails and banking.

Question 34

Disadvantages of Mobility:

Answer 34

Limited processing power, smaller storage, and shorter battery life.

Question 35

Storage Type:

Answer 35

SSDs are faster than HDDs for reading and writing data

Question 35

Cooling System:

Answer 35

Prevents overheating, which can slow down performance

Question 35

CPU (Central Processing Unit)

Answer 35

The brain of the computer, responsible for processing instructions.

Question 35

RAM (Random Access Memory):

Answer 35

Temporary storage that affects multitasking speed.

Question 36

Output Devices:

Answer 36

Devices that display results, like monitors, printers, and speakers

Question 36

GPU (Graphics Processing Unit):

Answer 36

Handles graphics and video rendering.

Question 36

Input Devices:

Answer 36

Tools for user interaction, like keyboards, mice, and scanners.

Question 37

Storage Devices:

Answer 37

Used to save data, including SSDs, HDDs, and flash drives

Question 37

I/O Devices:

Answer 37

Dual-purpose devices like touchscreens and game controllers.