Which of the following is most likely a foreign key in the Order Goods table?
A.
Order Date
B.
Customer #
C.
Purchase Order #
D.
Vendor #
Solution:
Purchase order is most likely a foreign key in the order goods table.
Hence option c is correct.
Which of the following is most likely a foreign key in the Order Goods table? A....
Which of the following describes referential integrity? A. A Primary Key of a relational table must not contain a null value B. One fact must not be in multiple places C. The value for a foreign key attribute must either be null or match the one of the data value of that attribute in the table in which the attribute is a primary key D. Referential Integrity is a principle that prevents the use of redundancy, avoids null values and...
What does Symbol C most likely depict? 5. Sales Order a. b. Original Purchase Order Receiving Report Vendor Invoice Your Answer: What does Symbol D most likely depict? 6. Sales Order а. b. Original Purchase Order Receiving Report C. Vendor Invoice d. Your Answer: What does Symbol E most likely depict? 7. Matching of documents а. Approval of recording of purchase and payment of payable b. Data entry of purchase data C. Update of accounts payable file d. Your Answer:...
A table in a database has the following fields. Which is most likely the primary key? Boat Name, Boat Location, Boat ID Number, Owner Last Name Boat ID Number Boat Location Boat Name Owner Last Name
Which of the following will most likely cause a nation's currency to appreciate on the foreign exchange market? O a. A decrease in domestic interest rates O b. An increase in foreign interest rates O c. Stable domestic prices while the nation's trading partners are experiencing 10 percent inflation O d. Domestic inflation of 10 percent while the nation's trading partners are experiencing stable prices
Which of the following firms is most likely to be a monopolist? a. The clothing retailer with the best location in a mall. b. The grocery store in a large city closest to the central business district. c. The most popular hot dog vendor on a city street corner. d. The one grocery store in a small town.
Multiple Choice A) The Product ID will be included as a foreign key in the Sales Orders table. B) The Sales Order ID will be included as a foreign key in the Products table. C)The Quantity Ordered field will be included as a foreign key in the Products table. d) A new table will be created that contains both Sales Order ID and Product ID as its composite primary key. * C Search Textbook Solutions x C Multiple Choice A)...
Which one of the following companies is most likely to use job order costing? A. a law firm B. a soft drink company C. a gold refinery D. a surfboard manufacturer
For our Expenditure (Purchases-Payments) cycle, we want to store the following data about our purchases of inventory: item number date of purchase vendor number vendor address vendor name purchase price quantity purchased employee number employee name purchase order number description quantity on hand extended amount total amount of purchase a. Semantically create a conceptual design (entity-relationship diagram) with max cardinalities. b. Design a set of properly normalized relational tables to store the data, using the following format: Table Name Primary...
SQL queries and procedures TABLE: Employees Business Rules: EmployeeID is defined as the primary key. Address has been denormalized to include City and State for performance reasons. DeptNbr is a foreign key that references DeptNbr in the Department table Manager is a foreign key that references EmployeeID in the Employees table Data Structure: (EmployeeId, LastName, FirstName, Street, City, State, Zip, DateOfHire, DateOfBirth, JobTitle, Salary, DeptNbr(fk), Manager(fk)) TABLE: Department Business Rules: DeptNbr is defined as the primary key. Data Structure: (DeptNbr,...
Which of the following is least likely to be a major criterion in vendor selection? A credit rating of the vendor B prices of goods C ability to deliver on time D quality of goods