Effective CISSP Questions

You are designing tables using a relational database to store customer orders. Which of the following is not a good practice to enforce database integrity? (Wentz QOTD)
A. Limit order total price to the decimal data type
B. Save OrderLineItems as a table related to its parent table, Orders
C. Store comma-separated values (CSV) in a cell to reduce relationships
D. Configure the primary key (PK) as an auto-increment field in each table

Read more of this post

Wentz Wu | December 25, 2021 at 4:33 pm | Categories: QOTD, Technology, 每日一題 | URL: https://wp.me/p2X0VJ-9ip
Comment