Chapter 6 TAL DISTRIBUTOR EXCERSIES.
The following exercises are based on the TAL Distributors database as designed in Example 1 in this chapter.
In each exercise, represent your answer in DBDL and with a diagram. You may use any of the styles
TAL DISTRUBUTOR EXCERSISES.
1. Using your knowledge of TAL Distributors, determine the functional dependencies that exist in the
following table. After determining the functional dependencies, convert this table to an equivalent
collection of tables that
I used MS Access for this assignment. These instructions mentioned are for MS Access only.
TAL Distributors Database was used. I didnt know exactly how you wanted us to describe it but I did it to the
best of my abilities and I have also provided pictures
Microsoft Access was used for this Assignment.
1. List the number and name of all customers.
SELECT CustomerNum, CustomerName
2. List the complete Item table.
3. List the number and name of every customer represented by