Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please submit a paper with the answers to the following questions. a. Name the tables in the database. b. For each table, list its fields

Please submit a paper with the answers to the following questions.

a. Name the tables in the database.

b. For each table, list its fields and primary key.

c. List the foreign keys.

d. For each foreign key, list the table to which it refers.

 

 

 

 

Screenshot 2023-10-16 at 10.52.18 AM.png 

5. Using the database shown in Figure 5.6 below: a. Name the tables in this database. b. For each table, list its fields and primary key. c. List the foreign keys. d. For each foreign key list the table to which it refers. 6. Using the database shown in Figure 5.7 on next page: a. Name the tables in this database. b. For each table, list its fields and primary key. Customers PK CustomerlD CompanyName Contact FirstName ContactLastName Phone Email SalesReps PK RepID RepFirstName RepLastName Phone Email Activities PK ActivityID Activity Date Description Notes FK1 CustomerID FIGURE 5.6 Customer Activity Database Design RepActivity PK,FK1 RepID PK,FK2 ActivityID LeadRep?

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_2

Step: 3

blur-text-image_3

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

Linear Algebra And Its Applications

Authors: David Lay, Steven Lay, Judi McDonald

6th Global Edition

978-1292351216, 1292351217

More Books

Students also viewed these Databases questions

Question

Briefly describe Kants theory of moral development.

Answered: 1 week ago