Normalization in database with example tablesdela
I'm seeking an experienced SQL mentor to help elevate my skills to an advanced level. I wish to focus on: - Writing complex Queries - Data Normalization - Database Architecture - Stored procedures - Functions I primarily work with MySQL and SQL Server, so a good understanding of both platforms is essential. You should be able to provide practical examples and implement real-world scenarios in our lessons. Knowledge transfer and clear communication are vital, as I aim to thoroughly understand and apply these advanced SQL techniques.
I'm looking for an experienced developer with AWS skills to create a website for an Interactive App Performance Monitoring Tool. The site should have a clean and simple design. I need someone who can build a user-friendly website to visualize and analyze app screen rendering latency data from AWS CloudWatch. The goal is to make monitoring easy and intuitive. The website should be easy to use for people who aren't familiar with metrics and graphs. We have data for each screen rendering and want to display it in a more interactive way than just tables or charts. Basically, I want a website where you can see the app's workflow like a flowchart, with metrics displayed on each screen. Users should be able to select date ranges and view statis...
Prosimo, vpišite se ali se prijavite za več podrobnosti.
I'm in need of an Oracle database expert versed in advanced database design. Your tasks will encompass creating a comprehensive design that incorporates stored procedures, views, triggers among others. The database structure is complex, therefore demanding a mastery of the aforementioned advanced concepts. The ideal candidate should: - Have demonstrable experience in Oracle database design. - Be proficient in forming complex relationships between multiple tables. - Show competency in creating stored procedures, views, triggers, and other advanced database features. Your understanding of our needs and execution will greatly influence our company's operational efficiency.
I am in need of a skilled WordPress developer to create a website that functions as a comprehensive database. While I've not made final decisions on content type for inclusion in the database, it's crucial that your development skills allow for the flexibility to accommodate text-based articles, images and videos, as well as user-generated content. A primary factor I am focusing on during selection is your experience. Please provide detailed elaboration of your past experiences in this field. I need someone who is well-versed in WordPress and database website creation. Functionalities for the website/database are yet to be decided upon. However, key skills I anticipate needing include the ability to implement a user-friend...
I need an Excel expert for creating an inclusive internal database. You'll work with a variety of data formats including text, numbers, and dates. Your tasks will include: - Importing data manually, from files, and through web scraping. - Ensuring that the Excel database houses all the necessary data we collect. It's important that you're skilled in data entry, file importation, and web scraping, because we're working with data from files and possibly scrapped data. Knowing your way around Excel and managing a large amount of data is a must for this job. Your expertise in database management can help streamline our work processes.
I'm in immediate need of a skilled SQL dev who can assist me in resolving an issue. My sql database, unfortunately, is still pointing to my decommissioned staging site (staging3), preventing me from deleting this site. My primary aim is to modify the SQL database file to direct users to the main site. This project will involve the following: • Evaluating the SQL database to identify any tables or data linked to the old staging site • Modifying SQL database paths to direct to the main website • Ensuring that no critical data is lost in the process The ideal candidate for this job will: • Be proficient in SQL database management • Have experience maintaining and altering large database...
My Laravel/Filament PHP project is currently encountering an issue with user authentication. Specifically, users are unable to successfully log in. The Laravel project is integrated with a MySQL database management system for the process of authentication. The ideal freelancer should have: - Strong skills in PHP and Laravel framework - Experience in fixing authentication issues - Expertise in MySQL database management systems Your task will be to analyze the Laravel / Filament PHP setup and rectify the user login issue. To complete this task successfully, you will need a deep understanding of user authentication in Laravel projects powered by MySQL databases. This project needs to be handled with a high level of accu...
I got database in DB3 format. In contains many things like RGB images and LiDAR (point of cloud ) data and others. I attach metadata file. What I need is some who will connect to my PC via Anydesk and will remotely extract information from that database. RGB and LiDAR of same scene so that it is compatible with format
I am in need of an experienced data entry professional who can effectively update my databases. You will only be required to work less than three hours a day from your home. Key Responsibilities: - Updating Database regularly - Ensuring data integrity and accuracy - Solving any database related issues Ideal Skills and Experience: - Proficient in Oracle, MySQL, SQL Server - Exceptional attention to detail - Prior experience in Database updating Get in touch if you fit this profile. This could be your chance to establish a regular, part-time, work-from-home position.
I am looking for someone experienced in scientific writing and research to generate an in-depth research regarding the most suitable biomaterials and solvents to fabricate scaffolds for the reproductive system. Title of project: Suitable biomaterials and solvents to fabricate scaffolds for reproductive system 10,000 word project 1. Abstract 2. Introduction -Background and significance of scaffolds in tissue engineering -Overview of biomaterials and their importance in scaffold fabrication -Statement of the problem and research objectives 3. Biomaterials Selection - Criteria for biomaterial selection (biocompatibility, mechanical properties, degradation rate, etc.) -Types of biomaterials used in scaffold fabrication (synthetic polymers, natural po...
...completed eCommerce application built with Flutter, PHP, and MySQL, I am in need of an experienced developer to assist with the project's completion. The existing eCommerce system comprises of four tables, namely User, Contact, Cart, and Product. The task involves the inclusion of at least five more tables, specifically: 1. Wishlist Table 2. Order History Table 3. Shipping Details Table 4. Payment Cart Table 5. Others (as necessary) Additionally, I require the implementation of several features including: 1. Payment Integration: Enable seamless payment transaction within the app 2. User Reviews: Install functionality that allows users to leave and read reviews on products Successful candidates must conduit their extensive experience in...
I require assistance with linking my MySQL database server to my domain. Additionally, I need someone to upload the server to CPanel and facilitate its installation. I need someone to connect the server to the domain + I want to upload a digitalocean server to CPanel and install it
I require an expert in excel that won't need more than 20 mins to fix a sheet with some pivot tables.
...current Google Sheets-based systems into a robust SQL or BigQuery database framework. The objective is to create a user-friendly web dashboard that seamlessly interacts with the database, ensuring smooth data updates and retrieval. .Collaborate with cross-functional teams to understand current Google Sheets systems and user requirements. .Design and develop a web dashboard for user interaction with the SQL or BigQuery database. .Implement user authentication and authorization protocols for secure access to the system. .Create a system where users can create unique usernames and perform tasks associated with their roles. .Establish data synchronization between the web dashboard and the SQL/BigQuery database. .Optimize database...
as briefed - only use awards from excel tab "2023" Keep same format and same columns! (do not add Recognition or Represent columns, ignore those two) Keep same fonts, font colour and size of text used in indd shared The only change is the heading to change to "Name of Name of Project / Division / Individual" (so add the word 'Individual' at the end) The colour gradient in the bar should change to the supplied two gradient colours, the text over the top of the gradient have to go black
We're seeking a WordPress developer to enhance MySQL database performance and construct a new website. The task involves optimizing and removing redundant code from the database directly, not through plugins. Additionally, they must create a website that fulfills the Core Web Vitals criteria. It's worth noting that we're not utilizing Google AdSense; instead, we're using Ezoic. Post Ezoic integration, the Core Web Vitals scores should exceed 95%. This website is dedicated to devotion and spiritual content.
...incorporate biopolymers in my productions, with a keen interest in a range of products that include tables, lamp shades, decorative accessories, and wall panels and claddings. - Objective: Enhancing product sustainability and developing eco-friendly materials. - Product Range: Potentially encompass tables, decorative accessories, and wall panels and claddings made with biopolymers. The ideal freelancer for this project would likely have experience with biopolymers in producing sustainable products, preferable in the interior design industry. They will understand the unique benefits and challenges of working with these materials. At the minimum, they should have a strong background in product design, knowledg...
For this project, I require someone with extensive experience in Microsoft Power BI, JSON and data analysis. The main aim of the project is 1) automated export data from our current sales system though the use of JSON 2) creation of Dashboards for different user groups inside the company 3) creation of CSV data tables for use in other system Proficiency in Power BI dashboarding, JSON and understanding of sales analytics data is crucial. Above all, keen attention to detail and an analytical mind are crucial for this task.
I am seeking a data entry specialist to harvest text data from online databases. Your role will involve locating relevant information from various online platfor...specialist to harvest text data from online databases. Your role will involve locating relevant information from various online platforms and entering it into an Excel spreadsheet. The ideal candidate for this role should have: - Excellent research capabilities - Proficiency in using Excel - High attention to detail - Ability to manage and organize large volumes of data This project is well-suited for freelancers who have previously worked with online databases and have a strong understanding of data input management in Excel. Please note that the final deliverable will be an Excel spreadsheet file contai...
Here's what I need: - Conversion of my PDF file to Excel. Each page of the current PDF must be transferred onto a separate sheet within Excel. - Ab...what I need: - Conversion of my PDF file to Excel. Each page of the current PDF must be transferred onto a separate sheet within Excel. - Absolute precision is critical in the conversion, it needs to be 100% accurate. Double-checking of the converted data against the original PDF is expected to confirm accuracy. - The PDF holds only text data, there's no requirement for converting any figures or tables into Excel. Ideal candidates should have: - Proficiency in data entry - Attention to detail to ensure error-free data conversion - Experience in converting PDF files to Excel - Ability to proofread a...
This project seeks an expert in AI and Battery Management Systems (BMS) to create comprehensive documentation. The main aims are: - Detecting sudden acceleration, specifically rapid increases in speed - Implementing a battery optimization function. The ideal BMS will balance energy consumption across all vehicle systems to ensure optimum performance and efficiency. Applicants should have substantial understanding of AI systems and battery management, with a focus on creating in-depth documentation. Previous experience in electric vehicles (EVs) is a considerable advantage. Key Skills & Experience: - Proficient in AI and BMS - Excellent technical writing skills - Knowledge in EVs, including acceleration or speed control. You shoul...
Staff, Products, Orders, Merchant table. CRUD for the tables
I'm in need of an Oracle database expert versed in advanced database design. Your tasks will encompass creating a comprehensive design that incorporates stored procedures, views, triggers among others. The database structure is complex, therefore demanding a mastery of the aforementioned advanced concepts. The ideal candidate should: - Have demonstrable experience in Oracle database design. - Be proficient in forming complex relationships between multiple tables. - Show competency in creating stored procedures, views, triggers, and other advanced database features. Your understanding of our needs and execution will greatly influence our company's operational efficiency.
...developer with proficiency in CodeIgniter, to build a movie database website using IMDb and OMDB API. Key Features: - Enable movie search through a search bar. - Display detailed information for each movie. This information will be fetched via the IMDb and OMDB API. - Build and manage the movie database to store movie titles and information. User Interaction: - The website should give the users the ability to search for movies using titles. - The search result should direct users to a details page displaying information about the specific movie, drawn directly from IMDb and OMDB API. Design: - I prefer a professional and corporate design that is clean and minimalist for this website. Ideal Skills: - Proficient in CodeIgniter - Experience with...
I'm looking for a solution that can effectively scan barcoded items and automatically update an Excel database. This needs to include: - Instantaneous data input into Excel after each scan, eliminating the need for manual updates or end-of-session entries. - Accurate inventory count post each scan, providing an easy record of stock numbers. Ideal freelancers will have robust experience in barcode reading technology and automatic data updates. Familiarity with inventory management technology is a plus. This project requires a high level of accuracy and efficiency in data entry.
Looking for C# Razor Web App Developer The job is to replace the Database with APIs (You will not develop APIs, the APIs will be developed by someone else, and you will just use them to replace the Database components) The DB is around 4 tables that are read and inserted into, APIs will replace all these. There is a page that requires an update, So when a user clicks on a word on the page more details should appear in the info section, as in the attached pic and Should fix the project to be published, as there are incompatibility errors and any other errors that could happen. This is one job and cannot be broken into milestones. "It works on my computer" does not mean you have done the job, the job is finished when it fixed on my c...
I'm in need of an experienced AI graphic designer to create a collection of 15-20 modern designs for dining tables, based on different types of wood and epoxy. I need the tables perfect rendered graphic-quality., with spectacular views to the table . I wanna have different angles of each table. table should have size of approx. 2m x 0,9m the epoxy tables should look similiar to theese examples. That means, I dont wanna have expoxy with some stones or other elements within. only one-colour-epoxy or some epoxy with mixed colours. Example images are attached ... Must-have Skills: - Proficient in AI imaging techniques - Prior experience generating photo-realistic images - Skills in digital marketing photography o...
I am seeking a skilled developer who is capable with one or more of the following: Python, Node Red, Home Assistant, JavaScript, HTML, and Raspberry Pi. This project will involve developing a GUI for a data acquisition product. While there is no specific programming language preference, candidates open to working with different languages are ideal. Key responsibilities include: - Building and developing the GUI - Providing solutions based on project requirements - Optimal, adaptable coding The interaction level of the GUI will progress and be defined as the project develops. Ideal skills and experience: - Proficiency in Python, JavaScript, HTML and/or Raspberry Pi - Experience in GUI development - Previous work with Home Assistant or Node Red i...
We will create a WEB system to register FINOPS optimizations carried out in the Cloud. When performing optimizations, a technician will record the following observations in the system: Cloud: (AWS, Azure Enterprise or Azure SAP); Account: Name of the Account/Subscription where the optimization was registered; Resource Name: Text; Resource Type; Teamowner Tag: Cost Center that owns the resource; Project: Project name; Likewise, it should be possible to register offenders (new resources), filling in the same information. Therefore, right from the initial menu, the user should be able to choose 3 options, large on the screen in tile format: Register Optimization Register Offender View graph The system should then have 2 screens for registering and saving optimiz...
As a skilled typist with legal knowledge, I need your assistance in transcribing my documents into a Microsoft Word document. Your main responsibilities: - Typing out legal documents, ensuring accuracy in every detail. - Transcribing the content word by word, leaving no details out. Ideal Skills: - Proficiency in Microsoft Word. - Previous transcribing experience, preferably within a legal setting. - High attention to detail. Please note that these documents only contain textual information with no tables, diagrams or images. Thanks in advance for your meticulous effort on this project.
...expertise of a seasoned web developer with a demonstrated knowledge of HTML/CSS, Rust, AWS/Kubertes, and Bash to create specialized web pages. The function of these pages is primarily to update OpenWRT routers and AWS databases. Key requirements include: - Designing and developing the pages according to a specific layout I have - Expertise in HTML/CSS, Rust, AWS/Kubernetes, and Bash is a must - High level proficiency in AWS and Kubernetes deployments - Experience with OpenWRT or other router firmware is highly desirable - Excellent attention to detail and the ability to deliver a user-friendly interface Please respond with interest and availability to open the discussion, if this project aligns with your profile and capabilities. I look...
I need data collected on 10 banks 5 Islamic 5 conventional on a number of aspects including : total assets total equity roa roe debt net income
I need an exceptionally thorough researcher to construct an in-depth database. This project involves the curation of a list of small Biotech firms with pharmaceutical or medical device products in early stages of development - more specifically in Oncology, Cardiology, and Metabolic sectors. Specific Criteria would be: - Small/startup biotech companies (ideally less than 5-10 employees) - Therapeutic areas of cardiology, metabolic, cardiometabolic, oncology, neurology - Have pharmaceutical or medical device products in early stages of development (pre-clinical, clinical, phase I or phase II) (usually referred to as “Pipeline” of products). - Funding status – ideal companies would have seed or A round funding. - Geographic locati...
I'm seeking an experienced individual who can assist in formatting my Excel spreadsheets and creating informative charts/graphs. Specific tasks include: - Organizing existing data into cohesive tables - Crafting graphs to illustrate data points in an easily digestible format The data specifics were not provided but given its complexity, your experience in organizing diverse data types would be beneficial. Proficiency in Excel with a strong understanding of data analysis is expected. Your ability to present data in clear, comprehensive ways will be extremely valuable in this project.
More details: What is the purpose of the structures you want to build? Residential buildings How many different design variations do you want for the structures? One design What specific features are you looking for in your residential building's design? Glulam arches and connected roof
...team. Specializing in enhancing online presence, engagement, and brand awareness, we are committed to delivering exceptional results for our clients. Responsibilities: As a Reddit Account Manager, you will play a crucial role in managing and growing our presence on Reddit. Your main duties will include: - Daily posting of content across various relevant subreddits, ensuring adherence to community guidelines and interests. - Crafting engaging and attention-grabbing captions to enhance the visibility and impact of our posts. - Maintaining and updating our Reddit Post Tables to keep track whas has been posted and what not - Interacting with comments on our posts to foster engagement and build relationships within the Reddit community. Requirements: - Previo...
Need a database of companies: Locations: - Latvia - Estonia - Greece - Romania - Portugal Categories: - Hotels - Coffeehouses - Confectioneries - Medical Clinics - Kindergartens - Nurseries - Primary schools Required Data: Company Name 100% Country 100% Category 100% Email 100% Number of companies: 2 200 Due date: 12.04
...process to enhance data validation, error handling, and user feedback for structured Excel files uploaded to SharePoint 2019, for subsequent transfer to a database. The solution could be also implemented via Azure Functions and Sharepoint online if deemed possible. Existing Setup: A basic ETL process developed with the Luigi library, lacking advanced validation and user feedback mechanisms. Solution uses parsing code (Pandas) for Excel files data parsing that can be utilized for the upgrade also. There are 4 different excel files, so 4 different parsers will be provided. The system should manage four unique Excel file types, each in its own SharePoint folder, requiring separate parsers for their distinct structures. An initial selection feature will enable users...
...questions that are obvious in the job description, to know about the job, you have to read well what we need, grace I need an experienced Flutter developer to enhance our existing Point of Sale (POS) mobile app by creating a table management module. We already have a backend API in place, which will need to be integrated with the new table management features. We already have the APIs to synchronize the tables, the work that needs to be done is in flowers because all the work of the points and also of the apis are done in the backend and displaced, everything is fine and working, also the work is to make several changes that will be illustrated in a document soon, there will also be a link to currently download the application and be abl...
I'm seeking an experienced data miner for building a robust email database. The focus will be on pubs and bars across the entire UK. The purpose of the database is to facilitate marketing campaigns we’ve planned. Key requirements: - Compilation of only email addresses. No additional information such as the establishment's physical address, owner's name, or type of bar is needed. - The database needs to be exhaustive and cover all the significant areas in the UK, not restricted to any specific city. - Accuracy of the data collected is paramount as it's for marketing campaigns. Ideal freelancers would be those with previous exposure in email database creation, data mining, and ones who understand UK's pub and b...
...who can scrape text, images and tables from e-commerce websites. I am aiming to gather diverse and comprehensive data, therefore, your hands-on experience in similar projects is absolutely crucial. Here is a summary of the project requirements: - Scrape text, images, and tables from e-commerce sites - Use of appropriate scraping tools - Proficiency in handling diverse e-commerce platforms The scraped data needs to be directly sent to a specific database. Therefore, your programming skill should also entail efficient and secure database handling. Data accuracy, integrity, and security is key - I cannot afford data breaches or loss. If your expertise aligns with these requirements, your skill set is most welcomed; especially if you ha...
Hello, I need a freelancer that will convert ONE page PDF with 3 tables to HTML format
I'm seeking a highly diligent professional capable of copy typing a PDF document accurately in the Sinhala language. Key Responsibilities: - Manual transcribing of the PDF into a word document - Maintain formatting that includes tables and graphs Ideal Candidate: - Excellent typing skills - High attention to detail - Proficiency in Sinhala language - Experience with Tables and Graphs in Word Your bid should include your pace: pages per hour. Please be aware this requires careful attention to mirror the format accurately. Looking forward to your proposals.
Laravel 9 or 10 A 5-tables project. Expect to be done in 3days. HTML bootstrap will be provided.
I'm in search of a proficient database engineer whose area of expertise lies in ERD design, SQL, PLSQL, and database application. The selected candidate will be tasked with: - Designing a medium complexity ER diagram with numerous relationships. - Implementing a PostgreSQL database application for the purpose of storing substantial customer information. The ideal candidate must have a sound knowledge of PostgreSQL, SQL, PLSQL, and be able to create succinct yet comprehensive ER diagrams with multiple relationships. Proven experience in similar projects and a knack for developing reliable storage solutions will be a plus.
Project Details: 1. RazorPay Payment Gateway 2. Digital wallet for each user 3. Players can play in 1v1, 3p and 4p modes 4. Players can play in 10 tables. (Similar to miniclip games) 5. Each table is for a different price 6. An Admin Panel is also required (Details will be provided soon) 7. The app is for both iOS and Android Deadline: 3 days. Urgently required. Don't waste your bids if you will take more time.
I'm in need of a detail-oriented professional for a simple data entry job. The core of the work includes: - Transferring information from PDF files into an Excel spreadsheet - Ability to accurately input raw data without altering information Ideal skills and experience: - Proven experience in basic Excel data entry - Proficiency in handling PDF files - High attention to detail - Fast and accurate typing abilities Please note, this project doesn't call for intermediate or advanced Excel techniques like formulas, data sorting, pivot tables, or VBA. The successful freelancer will strictly be transferring data from PDF to Excel.
Require an experienced Oracle Linux admin to assist with the following tasks: - System Configuration - Package Installation and Updates - User and Group Management In addition to those primary tasks, there are specific security requirements that need to be addressed: - Firewall Configuration - User Access Control - Log Monitoring Skills and experience needed: OS installation( Oracle Linux) OS installation as per PDD bonding configuration for all vlans as per PDD Bios & server OS time sync OS Tunning parameters Configuration of PCS cluster as per details provided in PDD. SNMP hardware alarm integration with customer SNMP Manager audit log configuration IP tables/Network Manager/ Selinux configuration Kernel upgrade Logrotation NTP configuration...
Unfortunately, I'm facing a difficult issue with a corrupted PowerPoint 2019 file. I need a tech-savvy freelancer to help me recover all elements, including text, images, as well as video and audio content. - Access: I fully own and have access to the corrupted file. - PowerPoint Version: The presentation was originally created with PowerPoint 2019. - Content Recovery: The PowerPoint contains a combination of text and images, video and audio elements, and charts and tables which all needs to be fully restored. Ideal Skills and Experience: Familiarity and expertise with PowerPoint 2019 is absolutely necessary, as well as a background in troubleshooting and file recovery. Knowledge of video and audio formats would also be beneficial. If you'...