Normalization in sql jobs
I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks super...Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Unit Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Unit Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...
...you need more information. This is a simple project, it is nothing too complicated and I am not looking for a large company to do a large project. This is something that a profecient PHP developed should be able to do in a couple of hours. I'm in need of a a user-friendly interface for students in a school to have conversations with OpenAI through the school's OpenAI account and key (configurable through a file). Through this interface, students would log in with a given username, password plus a "Session ID" (they need a valid "SessionID" to log in. Once logged in, it should basically feel quite similar to ChatGPT where they can have a conversation with the AI. There should be a backend where an administrator ...
...each project milestone. Requirements: Proven experience as a QA Tester or similar role in web portal testing. Strong understanding of software QA methodologies, tools, and processes. Experience with automated testing tools is a plus. Familiarity with Agile frameworks and regression testing is a plus. Excellent analytical and problem-solving skills. Strong communication skills, both written and verbal. Ability to work independently and manage time effectively to meet project deadlines. Preferred Qualifications: Experience with testing web applications in various browsers and devices. Knowledge of HTML, CSS, and JavaScript. Experience with bug tracking tools like JIRA, Bugzilla, or similar. Familiarity with SQL and scripting. What We Offer: Competitive project-base...
...**Project Details:** - **Current Setup:** - Website developed in Umbraco (Microsoft open-source CMS). - Backend: C# coding. - Database: MySQL. - Currently hosted on a Windows server with IIS. - **New Hosting Environment:** - Hostinger VPS with Linux OS. - SQL Server installed via command line (no GUI). - No Windows server or IIS available. **Issues Encountered:** - Umbraco runs well locally on the VPS but not accessible externally. - Unable to attach the website domain. - Issues uploading the website from a local machine to the VPS. **Requirements:** - Expertise in Umbraco CMS. - Strong knowledge of C# and MySQL. - Experience with migrating websites from Windows/IIS to Linux environments. - Familiarity with configuring SQL Server on Linux. - ...
A website used to be a WP site. It is now remade with and the new version is hosted on a new server. I need to retrieve the old information from the DB drop. When I try to add the database entries to a freshly installed WP installation and access it (either localhost or serve... used to be a WP site. It is now remade with and the new version is hosted on a new server. I need to retrieve the old information from the DB drop. When I try to add the database entries to a freshly installed WP installation and access it (either localhost or server) it immediately throws 301 error and redirects to the new kobe-oukoku website. Please add this text in the beginning of your application so I know you've read the description: kobe animal kingdom.
Project Details $30.00 – 250.00 USD I'm seeking an analyst proficient in harnessing the Amazon Seller API to extract comprehensive data and metrics essential for reporting purposes. Your primary responsibility will involve pulling detailed information from Sales, Orders, Products, Customers, and other relevant columns and sources via the API. Your expertise in navigating the intricacies of the Amazon Seller API to extract pertinent data for reporting is crucial. This data MUST be pulled into Microsoft Excel seamlessly and effortlessly. This will enable easy access and manipulation of the data for reporting purposes. The columns of data required, but not limited to are as follows: Order ID, Tracking ID, Product Name, Unit Price, Ship By Date, Deliver By Date, P...
...meticulous professional, experienced in the workings of Microsoft Access 2007, to resolve manifold errors plaguing my software application. Key Responsibilities: - Fix syntax errors, making sure the coding within the system is coherent and functional - Solve data type mismatch errors, ensuring seamless data integration - Add some of the small functionalities to the application. - Need the full application to run smooth without errors. Ideal Skills: - Commitment to meet tight deadlines as an immediate resolution is vital - Prior experience in troubleshooting errors in Microsoft Access 2007 - 2010 - Expert understanding of database structures and Sql syntax Ultimately, the freelancer should bring this software application back to its most optimal version ...
This project needs a skilled professional who is highly efficient with dbt, Databricks, Snowflake, Google Cloud Platform (GCP), Python programming, and SQL database management. Responsibilities: - Execute data transformation tasks using dbt - Process and analyze data using Databricks - Handle data storage and querying on Snowflake - Manage cloud platform setup and tasks on GCP - Implement Python programming for data manipulation - Write and manage SQL queries and database Ideal Skills and Experience: - Prior experience in the same field - Intermediate level expertise in dbt data transformation - Knowledge of Python and SQL - Understanding of cloud architectures, particularly Google Cloud Platform - Familiarity with Snowflake and Databricks Appl...
...current running containers need proper ports assigned to them. The containers connect be lost as they are for production. 2 - set up and configure three additional separate Docker groups, each for a different entity which would contain sql, Apache, and file storage. Key Requirements: - Configure 3 isolated Docker groups for Entity A, Entity B, and Entity C isolated from each other. - The setup should be designed for scalability, load balancing, and security although specific requirements for each are not yet defined Ideal Freelancer: - Proven experience in Docker containerization - Familiarity with setting up and managing production environments - Strong understanding of port assignment and management - Capability for creating isolated environments for different ent...
I need a simple C# Windows Forms management project. It has three classes: Service, Tourist and Tranzactions. It's for college and supposed to be for a tourism agency wanting to keep track of its services, tourists and tranzactions. Nothing complicated, a CRUD app connected to a SQL database, simple UI and the project has to meet the requirements from the screenshot attached below.
I'm in need of a skilled PyTorch expert who can lend their expertise to my ongoing deep learning project. Here's a breakdown of the assistance I require: - **Model Training**: I need help with training the model. This would involve working with the PyTorch framework and implementing the necessary optimization techniques. - **Data Preprocessing**: The dataset for my project is of medium size (1,000 - 10,000 samples) and it requires thorough preprocessing. I'm looking for someone who has experience dealing with datasets of this scale and can help me with data cleaning, normalization, and other preprocessing tasks. - **Model Evaluation**: Once the model is trained, I would like assistance with evaluating its performance. This would involve running tests on th...
I am in need of a data mining expert proficient in Python, machine learning, and Selenium to facilitate a data mining project. If you are interested, so there would be 2 contract fix rate $50/country flow, and $3-5/hr for code's maintainance. Depends on your profile’s experience. $5/script for easier works (like scrap-data transferring between GS&SQL), Purpose of the project: The primary objective is to extract valuable information from a large set of data. The specific type of data to be mined will be shared with the successful candidate. - Skills and Experience: - Proficient in Python - Hands-on experience with Selenium - Thorough understanding of machine learning algorithms - Experience in handling large sets of dat...
...data. Ideally, the freelancer should have a background in big data, business intelligence, and data visualization, and previous experience in dealing with customer data specifically. Tasks to be undertaken include - - Retrieving customer data from the database - Cleaning the data efficiently to ensure it is free from errors and inconsistencies - Analyzing the data to provide detailed insights - Demonstrating these insights through clear visual tools The ideal freelancer for this job would display deep understanding and experience in SQL to query and manipulate databases. Python scripting knowledge for data analysis and cleaning is a major plus. Proficiency in using data visualization tools like Tableau would also be beneficial in conveying ...
I'm in need of skilled SQL guru to support me with my project. Some of the tasks include handling database design, query optimization and data migration. Attributes and Experience Required: - It's essential you have advanced level SQL skills (more than 3 years experience). - Experienced in both basic and intermediate tasks, while also capable of tackling advanced tasks. - Database design and optimization expertise. - Proven track record in managing data migration. In your application, illustrate on your vast SQL experience. Share previous projects you've worked on. Proven expertise will be a determining factor for this job's selection.
I need to convert a conceptual ERD to a logical ERD (See attached image below). The logical ERD should only include primary and foreign keys. I need the prpject ready by 25th/26th Skills and experience needed: - Proficient in database design, specifically with MySQL - Understanding of primary and foreign keys - Familiarity with normalization forms - Ability to convert conceptual ERD to a logical ERD
I'm in need of an experienced application developer who can build a robust database application. The application will need to provide the following functionalities: - Data storage and retrieval: The application must be able to store and retrieve data efficiently, ensuring the integrity and security of the data at all times. - Data analysis and reporting: It should have built-in analytics features to generate and visualize reports based on the stored data. Understanding of statistics and data analysis tools is preferred. - User authentication and access control: The application must include a secure log-in mechanism for users, and feature robust access control settings to manage their privileges within the application. As for the type of data this database appl...
...web application. This will serve the purpose of authenticating the reports. The signed reports should be saved into a SQL Server database. Key Requirements: - Implement a digital signature feature on Crystal Report PDF files. The purpose of this is to ensure the authenticity of the reports. - The digital signing process should be automated after an approval process. - Save the signed reports into a SQL Server database. Ideal Skills and Experience: - Proficiency with ASP.NET Web Forms and C# is a must. - Experience working with Crystal Reports would be a plus. - Familiarity with SQL Server database management. - Understanding of digital signature implementation and security in web applications. I'm looking for a freelancer who can deliver a seamless a...
Currently ...upgrading the framework is the main focus. The code base is for a Web API that integrates with SQL Server. There is a separate UI front end that is not included. The current version is .Net Framework 4.5 with the following target techical Stack • ASP.NET Core 8.0 (with .NET 8.0) • ASP.NET WebApi Core • ASP.NET Identity Core • Entity Framework Core • FluentValidation • Swagger UI • GIT Key requirements: - Expertise in C# - Strong understanding of .Net architecture - Previous experience in upgrading .Net projects to ensure compatibility with modern systems. Skills: - .Net Framework - C# - Software Architecture - .Net Upgrade Experience This is an initial project with additional larger projects potentially in the ...
in your Bid, clearly answer this questions: 1. how many years of experience do u have? 2. Are you an independent freelancer? 3 do you know how to fix sql injections? - Give 2 example of how to fix sql injections in forms 4. what are the ways you can secure a payment api to protect it from spamming charges- considering that the api information is secured and spamming is not happening by any registered users but through external users 5. what are the ways you can protect smtp apis to protect from email spamming?- considering that the api information is secured and spamming is not happening by any registered users but through external users 6. What are the ways you can show thousands of data on a page? how will you implement it so that it doesn't have load...
I'm seeking a knowledgeable writer to update an under 500-word article on Visuals SQL. Key tasks include adapting the article to a manufacturing context and replacing outdated information with the latest industry trends. The desired freelancer would have experience in technical writing, specifically within the manufacturing industry, with an in-depth understanding of Visuals SQL.
...Daily Sales Report: Display daily sales data with graphical representation. o Monthly Sales Report: Display monthly sales data with graphs. o Annual Sales Report: Display yearly sales data with graphical representation. o Data Source: Multiple MS SQL databases. 2. Collection Reports o Daily Receipt Report: Display daily receipt data with graphs. o Monthly Receipt Report: Display monthly receipt data with graphs. o Annual Receipt Report: Display annual receipt data with graphical representation. o Data Source: Multiple MS SQL databases. 3. Inventory Management o Full Inventory List: Display a comprehensive list of inventory items. o Export Functionality: Export inventory data to PDF or Excel files. 4. Customer Data Analysis o Outstanding Amount...
I'm in need of a WordPress expert with advanced knowledge in both plugin and theme development. The perfect candidate for this project should have a good grasp of PHP, JavaScript and databases. Key Responsibilities: - Develop and customize WordPress plugins - Develop and customize WordPress themes - Ensure all code is high quality and maintainable - Troubleshoot and debug complex technical issues - Collaborate with other teams to create successful project outcomes - Maintain a high level of awareness of industry trends and technologies Ideal Skills and Experience: - Proven work experience as a WordPress Developer - Proficient in PHP, JavaScript, HTML, CSS and SQL - Excellent knowledge of WordPress, plugins and themes - Experience with RESTful APIs - Stron...
We are in need of a skilled software contractor to provide a comprehensive 2-week review of our existing C# and PHP code. This project involves reviewing the existing code and it's performance, efficiency, and quality. Ultimately, we need a detailed documentation on the code's state and recommendations on the necessary steps for completion. (See attached file) Key Tasks: - Review and assess existing C# and PHP code for performance, efficiency, and quality. - Identify completion steps. - Create detailed document outlining current state and necessary completion steps. - Recommend testing Ideal Skills and Experience: - Proficiency in C# and PHP. - Experience developing SQL database applications (MySQL is preferred) - Extensive experience in ...
I am in need of an experienced SQL database administrator to help me move an entire SQL database from one server to another. The new server has Windows Server 2012 R2 installed and the SQL software is up and running. However, I am unsuccessful in attempting to access this via the network. Key Tasks: - Transfer the entire SQL database to a new server - Setup proper network access - Continue all ongoing operations from the source server on the new server Ideal Skills: - Rich experience with SQL and Windows Server 2012 R2 - Understanding of maintaining active operations during server shift - Firewall setup and operations Security isn't to be compromised during this relocation. The current server has a firewall in place for the ...
1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page
We have built a customized website in core php and need another experienced developer to join the team to fix some bugs, We are looking for a very experienced php developer for our project, you must have at least 12-15 years of experience with a good reference . Must have experience in multi-user programming, must know how to do quality coding, fix sql injections Conditions: You must be a independent freelancer. and share with some of your customized applications that u have worked on.
I am working on React JS with Javascript Development Project. I need someone to Support me for this Project atleast 4 to 5 hours Per day. Project will Exist more than 2 years. I need support through Remotely(zoom). I am looking for Good Experienced(4+ years) Person as a Frontend Developer, Who can work on the tasks Quick...the tasks Quickly. I am looking for Long term relationship. After this Project Completed means, we will give immediately another support project. I will Give you the Sample Task on Cypress Test Cases for 30 mins, If you Completed ON TIME means we will give you the Project. Cypress Test Cases Immediately Required. Required Skills : React JS, HTML, CSS, Javascript, Cypress Test Cases(Mandatory), SQL Basics Language Speaking Person : English Note: I will pay on ho...
1 Need to build a website monitoring program to monitor changes in sub-pages of the landing page Detailed requirements: The website needs to have SQL function because batch site monitoring needs to be uploaded. 2 Identify the link to the final sub-page login keyword such as Proxy function and mobile phone UA because mobile phone batch UA is required Multi-thread monitoring 3 Filter duplicates and monitor changes in subpages of the website Set a custom time to refresh the web page 4 Send the new URL of the subpage change to the created group through the telegram machine
I'm looking for a Python expert who can help me preprocess and normalize a CSV dataset for a machine learning project. Key Responsibilities: - Loading the CSV dataset - Adjusting timestamps - Merging data from a single file - Normalizing the data using Min-Max scaling Ideal Skills and Experience: - Proficient in Python programming - Solid understanding of data preprocessing techniques - Experience with handling and merging large datasets - Familiarity with statistical analysis and machine learning modeling This project is crucial for setting a solid foundation for the subsequent machine learning analysis. The freelancer who takes on this role should be able to execute these tasks accurately and efficiently, with a strong eye for detail.
I am in need of a skilled developer to assist with an existing API integration between SilverStripe website and REX Software, with a focus on correcting a data issue that is causing the server to fail with backing up the website due to disk usage. The server technician said: "The disk usage is at 80% so a dump would fail as it would need more space to create a sql file to be transferred. It looks to be an issue with REX and the website framework SilverStripe. It may be that REX is not configured to remove (dump) old data." Your role will involve correct the error so the server does not continue to reach its disk usage and implementing a seamless API integration that successfully synchronizes and updates property listings between these two platforms. Ideal Skills...
I'm running a Node.js website where the last user's data is mi...promptly. Key Responsibilities: - Investigate the current data display functionality and how it's handling user data. - Correct the code responsible for showing the last user's data to the first user. - Ensure that the correct user data is displayed to each respective user post-login. Ideal Freelancer: - Proficient in Node.js with a deep understanding of data management and display. - Experienced in SQL databases, specifically in managing user data. - Previous experience in debugging and resolving similar issues is a plus. - Deadline-oriented and able to work efficiently to resolve this issue. Please refer to the attached video for better understanding of the issue. Yo...
... employing best practices in continuous integration and deployment to maintain system integrity and performance. Documentation and Support - Produce detailed documentation and user guides for the system architecture, API interfaces, and operational procedures. Provide ongoing support and troubleshooting to ensure system stability and user satisfaction. Essential Skills and Qualifications: - Expertise in using Visual Studio for software development, including .NET and PHP programming. - Proficiency in Azure DevOps for project lifecycle management, including CI/CD pipelines and agile project management. - Experience with Microsoft Azure, especially Azure Service Bus and Azure Functions. - Strong knowledge of database management with MySQL and SQL. - Abili...
I need a small application prototype with the following features: Multi-Employer Job Portal/Admin app (Role Based access) User/applicant App (for Multiple applications to different employers) User Profile Document Upload (Save documents to Db and attachments to Blob Storage ) Send Emails to Employers and applicants back and forth 2 Apps in total ie. admin app and applicant app. job application requirements will be provided. Nodejs, angular, My SQL, ORM, Data Seeding, Migrations should be used.
Request details FOR EXPERTS WITH EXTENSIVE EXPERIENCE IN THE FIELD ONLY Objective: Scoring Algorithm for evaluating potential investments Data Source: 200+ proprietary historical records with up to 90 parameters Mentoring requested (to be worked with tech project lead and data engineer): • Data-Preprocessing (missing values, normalization, outliers) • Implementation methods for feature selection (e.g. correlation Analysis, feature importance, etc.) • Identify and run different algorithms (e.g., logistic regression, decision trees, random forests, gradient boosting, neural networks) • Details and rationale behind algorithms selection • Hyperparameter tuning and optimization • Cross-validation • Performance metrics (e.g., accuracy, precisio...
I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration
I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.
I'm in need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the abilit...
In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous and asynchronous messaging. We anticipate a low scale of message traffic, not exceeding 1,000 messages per day. Key responsibilities will include: - Setting up ActiveMQ for JMS messaging - Configuring it to handle synchronous and asynchronous messaging effectively Furthermore, I plan to utilize SOAPUI Open Source for automated testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences fo...
Looking for help in modifying an existing python script and related sql database table The current script - (1) scrapes company financial data from website and populates database (2) scrapes news related to keywords from google news (3)sentiment classification of news items (4)pushes data to sql database The company names and keywords are currently hardcoded in the script Requirement- (1) Company names/urls/keywords (will be provided) to be put in master table in the database (2) The script to loop through and scrape the relevant data and put in database
I'm looking for a freelancer who's great at web scraping to help with a project involving a specific website initially, with potential for more. I'll give you the specific data fields to extract. It'd be great if you: Are really good at web scraping and or Python. Know your way around MS SQL Server databases, not essential but definately an advantage. Understand how to extract data effectively. Understand the need for security and captcha integration if needed. Can work quickly since this project is a priority and needs to be done ASAP. Ultimately, I want to be able to manage the code with your ongoing help, so this could lead to a long-term partnership. I'll share the full details when needed. You will provide source code, documentation and deployment info...
Required a dot net developer. Speacialized in Microservices acrhitecture based solution. Dotnet Core, C#, SQL, Data transformation, API gateway, Auth based security.
...seeking a full stack PHP developer to assist me with my project. I'm looking for a PHP expert who can aid in the development of a web application, website, or mobile app. You should be proficient in both front-end and back-end development, capable of crafting user-friendly interfaces and integrating complex functionalities. Your role will involve: - Understanding project requirements and delivering high-quality work - Developing secure, efficient, and scalable code - Implementing user authentication, integrating databases, and possibly setting up payment processing systems - Ensuring timely and reliable completion of the project If you are a skilled PHP developer with experience in full stack development and are passionate about producing high-quality appl...
...installing python, setting SQL for our applications and Google Sheet. For each country may need API for such as : 1. Historical Data 2. Financial Scrapped Source 3. Financial Summary Scrapped Source 4. Interest rate 5. Some More Required Skill & Experience : 1. Php & SQL 2. Familiar with python installing & setting up environments 3. Experienced in Linux Debian & LNMP server by SSH 4. You need to know on how to run python scripts on debian by ssh, and setup cron task on debian, and debugging etc Personality's Criteria : 1. No toxic working environment 2. Agile, Responsive, and Fast Delivery 3. Collaborative as a team 4. Responsible, Credible, Reliable and Integrity person 5. No agency, only direct hiring ------ I'm looking for a skille...
...`11_bkntc_services` table in the database. (I use the Booknetic Plugin for Game Bookings) The table looks like this image, so you will have to use case insensitive SQL to find the `11_bkntc_services` WHERE name is PARTIALLY equal to the "Projects name" (2nd Image) as I have multiple actual games per "Project" The WP page in question is Https:// The "Book Now" button uses the code in the image below found in this file: wp-content/themes/gamico/template-parts/project/ to show the Booknetic category based on the game. ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Ideal skills for this project: - Strong experie...
...Implementation: - Set up a CI/CD pipeline using GitHub Actions for automated testing, building, and deployment of both frontend and backend applications. - Integrate the pipeline with our GCP infrastructure, including Compute Engine, Cloud SQL, and Cloud Storage. 2. Logging Setup: - Configure logging for all services: -- Frontend (Nginx, ): Log HTTP requests, errors, and application logs. -- Backend (Gunicorn, Django): Log application errors, access logs, and system logs. -- Celery and Beat: Log task execution and periodic tasks. -- Database (Cloud SQL): Log database queries and errors. -- Redis (Cloud Memorystore): Log Redis operations. - Collect and store logs centrally using GCP's Stackdriver Logging. - Set up log rotation and retention policies. 3. HTTPS Domain...
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days you provide code to simulate input data (both code versions: python and sql)-> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78, 5, 23, 41. When 34 for 20%; 65 for 30%; 12 for 40%; 78 for 10%; 5 for 15%; 23 for 70%; 41 for 30% randoml...
We are looking for 5-10 years of .Net experienced developer who can also have experienced in React and .Net based web development. Long terms multiple projects development. Using Mainly Azure SQL server database with Visual Studio .Net Core API. Graph QL and EF. Worked on Azure Key Vault, Azure Logic app, Azure function is bonus.
use Oracle PL SQL teach me how to install free Oracle DB on my local windows 11 acceptance: I can run your code on my computer ; all code work on my computer when I run it by myself You have 2 days *****you provide code to simulate input data -> transactions data *****you provide SQL code to calculate per day summary for each day for each product for each store for 3 years SIMULATION data for 3 years 100 products 20 stores 5 USA states randomly 30 to 170 transactions per day for given product for usual price randomly 200 to 600 transactions per day for given product for promotion random dates and prices promotion for 30 promotions per year , each promotion happen for 7 to 15 products, for example promotion at may 10, 2023 happen for product ids: 34, 65, 12, 78,...
...ready, and the SQL tables have been set up. The main features of this project include: - **Dashboard:** This should display data from the other 3 pages in a list format as well as in a bar chart. - **Page 1 - Callback List:** A simple list of data from the 'callback' table. - **Page 2 - Token List:** A simple list of data from the 'token' table. - **Page 3 - Name List:** A simple list of data from the 'name' table. For the dashboard, I'm looking for a clean, professional design and prefer the use of bar charts for the graphical representation of the data. User authentication should be straightforward, requiring only an email and password for access. Ideal Skills and Experience: - Proficient in Laravel - Experience ...
