Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

14) Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice? Invoice

image text in transcribed

image text in transcribed

image text in transcribed

14) Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice? Invoice Number 34567 INVOICE Alpha Omega Electronics 2431 Bradford Lane St. Louis, MO 63105-2311 Sold To: Ship To: Hardware City 35 Appliance Way Phoenix, AZ 85201 Hardware Cay 6742 Mesa Dr. Mese, AZ 85284 F.O.B. Terms Salesperson Customer Order + 7291 Our Sales Order # 12345 Dale Slupped March 20, 2009 Shipped Vio Our Truck Destination JML 1/10, Net 30 Quantity Unit Price liem Number 2741 3315 100 Description Cakulator Poger 1795 4995 Amount 179500 2497 50 50 Pay This Amount 4292 50 Thank You! A) B) C) Customer Order Customer Sales Sales Order 15) Which of the following would not be true about the well-structured tables in a well-designed relational database used to generate this sales invoice? INVOICE Ship West Quen my Desu gion mo ZMI Pey This Amel 0 920 A) Quantity would be generated from the Sales table. B) 34567 would be a primary key in the Sales table. Unit Price would be generated from the Inventory table. D) Hardware City is an example of a non-key data value in the Customer table. 16) Suppose a relational database contained two linked tables. Which of the following items is not necessarily present in the database? A) Two primary keys B) Two foreign keys C) At least one column D) One foreign key Page Break 17) Suppose a relational database contained two linked tables. Assuming the organization wants the database to be normalized, which of the following items represents a problem to normalization? A) The database contains only one primary key. B) The database contains two foreign keys. C) The database contains two primary keys. , D) The database contains only one foreign key

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting In Emerging Economies

Authors: Mathew Tsamenyi

1st Edition

1849506256, 9781849506250

More Books

Students also viewed these Accounting questions

Question

State the name of the property illustrated. 5 m = m 5

Answered: 1 week ago