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.
Homework Answers
D) A new table will be created that contains both Sales Order ID and Product ID as its composite primary key.
Both the Sales Order ID and Product ID will be included in the database because for every transaction both the Sales Order ID and Product ID will be unique.
Add Answer to:
Multiple Choice
A) The Product ID will be included as a foreign key in the Sales...
Please do it by type not pics. 1.Consider the following three tables, primary and foreign keys....
Please do it by type not pics. 1.Consider the following three tables, primary and foreign keys. Table Name SalesPeople Attribute Name Type Key Type EmployeeNumber Number Primary Key Name Character JobTitle Character Address Character PhoneNumber Character YearsInPosition Number Table Name ProductDescription Attribute Name Type Key Type ProductNumber Number Primary Key ProductName Character ProductPrice Number Table Name SalesOrder Attribute Name Type Key Type SalesOrderNumber Number Primary Key ProductNumber Number Foreign Key EmployeeNumber Number Foreign Key SalesOrderDate Date Assume that you draw...
Consider the following three tables, primary and foreign keys. Table Name SalesPeople Attribute Name  
Consider the following three tables, primary and foreign keys. Table Name SalesPeople Attribute Name Type Key Type EmployeeNumber Number Primary Key Name Character JobTitle Character Address Character PhoneNumber Character YearsInPosition Number Table Name ProductDescription Attribute Name Type Key Type ProductNumber Number Primary Key ProductName Character ProductPrice Number Table Name SalesOrder Attribute Name Type Key Type SalesOrderNumber Number Primary Key ProductNumber Number Foreign Key EmployeeNumber Number Foreign Key SalesOrderDate Date Assume...
newconnect.mheducation.com/llow/connect. n l Help Save & Exit Submit Fleurant, Inc., manufactures and sells two products: Product...
newconnect.mheducation.com/llow/connect. n l Help Save & Exit Submit Fleurant, Inc., manufactures and sells two products: Product W2 and Product P8. Data concerning the expected production of each product and the expected total direct labor hours (DLHS) required to produce that output appear below: Direct Labor- Hours Per Unit Expected Production 300 600 Product W2 Product P8 Total direct labor-hours Total Direct Labor-Hours 1,800 1,800 3,600 The direct labor rate is $30.10 per DLH. The direct materials cost per unit is...
Refer to the following integrated diagram, showing part of the purchases and sales processes linked to...
Refer to the following integrated diagram, showing part of the
purchases and sales processes linked to the conversion process, for
Questions 11 through 25.
7
Refer to the association marked with the number 1 in the
preceding diagram. Which of the following is the best description
of the association?
Multiple Choice
Each supplier participates in a minimum of zero purchases.
Each supplier participates in at least one purchase.
Each supplier participates in a maximum of one purchase.
Supplier in the...
An online company sells hundreds of office supply products on its e-Commerce store. It has asked...
An online company sells hundreds of office supply products on
its e-Commerce store. It has asked you to design and implement a
sales order processing system which will be used by users in our
Operations department to process sales orders. Here is an overview
of the sales order process. Customers make purchases by placing
orders. Each customer has a customer number and profile (such as
name, shipping address). To simplify the matter, each time an order
is placed, only one...
Directions: Answer the following critical thinking questions below. This PW is clearly multiple choice. This document...
Directions: Answer the following critical thinking questions
below. This PW is clearly multiple choice. This document contains
the questions and the quiz online only contains the letter options.
Input your answers into the quiz on Carmen. It is your
responsibility to make sure you correlate the questions from this
document and the online quiz submission. You will only have 1
opportunity to submit your work and it will be graded immediately.
The key will reveal as scheduled in Carmen. Submit...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orde...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
-- drop tables DROP TABLE REQUEST CASCADE CONSTRAINTS; DROP TABLE FULLORDER CASCADE CONSTRAINTS; DROP TABLE PRODUCT...
-- drop tables DROP TABLE REQUEST CASCADE CONSTRAINTS; DROP TABLE FULLORDER CASCADE CONSTRAINTS; DROP TABLE PRODUCT CASCADE CONSTRAINTS; DROP TABLE CUSTOMER CASCADE CONSTRAINTS; -- create and link tables CREATE TABLE CUSTOMER ( CustomerID INTEGER, Name VARCHAR2(40), City VARCHAR2(20), State CHAR(2), Zip CHAR(5), CONSTRAINT PK_CUSTOMER PRIMARY KEY (CustomerID) ); CREATE TABLE PRODUCT ( ProductID INTEGER, Description VARCHAR2(30), Material VARCHAR2(20), Price NUMBER(5,2), CONSTRAINT PK_PRODUCT...
The Northwind database created by Microsoft contains the sales data for a fictitious company called Northwind...
The Northwind database created by Microsoft contains the sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world. Here is the schema of the database: Products (ProductID, ProductName, SupplierID, CategoryID, QuantityPerUnit, UnitPrice, UnitsInStock, UnitsOnOrder, ReorderLevel, Discontinued); Suppliers (SupplierID, CompanyName, ContactName , ContactTitle, Address, City, Region, PostalCode, Country, Phone, Fax, HomePage); Categories (CategoryID, CategoryName, Description, Picture); Orders (OrderID, CustomerID, EmployeeID, OrderDate, RequiredDate, ShippedDate, ShipVia, Freight, ShipName,ShipAddress, ShipCity, ShipRegion, ShipPostalCode, ShipCountry); Order_details (ID, OrderID,...
ID: A 9. When a monopolist is able to sell its product at different prices, it...
ID: A 9. When a monopolist is able to sell its product at different prices, it is engaging in a quality adjusted pricing. b. price differentiation. c. price discrimination. d. distribution pricing. 10. A natural monopoly occurs when a. the product is sold in its natural state (such as water or diamonds). b. there are economies of scale over the relevant range of output. c. the firm is characterized by a rising marginal cost curve. d. production requires the use...
newconnect.mheducation.com/llow/connect. n l Help Save & Exit Submit Fleurant, Inc., manufactures and sells two products: Product W2 and Product P8. Data concerning the expected production of each product and the expected total direct labor hours (DLHS) required to produce that output appear below: Direct Labor- Hours Per Unit Expected Production 300 600 Product W2 Product P8 Total direct labor-hours Total Direct Labor-Hours 1,800 1,800 3,600 The direct labor rate is $30.10 per DLH. The direct materials cost per unit is...
Refer to the following integrated diagram, showing part of the
purchases and sales processes linked to the conversion process, for
Questions 11 through 25.
7
Refer to the association marked with the number 1 in the
preceding diagram. Which of the following is the best description
of the association?
Multiple Choice
Each supplier participates in a minimum of zero purchases.
Each supplier participates in at least one purchase.
Each supplier participates in a maximum of one purchase.
Supplier in the...
An online company sells hundreds of office supply products on
its e-Commerce store. It has asked you to design and implement a
sales order processing system which will be used by users in our
Operations department to process sales orders. Here is an overview
of the sales order process. Customers make purchases by placing
orders. Each customer has a customer number and profile (such as
name, shipping address). To simplify the matter, each time an order
is placed, only one...
Directions: Answer the following critical thinking questions
below. This PW is clearly multiple choice. This document contains
the questions and the quiz online only contains the letter options.
Input your answers into the quiz on Carmen. It is your
responsibility to make sure you correlate the questions from this
document and the online quiz submission. You will only have 1
opportunity to submit your work and it will be graded immediately.
The key will reveal as scheduled in Carmen. Submit...
Given the following relational database schema (primary keys are bold and underlined). Answer questions 2.1 to 2.4 Orders(orderld, customerld, dateOrdered, dateRequired, status) Customer(customerld, customerLastName, customerStreet, customerCity, customerState, customer Lip OrderDetails(orderld.productld, quantity, lineNumber, amount) Products(productld, name, description, quantity, unitPrice) Account(accountNumber, customerld, dateOpened, creditCard, mailingStreet, mailingCity, mailingState, mailingZip) 2.1 (2 Points) List all possible foreign keys. For each foreign key list both the referencing and referenced relations. 2.2 (2 Points) Devise a reasonable database instance by filling the tables with data of...
ID: A 9. When a monopolist is able to sell its product at different prices, it is engaging in a quality adjusted pricing. b. price differentiation. c. price discrimination. d. distribution pricing. 10. A natural monopoly occurs when a. the product is sold in its natural state (such as water or diamonds). b. there are economies of scale over the relevant range of output. c. the firm is characterized by a rising marginal cost curve. d. production requires the use...
Most questions answered within 3 hours.
-
I need to write a research paper and work cited about this
topic: The United States...
asked 8 minutes ago -
Hello! I was wondering if I could have some help?
If the vapor pressure of carvone...
asked 30 minutes ago -
An economist wants to estimate the mean per capita income (in
thousands of dollars) for a...
asked 49 minutes ago -
What would be the input/output characteristic of a circuit
obtained by putting two of your 2's-complementers...
asked 48 minutes ago -
In Drosophila, the transition from the syncytial blastoderm
stage to the cellular blastoderm stage is a...
asked 1 hour ago -
Project management question:
Name 3 different types of resources (hint: humans are one
type)
asked 1 hour ago -
Consider the following reaction: C 2H 2( g) + 2H 2( g) C 2H 6(
g)...
asked 1 hour ago -
Consider a 1.0 L buffer containing 0.092 mol L-1 HCOOH and 0.100
mol L-1 HCOO-. What...
asked 1 hour ago -
Koch Realty has owned a vacant land with a FMV of
$775,000 and an adjusted basis...
asked 1 hour ago -
It is estimated 29% of all adults in United States invest in
stocks and that 85%...
asked 1 hour ago -
What does a 2-sided p value of 0.04 mean? (I am not asking if it
is...
asked 2 hours ago -
A parallel-plate capacitor is made from two aluminum-foil
sheets, each 7.8 cmcm wide and 5.1 mmlong....
asked 2 hours ago