Sample Midterm

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: entities. B) relationship, economic, accounting A) resource, economic, agent C) resource, event, agent D) relationship, event, accounting 14) M:N relationships must be implemented A) as separate tables. C) Both A and B B) with concatenated primary keys. D) Neither A nor B 2 15) How many tables are needed to implement an REA data model that has five distinct entities, seven M:N relationships, two 1:1 relationships, and three 1:N relationships in a relational database? A) 5 B) 7 C) 12 D) 17 SHORT ANSWER. Write the word or phrase that answers the question. (20 points total - 10 points per question) 16) Briefly explain an economic duality relationship. 17) Briefly explain the key difference between optional minimum cardinality and mandatory minimum cardinality. REA DATA MODEL. Write your answer in the space provided. SQL. Write queries using the following ʹCyclone Fall Color TShirt Inc.ʹ service acquisition (expenditure cycle) database. (27 points total - 9 points per question) 3 Cash AccountNo, AccountType, BankName, AccountBalance CashDisbu...
View Full Document

This document was uploaded on 03/13/2014.

Ask a homework question - tutors are online