BACKGROUND INFO-

Being a university business student, you have a keen interest in how companies work. You meet your Uncle Dave at a Memorial Day barbecue and spend some time with him discussing his business. Uncle Dave has lived in Maine all his life and has built a small business on being the middleman for fishermen and local res-taurants that serve the local catch. Dave is friends with many of the fishermen. They bring him their harvest and he distributes the fish to restaurants on the coast of Maine that boast freshnot frozenlocal seafood. Uncle Daves business has always been run on pads of paper, but he suspects after talking with you that he can become much more efficient if he uses a computer system. Because you have been studying databases, Uncle Dave enlists your help over the summer to create a small database and then train him on the system. If he embraces the computer system, hell move all of his paper-based records to electronic files.On the first day of your summer job, you meet with Uncle Dave to learn how the business works. He describes the information he keeps on paper. First, he has an address book of all the restaurants that order from his distribution company. In that address book, he has the name of each customer, which is a restaurant name, along with the restaurants address, phone number, and an email contact. Uncle Dave has a hard time keeping track of some of the restaurants because they have similar names. You jot down that statement and realize that each customer needs an identification number to keep everything straight. Uncle Dave also deals with three friends who are his suppliers of fresh fish. He keeps the business cards of these friends taped to the wall near his desk. The business cards list each fishing companys name, address, and phone number.Dave has laminated a large sheet that lists all the types of fish he deals in, including their prices per pound. As you examine this list, you find it confusing because many fish have the same names but come in different sizes or varieties. Again, you make a mental note to create a unique identification for each type of fish. Next to each fish listed, Uncle Dave has written an amount with a marker. Because the sheet is laminated, he can wipe the numbers off the sheet and rewrite them to reflect any updates of shipments as they arrive in the warehouse and as orders depart the warehouse. After seeing this system, you realize that Uncle Dave needs a database to help him keep track of incoming shipments and outgoing orders without relying on his mental math and marker erasures.Dave personally delivers the fish to his client restaurants on a daily basis. To keep driving to a minimum, he likes to group his orders by city. You explain that a query will help him determine which restaurants placed orders on a given day so he can ensure he doesnt miss any deliveries in a particular city. Uncle Dave would also like to know what shipments are coming in each day to ensure immediate and proper storage.You explain to your uncle that his method of keeping track of inventory is outdated, inefficient, and per-haps inaccurate at times. You realize that a series of transaction tables to capture all shipments and orders are important to this design. These tables will be used to create a daily update of the main table that holds the inventory. Therefore, you know you must create two update queries that will allow the system to add new shipments to inventory and subtract fish that has been ordered.After you spend some time with Uncle Dave, he realizes that the proposed computer system can produce good information, so he gives you his wish list. He would like to be able to see which fish is the most popu-lar order in a given month. He would also like to track how much money he spends on fish in a month. You proudly tell him that both of those requests are easily fulfilled with queries.Finally, you suggest two reports that will give your uncle a good understanding of his customers and suppliers. The first report will summarize the orders of fish for each restaurant. The second report will sum-marize shipments from each fish supplier and calculate how much money is spent on those shipments.

QUESTION/INSTRUCTIONS -

In this assignment, you design your database tables using a word-processing program. Pay close attention to the logic and structure of the tables. Do not start developing your Access database in Assignment 2 before getting feedback from your instructor on Assignment 1. Keep in mind that you need to examine the require-ments in Assignment 2 to design your fields and tables properly. It is good programming practice to look at the required outputs before beginning your design. When designing the database, observe the following guidelines:

First, determine the tables you will need by listing the name of each table and the fields it should con-tain. Avoid data redundancy. Do not create a field if it can be created by a calculated field in a query.

You will need transaction tables. Think about the business events that occur with each order and each shipment. Avoid duplicating data

. Document your tables using the table feature of your word processor. Your tables should resemble the format shown in Figure 4-1.

You must mark the appropriate key field(s) by entering an asterisk (*) next to the field name. Keep in mind that some tables might need a compound primary key to uniquely identify a record within a table

I need you to make 7 tables that each look like this

Field name	Data Type	Length/Notes

The 7 tables i need are the Cutomers table, Suppliers table, Fish (product) table, Incoming shipments, Incoming Shipments Line Item Table, Orders table, Order Line Item table.

PLEASE COMPLETE THE OUTLINE

Customers Table, 8 fields please note i have provided 4 out the 8 needed

Filed Name	Data Type	Length/Notes
Customer Name
Customer Address
Customer City
Customer Phone

Suppliers Table, 7 fields

Filed Name	Data Type	Length/Notes

Fish (Product) Table, 4 fields

Filed Name	Data Type	Length/Notes

Incoming Shipments Table, 3 fields

Filed Name	Data Type	Length/Notes

Incoming Shipments Line Item Table, 3 fields

Filed Name	Data Type	Length/Notes

Orders Table, 3 fields

Filed Name	Data Type	Length/Notes

Order Line Item Table, 3 fields

Filed Name	Data Type	Length/Notes