Question: List all the tables and columns in your database, and describe the functions of each table and column. Customer Table Order Table Product Table Relationships

List all the tables and columns in your database, and describe the

List all the tables and columns in your database, and describe the functions of each table and column.

Customer Table Order Table Product Table Relationships \begin{tabular}{|l|} \hline Customer Table \\ \hline ID \\ Name \\ Surname \\ Gender \\ E-mail Address \\ Address \\ City \\ Region \\ Postal Code \\ Country \\ Phone Number \\ \hline \end{tabular} Order Table ID Name Surname Order Date Required Date Shipped Date Ship Address Ship City Ship Region Ship Postal Code Ship Country \begin{tabular}{|l|l|} \hline Product Table \\ Product Code \\ Product Name \\ Quantity Per Unit \\ Unit Price \\ Units in Stock \\ Units on Order \\ \hline \end{tabular} Customer Table Order Table Product Table Relationships \begin{tabular}{|l|} \hline Customer Table \\ \hline ID \\ Name \\ Surname \\ Gender \\ E-mail Address \\ Address \\ City \\ Region \\ Postal Code \\ Country \\ Phone Number \\ \hline \end{tabular} Order Table ID Name Surname Order Date Required Date Shipped Date Ship Address Ship City Ship Region Ship Postal Code Ship Country \begin{tabular}{|l|l|} \hline Product Table \\ Product Code \\ Product Name \\ Quantity Per Unit \\ Unit Price \\ Units in Stock \\ Units on Order \\ \hline \end{tabular}

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!