A fairly large local electronics store contracts with you to develop a database system for them. Your first task is to design a table for the stores employees. Even many of the most experienced designers sketch a design on paper before they start creating the database in electronic form. Please sketch an employee table (basically what data items or columns should be included in the table) using the template below as a model. The CEO of the store tells you that the following information must come from the table. EMPLOYEE TABLE Social Security Number The data items that belong in a table are a function of the information that has to come out of the table. Therefore, the determining factor is the information requirements that have been given to you. You need not be concerned with the rows (except for row one, of course). The first column of the table is the Primary Key (social security number). This has been filled in to give you a start. Match whats
in your table to the information requirements to make certain all data has been included. Totals that are derived from the table through computation do not have to be carried in the table. Your work is so good that the electronics store contracts with you to do additional work for them. Your next task is to design two tables that relate to one another. These tables are: the Customer table and the Sales Order table. The Customer table contains the basic data on each customer, and the primary key is the customer number. There is one row for each customer. The Sales Order table contains the data for each sale. The primary key consists of two pieces of data: sales order number and customer number. There can be one or more sales orders for a customer, but only one customer on a sales order. Use the templates below to design the two tables. Customer Table Sales Order Table Purchase the answer to view it Purchase the answer to view it Purchase the answer to view it