NEW
Font size
WorksheetsCOMPAI Online Quiz #3
Total questions: 20
Worksheet time: 20mins
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be an entity for Customers in the ERD.
TRUE
FALSE
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be an entity for Products in the ERD.
TRUE
FALSE
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be an entity for Orders in the ERD.
TRUE
FALSE
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be an entity for Shopping Carts in the ERD.
TRUE
FALSE
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be a one-to-many relationship between Customers and Orders.
TRUE
FALSE
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be a many-to-many relationship between Products and Orders.
TRUE
FALSE
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be an attribute in the Orders entity to represent the order date.
TRUE
FALSE
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be a many-to-many relationship between Customers and Products to represent products in their shopping cart.
TRUE
FALSE
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be an attribute in the Products entity to represent the product price.
TRUE
FALSE
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items.
Question: There will be an entity for Order Items in the ERD to represent the products in each order.
TRUE
FALSE
What is the main purpose of the online store's database?
To manage employee accounts
To store customer information and order data
To track inventory levels
To create marketing campaigns
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following entities will not be included in the ERD for the online store's database?
Customers
Products
Orders
Shopping Carts
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. What kind of relationship exists between the Customers and Orders entities?
One-to-one
One-to-many
Many-to-one
Many-to-many
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. What kind of relationship exists between the Products and Orders entities?
One-to-one
One-to-many
Many-to-one
Many-to-many
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following is an example of an attribute that would be included in the Orders entity?
Product ID
Customer Name
Order Date
Order Total
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following is an example of an attribute that would be included in the Products entity?
Order ID
Product Price
Customer ID
Order Quantity
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following is an example of an attribute that would be included in the Customers entity?
Product Name
Customer Address
Order Quantity
Order Total
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following represents the correct cardinality for the relationship between Customers and Orders?
One-to-one
One-to-many
Many-to-one
Many-to-many
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following represents the correct cardinality for the relationship between Products and Orders?
One-to-one
One-to-many
Many-to-one
Many-to-many
Scenario: The online store sells various products such as electronics, clothing, and accessories. The store has customers who can create accounts, add items to their shopping carts, and place orders. The database will have tables for customers, products, orders, and order items. Which of the following entities would be used to represent the products in each order?
Customers
Products
Orders
Order Items
