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
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.
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 acc
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
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
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 (
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
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,
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
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
