Information on the following Database:

create database Sales_Co

use Sales_Co

create table Vendor

(v_code integer,

v_name varchar(35) not null,

v_contact varchar(15) not null,

v_areacode char(3) not null,

v_phone char(8) not null,

v_state char(2) not null,

v_order char(1) not null,

primary key (v_code));

create table product

(p_code varchar(10) constraint product_p_code_pk primary key,

p_descript varchar(35) not null,

p_indate datetime not null,

p_qoh integer not null,

p_min integer not null,

p_price numeric (8,2) not null,

p_discount numeric (4,2) not null,

v_code integer,

constraint product_v_code_fk foreign key (v_code) references vendor);

create table Customer

(cus_code integer primary key,

cus_lname varchar(15) not null,

cus_fname varchar(15) not null,

cus_initial char(1),

cus_areacode char(3),

cus_phone char(8) not null,

cus_balance numeric (9,2) default 0.00,

constraint cus_ui1 unique(cus_lname,cus_fname,cus_phone));

create table Invoice

(inv_number integer primary key,

cus_code integer not null references customer(cus_code),

inv_date datetime default current_timestamp not null,

constraint inv_ck1 check (inv_date > '2010-01-01'));

create table Line

(inv_number integer not null,

line_number numeric(2,0) not null,

p_code varchar(10) not null,

line_units numeric(9,2) default 0.00 not null,

line_price numeric(9,2) default 0.00 not null,

primary key (inv_number,line_number),

foreign key (inv_number) references invoice on delete cascade,

foreign key (p_code) references product(p_code),

constraint line_ui1 unique(inv_number,p_code));

create table Employee

(emp_num integer primary key,

emp_title char(10),

emp_lname varchar(15) not null,

emp_fname varchar(15) not null,

emp_initial char(1),

emp_dob datetime,

emp_hire_date datetime,

emp_years integer,

emp_areacode char(3),

emp_phone char(8));

create table EMP

(emp_num integer primary key,

emp_title char(10),

emp_lname varchar(15) not null,

emp_fname varchar(15) not null,

emp_initial char(1),

emp_dob datetime,

emp_hire_date datetime,

emp_areacode char(3),

emp_phone char(8),

emp_mgr integer);

2. Formulate SQL queries to run against Sales_Co database.

   1. Use the Employee table in the SaleCo database to prepare a list of all employees whose last names start or begin with ‘Smith’. The list should display employee number, first name, last name, and middle initial. The list should be alphabetized by last name. (5 points)

   2. Prepare a list of all employees who have been with the company for at least 15 years or less than 5 years. Display employee number, first name, last name, employee initial based on first and last names (call this column “Initial”), and number of years the employee has been with the company. Initial column values should have the following format: firstnameinitial.lastnameinitial. For example, the initial for George Kolmycz will be G.K. The list should be arranged from the least number of years to the most. (8 points)

   3. Prepare a list of all customers where customer owe a balance. The list should display customer code, first name, last name, and balance they owe (cus_balance). Arrange the list in ascending order by last name and then descending order by first name. (7 points)

   4. Now, modify the above query to show only the 3rd and 4th rows of your results. (4 points)

   5. Prepare a list of items purchased on each invoice. The list should include invoice number, product code of purchased item, quantity purchased, unit price and total amount (units*price) paid for that item. The list should include items from all invoice numbers except 1003, 1006, 1008. (hint: use Line table) (7 points)

   6. Now, modify above query and show top 5 rows of results only. (2 points)

   7. Prepare a list similar to the one in (5) above but include all invoice numbers here. Now, display only those items with total amount paid between $25.00 and $35.00, inclusive. (6 points)

   8. Which invoices were issued to customer # 10014 before January 17, 2018. List invoice number, and date issued. (6 points)

You are required to create a sales and marketing management system with a small number of common sense attributes. The system should contain the following information  Sales details  Marketing details  Customer details  Production details  Delivery details  Management details

So consider what sales and marketing system is required to deliver a consistent and customer oriented service to all customers over the world. You need to identify the tables you require and the information that they are to contain. This is only a small system, do not over-complicate it.

