# Statistics in Pivot tables. Choose any one: 1. The Excel

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)

DATABASE CREATION

Criteria Excellent (5) Good (4-3) Satisfactory (2-1) Unsatisfactory (0) Rating

Information is Most information is Some information There is no clear plan

organized in a organized in a is logically for the organization

Relevance of clear, logical way. It clear, logical way. sequenced. of information.

information in is easy to anticipate Some information

the database the type of material seems out of place.

that might be in

other tables.

All tables are All tables are All tables are Few tables are only

Tables present in the

database with a present in the

database with present in the

database. created.

and a total of 10 number of records

records has not been met.

Database shows Database shows Database shows Database is a rehash

considerable some originality an attempt at of other people’s

inventiveness. The and inventiveness.

The content and originality and

inventiveness. ideas and shows very

little attempt at

content and ideas ideas are presented original thought.

are presented in a in an interesting

unique and way.

interesting way.

demonstrates demonstrates able to apply have only been

understanding of understanding of foreign keys applied and is not

foreign keys, foreign keys and accurately, did not complete.

primary keys, and primary keys, but follow relationship

protocol by creating relationship

a relationship table protocol with one of

with foreign keys the Directories.

identified.

ENTITY- RELATIONSHIP DIAGRAM

Criteria Excellent (5) Good (4-3) Satisfactory (2-1) Unsatisfactory (0) Rating

Logically designed Exhibited adequate Exhibited a partial Exhibited minimal

the database understanding of understanding of understanding of

Overall Crow’s Foot Model design exhibiting a firm understanding

of Crow’s Foot Crow’s Foot database design

and manipulation. Crow’s Foot database design

and manipulation. Crows’s Foot database design and

manipulation

notation

Implementation Completely populated tables with correct data elements reflecting the ERD design Populated tables with majority of data elements outlined in the ERD design Populated tables with minimal data elements defined in project the ERD design Populated tables with minimal data elements defined in project the ERD design which have

errors  in hrm assignment help

TECHNICAL REPORT

Criteria Excellent (5) Good (4) Satisfactory (3) Unsatisfactory (2-1) Rating

Quality of Work Professional

Appearance, work

is submitted on

Time. It is

systematic and met

the requirements of

the assignment. Elements of Elements of Poor work,

formatting have formatting have submission was late.

been proficiently been sparingly Did not meet the

used, Document used, Document requirements exactly.

Submission on time was delayed

TOTAL

PRESENTATION AND TEAM WORK

Criteria Excellent (5) Good (4) Satisfactory (3) Unsatisafactory Rating

Presentation Effectively exchanged ideas, used brainstorming for creative solutions to issues, had group commitment to a common goal and effectively planned a course of action.

Proficiently exchanged ideas for coming up with solutions to issues, group commitment to a common goal and proficiently planned a course of actions  Delivery time of information needed to be more smooth, exchange of ideas was limited  Poor delivery and timing of information

Discussion needs to be more controlled and dynamic.

Teamwork 1.The project was carried out by more than TWO members

2. The work load and variety on each member seems fair

3. Leadership role being assumed by each member for different tasks is evident

1. The project was carried out by more than TWO members

2. The work load and variety on each member seem fair

3. Leadership role being assumed by each member for different tasks is NOT apparent 1. The project was carried out by more than TWO members

2. The work load and variety on each member seem fair

3. Leadership role being assumed by each member for different tasks is NOT apparent

1. The project was carried out by more than TWO members

2. The work load and variety on each member does not seem to be fair or at least one member has been assigned trivial non-technical tasks (e.g. writing the report)

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Project Management: Work Breakdown Structure

From the project topic document you submitted and incorporating any suggestions for improvement from your instructor, craft a project scope for your project. Your text

### 5- to 6-slide PowerPoint presentation that can be used in

5- to 6-slide PowerPoint presentation that can be used in a staff development meeting on presenting different approaches for implementing the stepwise approach for

### ONE episode of the TV program: “The First 48.” This

ONE episode of the TV program: “The First 48.” This program is aired on the A&E Channel. You can also view full episodes on the

### THIS IS A HYPOTHETICAL PROJECT. YOU ARE NOT REQUIRED TO

THIS IS A HYPOTHETICAL PROJECT. YOU ARE NOT REQUIRED TO SPEND MONEY ON THIS PROJECT. I would hope that you would find an activity

### Module 5 Case Study – Jasmine

Introduction This case study will allow you to apply the information that you have learned regarding the identification and treatment of Schizophrenia and Psychotic Disorders.

### least 400 words must then post 2 replies of at

least 400 words  must then post 2 replies of at least 150 words students must support their assertions with at least 3 scholarly sources in

### RESPONSE / ASSIGNMENT –(3) thorough thought questions + responses related to

RESPONSE / ASSIGNMENT –(3) thorough thought questions + responses related to week 1 readings(100 words each) –(1) source described and well-situated in 500 words (include

### Research the changing role that OxyContin and other opioids have

Research the changing role that OxyContin and other opioids have had in society. What legal changes have been made to control for the addictive side

### Required Resources Read/review the following resources for this activity: Textbook: Chapter 8

Required Resources Read/review the following resources for this activity: Textbook: Chapter 8 (section 8.3), 11 Lesson Minimum of 1 scholarly source (in addition to the

### LEARNReadings From Healthcare Finance: An Introduction to Accounting and Financial

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along

### Introduction O’Keefe State University located in New Mexico has recently

Introduction O’Keefe State University located in New Mexico has recently started using Canvas for online course delivery. Canvas hosts all the data in its

### Evaluate a survey to measure the attitude of hospital employees

Evaluate a survey to measure the attitude of hospital employees regarding patient safety. The survey can be found as part of Case 15.1 (Zikmund et

New questions