COMPAI Online Quiz #3

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