Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started