AutoSave Off H U : Assignment2Part1 (2) - Word Search Design Layout References Mailings Review View Help v Ev E File Home Insert X Cut LE Copy Paste Format Painter Clipboard Calibri (Body) 14 A A Aav to BIU ab X, X ADA ALT - 1 AaBbccdc AabbccDc AaBbC AaBbcc AaB Aabbccc AaBbCcDe AaBbCcDE 1 Normal 1 No Spac... Heading 1 Heading 2 Title Subtitle Subtle Em... Emphasis Font Paragraph Styles Assignment 2- Part One For each table below, review the column "Description" to determine a name and data type for each column. To provide an example, I filled in a sample solution for the first column of Table 1. With any design exercise, there is more than one correct answer. Some of the descriptions may challenge you because they don't provide explicit information as to the data type that should be used. This is often the case when a developer receives specifications from a customer or analyst. Therefore consider carefully as though you were designing the tables below to best meet the descriptions provided by your employer using only the information that is given to you. As mentioned above, there is more than one correct answer. Use consistent naming conventions for your columns. For types that require a size such as CHAR, VARCHAR, DECIMAL, etc., make sure you include the size as part of the data type. For example, to create a VARCHAR of size 10, you would use VARCHAR(10) as the data type. If you aren't sure what size to make such a data type and the description does not explicitly state a certain size, then make a best estimation as to the size that you believe is appropriate to contain the data. Table 1: PhoneCampaign Description Column Name and Data Type Which campaign ID this relates to (example value of 2345) PhoneCampaignID INT The prospect ID that was contacted (example value of 6789) When contact was first attempted with the prospect Comments related to the contact that was made When contact was actually made with the prospect Single-character code reflecting the outcome of the sale Monetary value of any sale made Table 2: Opportunity Column Name and Data Type Description Name of the opportunity Which prospect ID this opportunity relates to (example value of 6789) Two-character code representing sales status Date that the opportunity was raised Probability of success represented as a numeric value Single-character rating representing the Rating associated with this opportunity (C = Cold, W = Warm, H = Hot) Estimated closing date Estimated revenue Estimated revenue Delivery address Table 3: SpecialOrder Column Name and Data Type Description Which prospect ID this order is for (example value of 6789) External Supplier ID of the Item (example value of 4445) Description of the item Quantity required (positive whole numbers up to 999) Date of order Promised delivery date Actual delivery date Special requirements (any comments related to the special order) Quoted price per unit