Follow book example p97-104 to build a database using Access. i also assigned Connect Videos (Chapter...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Follow book example p97-104 to build a database using Access. i also assigned Connect Videos (Chapter 4 Access Video, not graded) that you can watch. Or my video on Canvas, 1. Screeshot of the design view of the tables : Customer and Sales. 2. Screenshot of your "Relationships" tab 3. Screenshat of your "datasheet" view of the records you put in the customer, salesperson, and sales tables. Make sure you put your name as one of the records in "salesperson" table or "customer table. Required: Build a simple relational database based on the data model (p. 95, Figure 4-2). Required tables in your database are as follows. Also You must include the attributes that you identify as primary key or foreign keys in your table. Other attributes in each table are at your discretion to include in your database or not. Table 1: Sales Table 2: Customer Table 3: Salesperson Table 4: Inventory Salesperson Salesperson Number Salesperson Eicst Name lespecson Last Name Salespecson. SSN 1.1 Inventory Sales Saie Number Sale. Date Sale Amouns Cavment Type Salesrersan Number Customer-Number 0. tosntendn.Number. -Description Somaietion Date Unit. Cost. Unit Price Sale Numuber 0..1 Customer Sustemer. Number Sstomer. Eirat. Name Qustomer Last Narme Customer Addres Sustemer Ot Customer State Sustemer Zn Sustomer. Emal 1.1 Englah (United Stated e to search 1) In the partial data model above, identify primary key (PK) and foreign key(s){FK) in each table. 2) Create tables in the database. 3) Input two records in the sales table, customer table, and salesperson table in your database. Please note it is better to input the records for the customers and salesperson first (p.115, Appendix A) Follow book example p97-104 to build a database using Access. i also assigned Connect Videos (Chapter 4 Access Video, not graded) that you can watch. Or my video on Canvas, 1. Screeshot of the design view of the tables : Customer and Sales. 2. Screenshot of your "Relationships" tab 3. Screenshat of your "datasheet" view of the records you put in the customer, salesperson, and sales tables. Make sure you put your name as one of the records in "salesperson" table or "customer table. Required: Build a simple relational database based on the data model (p. 95, Figure 4-2). Required tables in your database are as follows. Also You must include the attributes that you identify as primary key or foreign keys in your table. Other attributes in each table are at your discretion to include in your database or not. Table 1: Sales Table 2: Customer Table 3: Salesperson Table 4: Inventory Salesperson Salesperson Number Salesperson Eicst Name lespecson Last Name Salespecson. SSN 1.1 Inventory Sales Saie Number Sale. Date Sale Amouns Cavment Type Salesrersan Number Customer-Number 0. tosntendn.Number. -Description Somaietion Date Unit. Cost. Unit Price Sale Numuber 0..1 Customer Sustemer. Number Sstomer. Eirat. Name Qustomer Last Narme Customer Addres Sustemer Ot Customer State Sustemer Zn Sustomer. Emal 1.1 Englah (United Stated e to search 1) In the partial data model above, identify primary key (PK) and foreign key(s){FK) in each table. 2) Create tables in the database. 3) Input two records in the sales table, customer table, and salesperson table in your database. Please note it is better to input the records for the customers and salesperson first (p.115, Appendix A) Follow book example p97-104 to build a database using Access. i also assigned Connect Videos (Chapter 4 Access Video, not graded) that you can watch. Or my video on Canvas, 1. Screeshot of the design view of the tables : Customer and Sales. 2. Screenshot of your "Relationships" tab 3. Screenshat of your "datasheet" view of the records you put in the customer, salesperson, and sales tables. Make sure you put your name as one of the records in "salesperson" table or "customer table. Required: Build a simple relational database based on the data model (p. 95, Figure 4-2). Required tables in your database are as follows. Also You must include the attributes that you identify as primary key or foreign keys in your table. Other attributes in each table are at your discretion to include in your database or not. Table 1: Sales Table 2: Customer Table 3: Salesperson Table 4: Inventory Salesperson Salesperson Number Salesperson Eicst Name lespecson Last Name Salespecson. SSN 1.1 Inventory Sales Saie Number Sale. Date Sale Amouns Cavment Type Salesrersan Number Customer-Number 0. tosntendn.Number. -Description Somaietion Date Unit. Cost. Unit Price Sale Numuber 0..1 Customer Sustemer. Number Sstomer. Eirat. Name Qustomer Last Narme Customer Addres Sustemer Ot Customer State Sustemer Zn Sustomer. Emal 1.1 Englah (United Stated e to search 1) In the partial data model above, identify primary key (PK) and foreign key(s){FK) in each table. 2) Create tables in the database. 3) Input two records in the sales table, customer table, and salesperson table in your database. Please note it is better to input the records for the customers and salesperson first (p.115, Appendix A) Follow book example p97-104 to build a database using Access. i also assigned Connect Videos (Chapter 4 Access Video, not graded) that you can watch. Or my video on Canvas, 1. Screeshot of the design view of the tables : Customer and Sales. 2. Screenshot of your "Relationships" tab 3. Screenshat of your "datasheet" view of the records you put in the customer, salesperson, and sales tables. Make sure you put your name as one of the records in "salesperson" table or "customer table. Required: Build a simple relational database based on the data model (p. 95, Figure 4-2). Required tables in your database are as follows. Also You must include the attributes that you identify as primary key or foreign keys in your table. Other attributes in each table are at your discretion to include in your database or not. Table 1: Sales Table 2: Customer Table 3: Salesperson Table 4: Inventory Salesperson Salesperson Number Salesperson Eicst Name lespecson Last Name Salespecson. SSN 1.1 Inventory Sales Saie Number Sale. Date Sale Amouns Cavment Type Salesrersan Number Customer-Number 0. tosntendn.Number. -Description Somaietion Date Unit. Cost. Unit Price Sale Numuber 0..1 Customer Sustemer. Number Sstomer. Eirat. Name Qustomer Last Narme Customer Addres Sustemer Ot Customer State Sustemer Zn Sustomer. Emal 1.1 Englah (United Stated e to search 1) In the partial data model above, identify primary key (PK) and foreign key(s){FK) in each table. 2) Create tables in the database. 3) Input two records in the sales table, customer table, and salesperson table in your database. Please note it is better to input the records for the customers and salesperson first (p.115, Appendix A) Follow book example p97-104 to build a database using Access. i also assigned Connect Videos (Chapter 4 Access Video, not graded) that you can watch. Or my video on Canvas, 1. Screeshot of the design view of the tables : Customer and Sales. 2. Screenshot of your "Relationships" tab 3. Screenshat of your "datasheet" view of the records you put in the customer, salesperson, and sales tables. Make sure you put your name as one of the records in "salesperson" table or "customer table. Required: Build a simple relational database based on the data model (p. 95, Figure 4-2). Required tables in your database are as follows. Also You must include the attributes that you identify as primary key or foreign keys in your table. Other attributes in each table are at your discretion to include in your database or not. Table 1: Sales Table 2: Customer Table 3: Salesperson Table 4: Inventory Salesperson Salesperson Number Salesperson Eicst Name lespecson Last Name Salespecson. SSN 1.1 Inventory Sales Saie Number Sale. Date Sale Amouns Cavment Type Salesrersan Number Customer-Number 0. tosntendn.Number. -Description Somaietion Date Unit. Cost. Unit Price Sale Numuber 0..1 Customer Sustemer. Number Sstomer. Eirat. Name Qustomer Last Narme Customer Addres Sustemer Ot Customer State Sustemer Zn Sustomer. Emal 1.1 Englah (United Stated e to search 1) In the partial data model above, identify primary key (PK) and foreign key(s){FK) in each table. 2) Create tables in the database. 3) Input two records in the sales table, customer table, and salesperson table in your database. Please note it is better to input the records for the customers and salesperson first (p.115, Appendix A) Follow book example p97-104 to build a database using Access. i also assigned Connect Videos (Chapter 4 Access Video, not graded) that you can watch. Or my video on Canvas, 1. Screeshot of the design view of the tables : Customer and Sales. 2. Screenshot of your "Relationships" tab 3. Screenshat of your "datasheet" view of the records you put in the customer, salesperson, and sales tables. Make sure you put your name as one of the records in "salesperson" table or "customer table. Required: Build a simple relational database based on the data model (p. 95, Figure 4-2). Required tables in your database are as follows. Also You must include the attributes that you identify as primary key or foreign keys in your table. Other attributes in each table are at your discretion to include in your database or not. Table 1: Sales Table 2: Customer Table 3: Salesperson Table 4: Inventory Salesperson Salesperson Number Salesperson Eicst Name lespecson Last Name Salespecson. SSN 1.1 Inventory Sales Saie Number Sale. Date Sale Amouns Cavment Type Salesrersan Number Customer-Number 0. tosntendn.Number. -Description Somaietion Date Unit. Cost. Unit Price Sale Numuber 0..1 Customer Sustemer. Number Sstomer. Eirat. Name Qustomer Last Narme Customer Addres Sustemer Ot Customer State Sustemer Zn Sustomer. Emal 1.1 Englah (United Stated e to search 1) In the partial data model above, identify primary key (PK) and foreign key(s){FK) in each table. 2) Create tables in the database. 3) Input two records in the sales table, customer table, and salesperson table in your database. Please note it is better to input the records for the customers and salesperson first (p.115, Appendix A) Follow book example p97-104 to build a database using Access. i also assigned Connect Videos (Chapter 4 Access Video, not graded) that you can watch. Or my video on Canvas, 1. Screeshot of the design view of the tables : Customer and Sales. 2. Screenshot of your "Relationships" tab 3. Screenshat of your "datasheet" view of the records you put in the customer, salesperson, and sales tables. Make sure you put your name as one of the records in "salesperson" table or "customer table. Required: Build a simple relational database based on the data model (p. 95, Figure 4-2). Required tables in your database are as follows. Also You must include the attributes that you identify as primary key or foreign keys in your table. Other attributes in each table are at your discretion to include in your database or not. Table 1: Sales Table 2: Customer Table 3: Salesperson Table 4: Inventory Salesperson Salesperson Number Salesperson Eicst Name lespecson Last Name Salespecson. SSN 1.1 Inventory Sales Saie Number Sale. Date Sale Amouns Cavment Type Salesrersan Number Customer-Number 0. tosntendn.Number. -Description Somaietion Date Unit. Cost. Unit Price Sale Numuber 0..1 Customer Sustemer. Number Sstomer. Eirat. Name Qustomer Last Narme Customer Addres Sustemer Ot Customer State Sustemer Zn Sustomer. Emal 1.1 Englah (United Stated e to search 1) In the partial data model above, identify primary key (PK) and foreign key(s){FK) in each table. 2) Create tables in the database. 3) Input two records in the sales table, customer table, and salesperson table in your database. Please note it is better to input the records for the customers and salesperson first (p.115, Appendix A) Follow book example p97-104 to build a database using Access. i also assigned Connect Videos (Chapter 4 Access Video, not graded) that you can watch. Or my video on Canvas, 1. Screeshot of the design view of the tables : Customer and Sales. 2. Screenshot of your "Relationships" tab 3. Screenshat of your "datasheet" view of the records you put in the customer, salesperson, and sales tables. Make sure you put your name as one of the records in "salesperson" table or "customer table. Required: Build a simple relational database based on the data model (p. 95, Figure 4-2). Required tables in your database are as follows. Also You must include the attributes that you identify as primary key or foreign keys in your table. Other attributes in each table are at your discretion to include in your database or not. Table 1: Sales Table 2: Customer Table 3: Salesperson Table 4: Inventory Salesperson Salesperson Number Salesperson Eicst Name lespecson Last Name Salespecson. SSN 1.1 Inventory Sales Saie Number Sale. Date Sale Amouns Cavment Type Salesrersan Number Customer-Number 0. tosntendn.Number. -Description Somaietion Date Unit. Cost. Unit Price Sale Numuber 0..1 Customer Sustemer. Number Sstomer. Eirat. Name Qustomer Last Narme Customer Addres Sustemer Ot Customer State Sustemer Zn Sustomer. Emal 1.1 Englah (United Stated e to search 1) In the partial data model above, identify primary key (PK) and foreign key(s){FK) in each table. 2) Create tables in the database. 3) Input two records in the sales table, customer table, and salesperson table in your database. Please note it is better to input the records for the customers and salesperson first (p.115, Appendix A)
Expert Answer:
Answer rating: 100% (QA)
1 Inventory table Primary Key InventoryIDNumber Foreign Key SaleNumber Sales table Primary Key SaleN... View the full answer
Related Book For
Applied Regression Analysis and Other Multivariable Methods
ISBN: 978-1285051086
5th edition
Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg
Posted Date:
Students also viewed these finance questions
-
Using the accompanying computer output based on the data in Problem 7 in Chapter 17, conduct a randomized-blocks analysis, treating the high schools as blocks, to test whether significant differences...
-
Using the accompanying computer output based on the data in Problem 8 in Chapter 17, conduct a randomized-blocks analysis, treating the days as blocks, to test whether the three persons have...
-
Based on the data in Exercise 4-23, prepare an income statement, statement of owners equity, and balance sheet for Homeland Security Services Co.
-
How do accounting differences impact the usefulness of financial ratio comparisons?
-
If f(x) = f(X), where the graph of is shown, evaluate g'(3). F1
-
A cataract is a clouding or opacity that develops in the eye's lens, often in older people. In extreme cases, the lens of the eye may need to be removed. This would have the effect of leaving a...
-
Number of classes: 5 Data set: Strengths (in parts per thousands) of 24 acids Construct a frequency distribution and a frequency histogram for the data set using the indicated number of classes....
-
A disk with radius R has uniform surface charge density (a) By regarding the disk as a series of thin concentric rings, calculate the electric potential V at a point on the disk's axis a distance x...
-
Sudoku is a fun little logic puzzle where the objective is to fill a 9x9 grid with digits so that each column, each row, and each of the nine 3x3 sub-grids contain all digits from 1 to 9. Solving one...
-
Data on U.S. retail sales are available at the U.S. Bureau of the Census Internet site at: www.census.gov/retail/index.html. Under the heading "Monthly Retail Trade Report" there is a file titled...
-
7 7 x x5 If F(x) is the antiderivative of f(x) satisfying F(1) = 0, find F(x). F(x) = Let f(x) be the function f(x) = -
-
Match the type of reinforcement schedule with its definition. 1. Reinforcement occurs after a set time period. 2. Reinforcement occurs after a set number of C. 3. responses. Reinforcement occurs...
-
The three middle ear bones transmit their sound to the __________ __________.
-
__________are categorizations of objects that share common properties.
-
Which of the following formats are acceptable input and output when using the OCI CLI? A. Terraform .tf configuration files B. HCL commands C. JSON D. CamelCase
-
The __________theory of hearing states that the entire basilar membrane responds to a sound, vibrating more or less, depending on the nature of the sound.
-
Two charges, QA and QB, are located 20 cm apart as shown. When a third charge is placed at the x mark, 10 cm from QB, the electric force on Qc is zero. Find the value (including sign) of QB. Q = 6 x...
-
Assume that a trial balance is prepared with an account balance of $21,360 listed as $21,630 and an account balance of $1,500 listed as $15,000. Identify the transposition and the slide.
-
Suppose that, in a study on geographic variation in a certain species of beetle, the mean tibia length (U) and the mean tarsus length (V) were obtained for samples of size 50 from each of 10...
-
Answer the same questions as in parts (a) and (b) of Problem 1 for each of the regressions of Y on X in Problems 5 through 8 and Problem 10 of Chapter 5. The following results will be helpful:...
-
An experiment was conducted at the University of North Carolina to see whether the biochemical oxygen demand (BOD) test for water pollution is biased by the presence of copper. In this test, the...
-
Is an oscillating object in translational equilibrium?
-
How far above Farth's surface must a \(10,000-\mathrm{kg}\) boulder be moved to increase the mass of the Earthboulder system by \(2.50 \mathrm{mg}\) ? Assume the same ratio of energy change to mass...
-
Show that for small displacements the restoring force exerted on part 2 of the displaced string in Figure 15.14 is linearly proportional to the displacement of that part from its equilibrium...
Study smarter with the SolutionInn App