Category: Graduate

Mysql online data base

Must develop and ERD diagram for an Online retail business of choice. The retail business must be able to collect CC payments. At minimum the developed relational database must collect and store the following information;
    Stock
    Customer Details
    Orders
    Suppliers
    Payments
    Returns

Using the ERD diagram that was developed earlier in Part A now expand upon the original ERD and develop and populate a real life Relational Database to hold their business data and ALSO a Data Mart to support the reporting requirements of the retail company.

In order to implement this Data Mart students are required to automate the loading of the data from the live production database to the Data Mart. This should be done by scripting.

Project Report Document
a.    Background Information Document and relevant graphs connected via Excel to 2 reports of YOUR CHOICE
b.    Script File to Create the Data Mart database and tables and the following reports
c.    The Data Mart SHOULD ONLY CONTAIN results only from Views  (Questions 1, 3 and 4 ONLY)

1. Create a View showing all transactions for a given week in your business.
2. Create a trigger that stores stock levels once a sale takes place.
3. Create a View of stock (by supplier) purchased by you.
4. Create a View of Total stock sold to general public (group by supplier).
5. Detail and total all transactions (SALES) for the month-to-date. (A Group By with Roll-Up)
6. Detail and total all SALES for the year-to-date. (A Group By with Roll-Up)
7. Detail & total transactions broken down on a monthly basis for 1 year. (A Group By with Roll-Up)
8. Display the growth in sales/services (as a percentage) for your business, from the 1st month of opening until now.
9. Use Excel to create a graphical representation of any 2 of the queries of YOUR CHOICE, for example Q1 & Q4. (Any type of graph)
10. Add both the SQL statements and graphs into a Word document report (Your SQL code and the screenshots and relevant graphs & ERD Diagram). The Word document must show the results of your queries when run (Screen shot of the Output).

Technical assessment

Please find the description of the assignment saved as PNG file in the additional materials below (‘Assignment brief’)  I will not require any help with requires to the literature review i solely need help developing a business case from the two excel sheets attached below.

visual studio

1. INTRODUCTION MiHotel is a mid-range hotel chain that started in Traverse City, Michigan in 1980. The chain offers three star service and moderately-priced rooms at its 15 hotels throughout Michigan. MiHotel has plans for a major expansion, building three new hotels in the next three years. As a part of the expansion, the company will be hiring dozens of employees for each new hotel. MiHotels Human Resources (HR) department has decided that the existing online application process is insufficient to handle the demand created by the companys expansion plans. As such, they have decided to implement a new applicant processing system to better meet the needs of their growing company.

2. Background In meeting with the parties involved in creating this system, you realize that people from different departments need to have different levels of access into the system. That is, employees in HR should not have the same screens or access to data that a hotel manager would have, or the access that executives would have. At the same time, the manager from hotel A should not be able to see the data from hotel B. The departments needed for this assignment: HR, Hotel Managers, Executives.

The first part is to think about the flow of logging in. This is something you’ve done over and over, but likely haven’t thought about. The users put in their user ID and password and the system determines which department they work and sends them where they need to go. For this part, you will set this up something like “if user is jsmith go to department XYZ”

3. Assignment

A. Create a flowchart or write out pseudocode for how you are going to control access to the system. Do not worry about specific users, just the department in which they work. (Later in the course we will learn how to authenticate users from a database and retrieve the department in which they work.)

B. Create a new project in Visual Studio, design the form(s) needed to implement your logic from part A. You may hard-code the departments in the decision portion of your code. Submit: a Word document containing your pseudocode/flowchart, screenshots of your screens with the project running, a copy of your code.

Enumerative Combinatorics and Mathematical Induction Principle

Read the assignment before bid, the first 3 question just need a brief description of why.

The other ones should be made step by step and all fully explained in detail.

The assignment is on the files, you can use the doc to put the resolution

PHP JavaScript – SQL – Social Network Analyser

