Question: CustomerClassification 1 Customer Classification Classification Description Customers Customer Customer Name Address VTDPurchases Classification Product Reviews Product Review Reviewer tem of stars Products Product Product Name

CustomerClassification 1 Customer Classification
CustomerClassification 1 Customer Classification
CustomerClassification 1 Customer Classification
CustomerClassification 1 Customer Classification Classification Description Customers Customer Customer Name Address VTDPurchases Classification Product Reviews Product Review Reviewer tem of stars Products Product Product Name 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 helds in the database. Count the number of foreign key attributes in this data diagram. 2 4 5 the Jebfunctions Bound Function Employees Employee First time Lane fate obfunction Yearts Salate Asunt Custom Empleo Customer V utomer Furtha tame Addre Postcode Telephone Foto Postcode City State/Province Postal Code 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 held in the database. Which of the following statements is true? The Invoice table is a master' table which can hold a list of objects The invoices table is a transaction table which records the events of making sales to customers The design supports a many to many relationship between Customers and invoices Employeeld in the Employees table is a foreign key field Invoices wewe Customers Customer Job Function obfunction Function Employees Employee FortName La Paylate bunction Yeartobufeier PostalCodes Postcode City State/Province Postcode Country Lame Add Postcode Telephone Employee 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. Which of the following statements is true? There is a many to many relationship between customers and invoices The system can record only one PostalCodel for every customer Each invoice can be associated with multiple customers The system can record many job functions for every employee

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!