6. Accounting Information Systems
Database Design — Quiz
Test your understanding of database design with 5 practice questions.
Practice Questions
Question 1
Which of the following best describes the primary objective of Third Normal Form (3NF) in database normalization for accounting data?
Question 2
In an Entity-Relationship (ER) diagram for an accounting system, if a 'Customer' entity can have multiple 'Invoices', but each 'Invoice' belongs to only one 'Customer', what is the most appropriate cardinality for this relationship?
Question 3
Consider an accounting database with a table named 'Employees' that includes columns 'EmployeeID', 'EmployeeName', 'DepartmentID', and 'DepartmentName'. If 'DepartmentName' is solely determined by 'DepartmentID', and 'DepartmentID' is not part of the primary key, which normal form violation is present if the table is not in 3NF?
Question 4
Which SQL command is used to retrieve data from one or more tables based on a specified condition, allowing for filtering of rows?
Question 5
What is the primary purpose of a data dictionary in the context of designing an accounting database?