I need some modifications on some code, the code is a social network analyser fully functional, for facebook, youtube, twitter and instagram, I need some small rearrangements on the APIs and also 3 new directory pages for facebook youtube and tweeter, at the moment I just have Instagram directory, also I need to add some new features to the APIs like show country, and audiences from youtube. Check the zip file.

Changes:

-Add country to Instagram accounts and search filter on directory page

Create:

– Create directory pages for YouTube, Facebook, Tweeter, with the must search fields possible

– Add new components using the APIs to the social networks when possible.
    – Country (possible on YouTube API already saving on the database)
    – Audience (target Audiance) (possible on YouTube API)
    – Category (possible on YouTube API)
    – function to add these fields manualy or edit previours existing fields on admin area list of users

– Function to add ppst videos etc to the favorites and see a small report (number of views and comments)

PHP JavaScript – SQL – Social Network Analyser

I need some modifications on some code, the code is a social network analyser fully functional, for facebook, youtube, twitter and instagram, I need some small rearrangements on the APIs and also 3 new directory pages for facebook youtube and tweeter, at the moment I just have Instagram directory, also I need to add some new features to the APIs like show country, and audiences from youtube. Check the zip file.

Changes:

-Add country to Instagram accounts and search filter on directory page

Create:

– Create directory pages for YouTube, Facebook, Tweeter, with the must search fields possible

– Add new components using the APIs to the social networks when possible.
    – Country (possible on YouTube API already saving on the database)
    – Audience (target Audiance) (possible on YouTube API)
    – Category (possible on YouTube API)

– Function to add ppst videos etc to the favorites and see a small report (number of views and comments)

Data Analytics

The main aim of the assignment is to use the data exploration and analysis techniques learned during the course to explore a variety of datasets and apply appropriate data analyses to them.  There will be five exercises:
two data-based exercises (exercises 3 and 4)
The fifth exercise focusses on reporting and will use modern data-friendly reporting tools to combine the first four exercises into a single report

big data

Hello,

I have my assignment. Can you help me with that?
Attached is the assignment. and I am providing you my course website for the dataset zip file. Please let me know as soon as possible.

Website: http://www.eli.sdsu.edu/courses/spring20/cs696/assignments/index.html
Please check the 2nd assignment. The data dictionary is also given on the website.
I want it in only pandas. I will do the remaining part.
Note that there are columns that are not provided in the data dictionary. Eg. ‘pickup_longitude’,’pickup_latitude’,’dropoff_longitude’,’dropoff_latitude’.
You can only take as many columns as needed to solve the assignment.

Below are some links which has all reference answers
https://nbviewer.jupyter.org/github/vaexio/vaex-examples/blob/master/medium-airline-data-eda/airline-original-data-conversion.ipynb
https://nbviewer.jupyter.org/github/vaexio/vaex-examples/blob/master/medium-nyc-taxi-data-eda/vaex-taxi-article.ipynb

Kind Regards,
Yogesh

Data Analytics Assignment

The main aim of the assignment is to use the data exploration and analysis techniques learned during the course to explore a variety of datasets and apply appropriate data analyses to them.  There will be five exercises:

    Four data-based exercises based on the key topics covered in the course o data import and handling, data exploration and visualisation, o multivariate regression, o comparing groups and hypothesis testing, and o Design of Experiments (DoE).
    The fifth exercise focusses on reporting and will use modern data-friendly reporting tools to combine the first four exercises into a single report

Data Analytics Assignment

The main aim of the assignment is to use the data exploration and analysis techniques learned during the course to explore a variety of datasets and apply appropriate data analyses to them.  There will be five exercises:
    Four data-based exercises based on the key topics covered in the course o data import and handling, data exploration and visualisation, o multivariate regression, o comparing groups and hypothesis testing, and o Design of Experiments (DoE).
    The fifth exercise focusses on reporting and will use modern data-friendly reporting tools to combine the first four exercises into a single report