Create an entity-relationship (ER) model drawn with MS WORD or POWER POINT if you prefer. You are required to submit a print out of your database schema:  Set of normalised tables – with your sample data.  Indicate the table relationships using multiple keys; PK, FK, and SK using UML notation.

2 2. Use MYSQL to create the set of database tables of the relational database model and complete the associated queries given. Procedure:

1) Write all the SQL statements, necessary to create all tables and relationships, with Primary & Foreign keys.

2) Execute each statement in the correct order to create the relational database in MYSQL.

3) Insert some data into each table.

4) Use all your SQL create and Insert statements (from MS Word) to execute in the MYSQL WorkBench

5) Write in MS Word and execute in MYSQL WorkBench the statements necessary to; i. display all tables, ii. identify sales total for each item iii. identify delivery confirmation of sold items iv. identify marketing level for sold items

3. Using MS-ACCESS, link to the MYSQL database and create forms to enter sales and purchase orders. 

No buttons are necessary, just what ACCESS generates to scroll forward, add a record etc.

 Make it clear what the forms do in the Form by adding text or headers.

In three or more sentences what response would you give each statement below? I need a response for each statement . Any correction or add to the statements?

1)The primary difference between consequential and non-consequential approaches towards ethics is that consequential approaches focuses more on the rightness or wrongness of an action based on the consequences that action has. A non-consequential theory focuses on the rightness or wrongness of an action based on properties intrinsics to the action, not on its consequences (Everett, Faber, Savulescu, & Crockett, 2018). A major consequentialism theory that has many objections would be lying. Conseuentialism says if lying would help save someones life then it's the right thing to do. However, objections to this theory would include that lying can never be acceptable such as humans should never lie and should always tell the truth. An example of a non-consequentialist major theory includes how lying should never be permitted because it's not "morally" right no matter the consequences.  Objections to this theory would include that in some instances lying may be necessary to save ones life.

2)

A consequentialist approach is one who thinks of the rightness or wrongness of their actions due to the possible consequences of the action. Where as non-consequentialist is a approach is one who thinks more of the rightness and wrongness of the action instead of the consequences.

One of the major theories associated with consequentialism is utilitarianism. Utilitarianism is when someone does something for the good and pleasure for the greatest amount of people. A potential objection could be too much sacrifice by an individual. A major theory for non-consequentialism is deontology, which is to do what is morally right, follow the rules, and do what is right. An objection to this theory may be stealing. Yes stealing is wrong, but maybe someone was stealing food in order to feed their children/family.

Charleston Carriage Company offers guided horse-drawn carriage rides through historic Charleston, South Carolina. The carriage business is highly regulated by the city. The fare for all passengers is $19.50. Charleston Carriage has the following monthly operating costs:

In addition to these costs, Charleston Carriage pays a brokerage fee of $0.90 per ticket sold by brokers. On average, 60% of tickets are issued through these brokers; 40% are sold directly by Charleston Carriage.

Charleston Carriage has several questions about its monthly revenues, costs, and profits in 2018.

REQUIRED [ROUND YOUR ANSWER TO PART A, QUESTION 1 TO THE NEAREST CENT; ROUND ALL OTHER ANSWERS TO THE NEAREST UNIT OR NEAREST DOLLAR.]

Part A (6 tries; 8 points)
1. What is the estimated monthly contribution margin per passenger for Charleston Carriage in 2018?    

2. What are the estimated total monthly fixed costs for Charleston Carriage in 2018?    

Part B (8 tries; 8 points)
3. What is Charleston Carriage's estimated monthly operating income in 2018 if the number of monthly passengers is 8,900?    

4. How many monthly passengers would be required for Charleston Carriage to break even in 2018?    

5. How many monthly passengers would be required for Charleston Carriage to earn $112,000 per month in 2018?    

6. Assuming a tax rate of 35%, what must revenue be in order for Charleston Carriage to earn $112,000 per month in 2018?   

