Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The following 5 questions require you to match entries in two columns. A list of all customers, their account numbers, zip codes, and other such

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
The following 5 questions require you to match entries in two columns. A list of all customers, their account numbers, zip codes, and other such pertinent customer data. A column labeled "Customer Zip Code" (in a customer table) [Choose [Choose Attribute Foreign Key Table "Customer Account Number" that uniquely identifies a customer (in a customer table) Record A column labeled Sales Representative ID" (in a Primary key customer table) used as a cross reference to keep track of which sales representative assisted which customer Information pertaining to 100th customer (100th row in a customer table) [Choose) Which of the following is a popular DBMS product from Microsoft? Access PowerPoint Outlook Silverlight Question 9 2 pts Customer Classification * Customer Classification Classification Description Customers * Customer CustomerName Address YTDPurchases ClassificationID Product Reviews 9 Product ReviewID ReviewerID ItemID #_of_stars Products ProductID ProductName ListPrice As you answer this question, consider the above data diagram, remembering the database design rules discussed in class. Assume that there are no other tables or felds in the database. Which table(s) best illustrate(s) the concept of an object or master table? Both Customers and Products Customers Product Reviews Products Both Customers and Product Reviews Question 10 2 pts JobFunctions JobFunctionID Function Employees Employee FirstName LastName PayRate JobFunctionID YearToDate Sales Invoices InvoiceID Sale Date Amount Customer EmployeeID Customers CustomerID FirstName LastName Address PostalCodeID Telephone Email Postal Codes PostalCodeID City State/Province PostalCode Country As you answer this question, consider the above data diagram, remembering the database design rules discussed in class. Assume that there are no other tables or fields in the database. Count the number of foreign key attributes in this data diagram. 4 5 3 2

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

Linked Data A Geographic Perspective

Authors: Glen Hart, Catherine Dolbear

1st Edition

1000218910, 9781000218916

More Books

Students also viewed these Databases questions

Question

1. How will you, as city manager, handle these requests?

Answered: 1 week ago