# Statistics in Pivot Tables

Statistics in Pivot tables. Choose any one:

1. The Excel file Freshman College Data shows data for four years at large urban university. Use Pivot tables to examine differences in high school GPA performance and first year retention among different colleges at this university. What can you conclude? Please use graphs to support your conclusions.

Measure of Association

1. The Excel file Beverage Sales lists a sample of week day sales at a convenience store along with the daily high temperature. Compute the correlation between temperature and sales. What can you conclude? Please use a scatter diagram to support your conclusions.

Outliers

1. In the Excel file Weddings, find the mean, median and standard deviation of the wedding costs. What would you tell a newly engaged couple about what cost to expect? Consider the effect of possible outliers in the data.

General Instructions:

1. Do the following programs using SQL Developer and prepare a documentation of all the programs along with their output.

2. You will have to execute these programs followed by a brief question answer session.

4. A maximum of two members can be in one group.

5. The submission deadline: December 5th, 2021

6. Late submission will have marks deduction, per day 2 marks will be deducted

7. Plagiarism report has to be attached and should not exceed 20%

8. No two projects should be academic writing service the same. Similar or copied projects will be awarded zero marks.

Imagine that you are a Database Programmer working in a software company. Your company has assigned the programmers to choose from several projects for their clients. Choose any one project and prepare the appropriate requirements to build the system using SQL. (55 marks)

1. COLLEGE DATABASE: A college contains many departments. Each department can offer any number of courses. Many instructors can work in a department, but an instructor can work only in one department. For each department, there is a head, and an instructor can be head of only one department. Each instructor can take any number of courses, and a course can be taken by only one instructor. A student can enroll for any number of courses and each course can have any number of students.

2. LIBRARY MANAGEMENT SYSTEM: A student and faculty can issue books. The number of books a student and teacher can be issued will vary. In addition, the number of days will be distinct in the case of students and teachers for issue of any book. Each book will have different ID. Each book of the same name and same author (but the number of copies) will have different ID. Entry of all the books will be done, as to who will issue that book and when and should include the duration. Detail of Fine (when the book is not returned at a time) is also stored.

3. PAYROLL MANAGEMENT SYSTEM DATABASE PROJECT: There will entry (Unique ID) of all the employee of any Organization. According to the date of joining and date up to which salary is created, Number of days will be entered. Basic pay will be defined according to the post of employee and department. Then component like DA, HRA, medical allowance, Arrears will be added, and Charges of car, Security, GOSI and other will be deducted. The number of leaves taken by the employee should also be included.

REQUIREMENTS

1. Design the database for any one given Scenario with the help of SQL Developer using appropriate DDL and DML commands. (20 marks)

2. Construct an Entity Relationship diagram describing the relationships that exist on the database. (10 marks)

3. Create at least 5 relevant queries to display details for the above database (10 marks- 2 marks for each correct query)

4. Technical Report: A documentation of the project has to be submitted with the various commands used in DDL and DML applicable to this project. Snapshots of the tables, output of the commands and queries with clear explanation wherever needed. (5 marks)

5. A. PRESENTATION AND B. TEAMWORK(10 MARKS)

Pages (550 words)
Approximate price: -

Why Work with Us

Top Quality and Well-Researched Papers

Our writers are encouraged to read and research widely to have rich information before writing clients’ papers. Therefore, be it high school or PhD level paper, it will always be a well-researched work handled by experts.

For one to become part of our team, thorough interview and vetting is undertaken to make sure their academic level and experience are beyond reproach, hence enabling us give our clients top quality work.

Free Unlimited Revisions

Once you have received your paper and feel that some issues have been missed, just request for revision and it will be done. In addition, you can present your work to the tutor and he/she asks for improvement/changes, we are always ready to assist.

Prompt Delivery and 100% Money-Back-Guarantee

All our papers are sent to the clients before the deadline to allow them time to review the work before presenting to the tutor. If for some reason we feel our writers cannot meet the deadline, we will contact you to ask for more time. If this is not possible, then the paid amount will be refunded.

Original & Confidential

Our writers have been trained to ensure work produced is free of plagiarism. Software to check originality are also applied. Our clients’ information is highly guarded from third parties to ensure confidentiality is maintained.

Our support team is available 24 hours, 7 days a week. You can reach the team via live chat, email or phone call. You can always get in touch whenever you need any assistance.

Try it now!

## Calculate the price of your order

Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

You have had a hectic day, and still need to complete your assignment, yet it is late at night. No need to panic. Place your order with us, retire to bed, and once you wake up, the paper will be ready.