Part C (4 tries; 4 points)
7. Charleston Carriage has an opportunity to negotiate with the company that leases the horses and boards them. If Charleston Carriage expects to sell 5,903 tickets per month in 2018, what's the most it could pay to lease and board the horses if it wants to break even each month (ignoring taxes)?    

=

On January 1, 2016, Worthylake Company sold used machinery to Brown Company, accepting a $25,000, non-interest-bearing note maturing on January 1, 2018. Worthylake carried the machinery on its books at a cost of $22,000 and a current book value of $15,000. Neither the fair value of the machinery nor the note was determinable at the time of sale; however, Brown’s incremental borrowing rate was 12%.

Required:

The following are monthly percentage price changes for four market indexes.

Compute the following.

1. Average monthly rate of return for each index. Round your answers to five decimal places.

   DJIA:

   S&P 500:

   Russell 2000:

   Nikkei:

2. Standard deviation for each index. Do not round intermediate calculations. Round your answers to four decimal places.

   DJIA:

   S&P 500:

   Russell 2000:

   Nikkei:

3. Covariance between the rates of return for the following indexes. Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers to six decimal places.

   Covariance (DJIA, S&P 500):

   Covariance (S&P 500, Russell 2000):

   Covariance (S&P 500, Nikkei):

   Covariance (Russell 2000, Nikkei):

4. The correlation coefficients for the same four combinations. Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers to four decimal places.

   Correlation (DJIA, S&P 500):

   Correlation (S&P 500, Russell 2000):

   Correlation (S&P 500, Nikkei):

   Correlation (Russell 2000, Nikkei):

5. Using the unrounded answers from parts (a), (b), and (d), calculate the expected return and standard deviation of a portfolio consisting of equal parts of (1) the S&P and the Russell 2000 and (2) the S&P and the Nikkei. Do not round intermediate calculations. Round your answers to five decimal places.

   Expected return (S&P 500 and Russell 2000):

   Standard deviation (S&P 500 and Russell 2000):

   Expected return (S&P 500 and Nikkei):

   Standard deviation (S&P 500 and Nikkei):

   Since S&P 500 and Russell 2000 have a strong -Select-(negative positive) Item 21 correlation, meaningful reduction in risk -Select-is not observe dis observed Item 22 if they are combined.

   Since S&P 500 and Nikkei have a strong -Select-(negative positive )Item 23 correlation, meaningful reduction in risk -Select-is not observe dis observedItem 24 if they are combined.

Below is the trial balance of Tom’s Tents at 5 April 2018.

The following information is relevant.

1.     The closing inventory at 5 April 2018 is valued at £143,000.

2.     On 5 January 2018 Tom sold a motor vehicle for £12,000. The customer was due to pay Tom’s Tents on 5 April 2018 but had not paid at the year end. This disposal has not been recorded in the accounts. This motor vehicle had been bought on 6 April 2015 for £25,000.

3.     On 6 January 2018, Tom bought a new motor vehicle on credit for £30,000. At the year-end Tom had still not paid for this motor vehicle and the transaction had not been recorded in the accounts.

4.     Depreciation on motor vehicles is provided at 20% per annum using the reducing balance basis on a monthly pro-rata basis. Depreciation on fixtures and fittings is provided at 10% per annum on the straight line basis, assuming no residual value. There were no purchases or disposals of fixtures and fittings during the year.

5.     Tom estimates that £6,000 due from customers will be irrecoverable and must be written off.

6.     The allowance for receivables is to be set at 5% of net receivables at 5 April 2018.

7.     Rent includes a prepayment of £2,000.

8.     Insurance includes a prepayment of £700.

9.     The heating bill will arrive on 5 May 2018 and about £500 is expected to relate to the period until 5 April 2018.

10.  The long-term loan is repayable in 5 years’ time. Interest payable on the loan is 6% and will be paid once per year.

Required:

a.Prepare the income statement for Tom’s Tents for the period ended 5 April 2018. Show your workings, including a full non-current assets note.

b.Prepare the balance sheet for Tom’s Tents as at 5 April 2018. Show your workings.

