Essay on Assignment SQL

Submitted By jmacwei
Words: 565
Pages: 3
Open Document
Individual Assignment 1 - SQL
BUMK 758W
Spring 2015
Overview
In this assignment, you will work on the reviewer viewership dataset. You will perform a list of tasks using
SQL to retrieve relevant information in desired format, and to organize data. This is an individual assignment.
You are not supposed to discuss the problems with any other students.
The dataset is provided to you in two excel files available at ELMS. The schema is as explained in the lectures. You will use SAS for this assignment. If you use another DBMS, please ensure the SQL statement you submit can run in SAS.
Assignment
Each of the following questions should be answered using SQL statements. Unless otherwise noted, you are free to use one or multiple SQL statements for each question. Intermediate data may be used if you prefer
(e.g. creating an additional column)
Part I, Preliminary
You should begin by importing the two excel files into SAS. This will create two tables. To maintain consistency across the class, please name the reviewer characteristics table “Reviewer”, and the content viewership table “Content_Viewership” (they are so named for the two files). Once the tables are created, you are ready to answer the following questions.
Part II, Basic Tasks (8 points)
1. How many reviewers are there in the dataset?
2. What is the average daily Viewership, Content, and Centrality across all reviewers (words with first letter capitalized indicates it is the name of a column, same for below)?
3. How many reviewers are both Advisor and Top50?
4. What are the top five daily Viewership numbers, for which reviewer and on what Date?
5. Who are the top three Advisors with highest average Centrality?
6. Do Top50 reviewers have higher average Content than Advisors?
7. Create a table “Date” to store all the Dateids and Dates in the viewership dataset (you need to populate the table with the records). How many different days are there in the dataset?
8. Create a table “Lead” with one record for each reviewer who is a Lead, which contains information on the average Viewership, average Content, and average Centrality of that reviewer.

Part III, More Advanced Tasks (12 points)
9. Does the group of reviewers who are Top10 or Top50 have higher
Show More

Related Documents: Essay on Assignment SQL

Assignment Of Structured Query Language

Structured Query Language – Assignment 2 – Semester 1, 2011 Due: 25-MAY (Week 13) For this assignment, you will need access to an Oracle database user account (such as HR or oraNN). SQL428-A2-201110-setup.sql Your Tasks: 1. Triggers A client needs to manage: creating customers, deleting customers and other administration of the customers table. We also need to keep an audit log of changes to the customers table in a table called cust_audit; you will be provided with code to create the audit…

Words 577 - Pages 3

Unit 1 Research Essay

Unit 1 research assignment 1: 1. SQL Server Release History Version Year Release Name Codename 1.0 (OS/2) 1989 SQL Server 1.0 (16 bit) - 1.1 (OS/2) 1991 SQL Server 1.1 (16 bit) - 4.21 (WinNT) 1993 SQL Server 4.21 SQLNT 6.0 1995 SQL Server 6.0 SQL95 6.5 1996 SQL Server 6.5 Hydra 7.0 1998 SQL Server 7.0 Sphinx - 1999 SQL Server 7.0 OLAP Tools Palato mania 8.0 2000 SQL Server 2000 Shiloh 8.0 2003 SQL Server 2000 64-bit Edition Liberty 9.0 2005 SQL Server 2005 Yukon 10.0 2008 SQL Server 2008 Katmai…

Words 496 - Pages 2

Essay on Syllabus: Sql and Utd

word processing software, electronic spreadsheet, personal database software, network applications such as e-mail and World Wide Web). Course Description The main objective of the course is to understand relational database theories, industry standard SQL, and database design. A conceptual/semantic data modeling with the entity-relationship diagramming technique is also covered. Student Learning Objectives/Outcomes Development of Knowledge Foundation MIS 6326.0W1 Page 1  Students will be able to…

Words 2211 - Pages 9

Create The SQL Commands For Creating The Employer

POS410 - WEEK 2 INDIVIDUAL ASSIGNMENT STUDENT NAME Josh Luster Folks, you need to show at least two portions for each requirement: 1) the SQL code used to satisfy the requirement and 2) a screenshot showing that the SQL Code executed properly in SQL Server. See the bottom of this document for an example of a SQL code followed by the screenshot. ASSIGNMENT REQUIREMENTS After each of the following requirements, please paste the appropriate material: 1) Show the SQL Commands for creating the…

Words 847 - Pages 4

Comp: Sql and Sql Database Engine Essay example

SQL Proprietary extensions Reasons for proprietary extensions When everyone is said in done, SQL explanations train SQL database engine concerning the coveted end-state condition, yet don't need to provide orderly strategy to the engine. For example, in taking care of a SELECT explanation, the database engine system may redden buffers, interpret sectors from disk, unclean write caches, go after linked lists, and so on., none of which the software engineer need to know. However with most SQL engines…

Words 819 - Pages 4

Client Server Configuration

Unit 7. Assignment 1. Client Server Configuration I would recommend a SQL Client/Server database system. Client/server systems are constructed so that the database can reside on a central computer, known as a server, and be shared among several users. Users access the server through a client or server application: In a two­tier client/server system, users run an application on their local computer, known as a client, which connects over a network to the server…

Words 338 - Pages 2

Essay about Web Application Attack Scenario

Assignment 1: Web Application Attack Scenario (Student’s Name) (Professor’s Name) (Course Title) (Date of Submission) Introduction Web applications are nowadays serving as a company’s public face to the internet. This has created the need to identify threats and attacks directed to data servers and web applications. Hackers exploit vulnerabilities in input validation and authentication affecting the web application in order to gain illegal access and disclose sensitive data or manipulate it…

Words 1076 - Pages 5

Mt 5210 Unit 4 Paper

Unit 4 Written Assignment Anonymous Department of Computer Science, University of The People MSIT 5210: Databases Giri Anandhi February 29, 2024. Author Note: My paper is written and cited in APA7 format via the guidelines from Purdue OWL Online Writing Lab. My name is listed as "Anonymous" on the cover page since our Written Assignments are meant to be a double-blind system. Thank you for assessing my work. For Your Reference: My target organization is Amazon. ________________________________________…

Words 1849 - Pages 8

2015 02 10 Essay

SIT322 Distributed Systems Assignment 2 All 3 assignments in this unit involve creating and building upon a Customer Relationship Management (CRM) system for a nation-­‐wide logistics company. In Assignment 2 the CRM system will have additional membership functionality with an associated database. Assignment 2 involves development…

Words 1345 - Pages 6

Assignment 3: Oracle Table and Query Essay

Assignment 3: Oracle Table and Query Bradley Wallace Strayer University Professor Mark Cohen CIS-111 January 27, 2013 This paper is to show how I created an Oracle Table with three columns and input five records into it also ran a Query to show all the input. First launch the putty application and open the one for our class that we created in week one. Sign into Oracle and input the command line (sqlplus [userID]@orcl/[password]) to reach the prompt that reads SQL>…

Words 469 - Pages 2