Question: A. Requirements 1. Create the Customer table with the following attributes: Customer_ID: integer Customer_Name: 30 characters Street: 25 characters City: 20 characters State: 12 characters

A. Requirements 1. Create the Customer table with
A. Requirements 1. Create the Customer table with the following attributes: Customer_ID: integer Customer_Name: 30 characters Street: 25 characters City: 20 characters State: 12 characters Balance: decimal (9,2) Credit_Limit: decimal (6,0) Rep_Number: integer Customer (Customer_ID, Customer_Name, Street, City, State, Balance, Credit_Limit, Rep_Number) 2. Design and insert your own make-up data for demonstration purposes (You must make sure that the database will produce some relevant records for each of the following questions). Search the database to answer following questions: Find the name and balance of each customer located in the city of Morrow, GA. - Find the ID, name and rep number for all customers with credit limits that exceed their balances. Find the ID, name and available credit (the credit limit minus balance) for each customer. - Find the total number of customers and the total of their balances. For each sales rep, list the rep number and the number of customers represented by the rep. Sort records based on rep number in ascending order. B. Submission: 1) Create a screenshot to show the content of the table (i.e. all makeup customers' information inserted for demo purpose) [ 30 marks]; 2) Create a screenshot to show the result of each query and the commands used to return the results [ 60 marks]; 3) Please write a readme to document how well you have completed the requirements (any issues, any incomplete solutions, etc.), any lessons learned, any parts that are hard, etc. [10 marks]

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!