HW2 (Protected Vie Database: HW2 . Create a file called: "YourLastName_AutoExcel.vsdx" Submit the file using HW2 link CEL Corporation is a company specializing in the commercialization of automotive parts. AUTOEXCEL has two types of customers: retail and wholesale. All customers have a customer ID, a name, an address, a phone number, a default shipping address, a date of last purchase, and a date of last payment. Retail customers have the customer attributes, plus the credit card type, credit card number, expiration date, and e-mail address. Whol have the customer attributes, plus a contact name, contact phone number, contact address, purchase order number and date, discount percentage, billing address, tax status (if exempt), and tax identification number. A retail customer cannot be a wholesale customer and vice versa. Given that information, create the ERD containing all primary keys, foreign keys, and main attributes. I. AUTOEX esale customens e-mail 2. AUTOEXCEL Corporation has five departments: administration, marketing, sales, shipping. and purchasing. Each department employs many employees. Each employee has an ID, a name, a home address, a home phone number, and a salary and tax ID (Social Security number). Some employees are classified as sales representatives, some as technical support, and some as administrators. Sales representatives receive a commission based on sales. Technical support employees are required to be certified in their areas of expertise. For example, some are certified as drivetrain specialists; others, as electrical systems specialists. All administrators have a title and a bonus. Given that information, create the ERD containing all primary keys, foreign keys, and main attributes 3. AUTOEXCEL Corporation operates under the following business rules: .AUTOEXCEL keeps a list of cars models with information about the manufacturer, model, and year. AUTOEXCEL keeps several parts in stock. A part has a part ID, description, unit price, and quantity on hand. A part can be used for many car models, and a car model has many parts. . A retail customer normally pays by credit card and is charged the list price for each purchased item. A wholesale customer normally pays via purchase order with terms of net O Type here to search HW2 (Protected Vie Database: HW2 . Create a file called: "YourLastName_AutoExcel.vsdx" Submit the file using HW2 link CEL Corporation is a company specializing in the commercialization of automotive parts. AUTOEXCEL has two types of customers: retail and wholesale. All customers have a customer ID, a name, an address, a phone number, a default shipping address, a date of last purchase, and a date of last payment. Retail customers have the customer attributes, plus the credit card type, credit card number, expiration date, and e-mail address. Whol have the customer attributes, plus a contact name, contact phone number, contact address, purchase order number and date, discount percentage, billing address, tax status (if exempt), and tax identification number. A retail customer cannot be a wholesale customer and vice versa. Given that information, create the ERD containing all primary keys, foreign keys, and main attributes. I. AUTOEX esale customens e-mail 2. AUTOEXCEL Corporation has five departments: administration, marketing, sales, shipping. and purchasing. Each department employs many employees. Each employee has an ID, a name, a home address, a home phone number, and a salary and tax ID (Social Security number). Some employees are classified as sales representatives, some as technical support, and some as administrators. Sales representatives receive a commission based on sales. Technical support employees are required to be certified in their areas of expertise. For example, some are certified as drivetrain specialists; others, as electrical systems specialists. All administrators have a title and a bonus. Given that information, create the ERD containing all primary keys, foreign keys, and main attributes 3. AUTOEXCEL Corporation operates under the following business rules: .AUTOEXCEL keeps a list of cars models with information about the manufacturer, model, and year. AUTOEXCEL keeps several parts in stock. A part has a part ID, description, unit price, and quantity on hand. A part can be used for many car models, and a car model has many parts. . A retail customer normally pays by credit card and is charged the list price for each purchased item. A wholesale customer normally pays via purchase order with terms of net O Type here to search