Create a simple shopping cart application. Ask the user to input an item number and quantity. Update the shopping cart. Display the updated cart. Include the following when displaying cart: item number, name, quantity and total price. Ask for another update or end the program.

Design

Requires 2 classes: the main class and the cartItem class In the main class: Need one array named cartArray of type cartItem. Size = ? Need a loop that asks the user for input. Ask for item number, which is a string and quantity which is an integer. Need to create a new cartItem from user input of item number and quantity. Load the cartItem object into the cartArray. (CartItem is a class that takes two values in constructor: item number and item quantity.) Print out all items in cartArray (item number, name, quantity, and total price) and ask user for more input.

CartItem class

CartItem has four instance variables. String itemNumber; String name; int quantity; double totalPrice; It also has a “database” made up of 3 arrays. Described below. The CartItem class has a constructor that takes a String(itemNumber) and an integer(quantity) as arguments. The constructor does the following: It passes the item number up to the corresponding instance variable. It also passes the quantity up to the quantity instance variable. It then calls the getItemName method to first, get the item name and then set the item name instance variable. It calls the calcPrice method to set the totalPrice instance variable by first getting the total price and then setting the totalPrice instance variable.

The CartItem class Has at least the following methods: public double calcPrice(String itemNumber); Returns total price: calculated by multiplying price by quantity. Need to look up the price.Use the item number array to get the index of the item number. Use the item number index to find the price from the price array. Once you have the price you multiply the price by the quantity and return the total. public String getItemName(String itemNumber); returns item name. Use the item number array to get the index of the item number. Use this index to find the name of the corresponding item. Return the name. public void setItemName(String name); sets name instance variable. public String toString() returns the string values of all the variables. Array description The first is of type String that holds the item numbers. Example: {“101a”, “ 201b”, “301c”} The second array is of type String and it holds the item name. Example: {“Flashlight”, ”scissors”, “Book mark”}; Third array is of type double that has the corresponding prices: {12.99, 4.55, 1.99};

Create a simple shopping cart application. Ask the user to input an item number and quantity. Update the shopping cart. Display the updated cart. Include the following when displaying cart: item number, name, quantity and total price. Ask for another update or end the program. Design Requires 2 classes: the main class and the cartItem class In the main class: Need one array named cartArray of type cartItem. Size = ? Need a loop that asks the user for input. Ask for item number, a string and quantity, and integer. Need to create a new cartItem from user input of item number and quantity. Load the cartItem object into the cartArray. (CartItem is a class that takes two values in constructor: item number and item quantity.) Print out all items in cartArray (item number, name, quantity, and total price) and ask user for more input. CartItem class CartItem has four instance variables. String itemNumber; String name; int quantity; double totalPrice; It also has a “database” made up of 3 arrays. Described below. The CartItem class has a constructor that takes a String(itemNumber) and an integer(quantity) as arguments. The constructor does the following: It passes the item number up to the corresponding instance variable. It also passes the quantity up to the quantity instance variable. It then calls the getItemName method to first, get the item name and then set the item name instance variable. It calls the calcPrice method to set the totalPrice instance variable by first getting the total price and then setting the totalPrice instance variable. The CartItem class Has at least the following methods: public double calcPrice(String itemNumber); Returns total price: calculated by multiplying price by quantity. Need to look up the price.Use the item number array to get the index of the item number. Use the item number index to find the price from the price array. Once you have the price you multiply the price by the quantity and return the total. public String getItemName(String itemNumber); returns item name. Use the item number array to get the index of the item number. Use this index to find the name of the corresponding item. Return the name. public void setItemName(String name); sets name instance variable. public String toString() returns the string values of all the variables. Array description The first is of type String that holds the item numbers. Example: {“101a”, “ 201b”, “301c”} The second array is of type String and it holds the item name. Example: {“Flashlight”, ”scissors”, “Book mark”}; Third array is of type double that has the corresponding prices: {12.99, 4.55, 1.99};

ITP120 (java) is my subject.

Describe whether big data or a business intelligence application that uses a relational database, is a better fit for the users at each of the three organizational and management levels.