2026 QUESTIONS WITH ANSWERS
GRADED A+
◉What type of relationship do a customer table and an invoice table
have?. Answer: One-to-many
◉Which of the following statements about an index file is (are)
true?. Answer: All of these statements about an index file are true.
◉What is a primary key?. Answer: One or a group of data elements
that uniquely identifies a record in a table.
◉Which of the following represent (s) a virtual data element?.
Answer: All of these are virtual data elements.
◉What is meant by the logical structure of a database?. Answer: The
way the data are thought about, or viewed, by users.
◉What would be a likely primary key for the customer table?.
Answer: Customer code
, ◉The implementation of a database begins by defining which of the
following?. Answer: Database schema
◉Which of the following data elements are not included in a sales
invoice?. Answer: Sales representative name, sales representative
commission, sales representative discount
◉In the REA framework, relationships among entities can be which
of the following?. Answer: All of these can be relationships in the
REA framework
◉What does an ellipse represent in an entity-relationship diagram?.
Answer: Attribute
◉What would be a likely primary key for the vendor table?. Answer:
Vendor code
◉A method for arranging data elements in a way that reduces
anomalies is referred to as which of the following?. Answer:
Normalization
◉Which of the following statements regarding normal form is not
correct?. Answer: The third normal form places all redundant key
fields in separate tables.