A small online bookstore needs a system to efficiently store, organize, and retrieve information about its customers (names, addresses), the books it sells (titles, prices, descriptions), and individual orders placed by customers (which customer bought which book). This system needs to link customers to their orders and orders to the books they contain. Which technology is primarily designed for this purpose, using tables with rows, columns, and keys to link related information?

Question

BlackTom AI · Accepted Answer

The scenario describes needing to store and organize structured information about customers, books, and orders, with explicit links between customers and their orders and between orders and the books they contain. This requirement is a classic use case for a database that stores data in tables (rows and columns) and uses keys (e.g., primary and foreign keys) to link related records across tables.

Option 1: A business intelligence digital dashboard. This is primarily a visualization/analysis tool that presents data and metrics extracted from underlying sources; it does not serve as the primary storage mechanism or the relational backbone described in the scenario.

Option 2: Data visualization tools. Similar to dashboards, these tools help display data but are not the core system for storing and linking transactional records like customers, orders, and books.

Option 3: A database. This is the correct choice because databases are designed to store data in structured tables with columns and rows and support relationships through keys, enabling efficient storage, retrieval, and linking of related information (customers to orders, orders to books).

Option 4: A data warehouse. Data warehouses are optimized for analytical processing and reporting over large historical datasets, often integrating data from multiple sources. They are not typically the primary transactional store for day-to-day operations that require linking individual customers, orders, and books in a normalized, operational database.

In summary, the described needs align with a database's capabilities to model entities and relationships using tables and keys for efficient access and relational integrity.

查看解析

登录即可查看完整答案

类似问题

In the logical design process, rows are commonly referred to as _________.

What best defines a Foreign Key?

Which of the following database technologies organize data into a collection of tables?

True or False: Relational databases are non-ACID compliant and lack predefined schemas.

Consider the Relational Model. Which of the following statements is false.

Which of the following is true about a tuple?

Which of the following is not accurate?

Which system allows users to create, read, update, and delete data in a relational database?

更多留学生实用工具

考试浏览器助手

风格化写作助手

论文查重助手

文献引用助手

课堂转译助手

课堂笔记助手

Quiz搜索助手

学校历年真题

智能刷题助手

智能匹配练习

希望你的学习变得更简单