Need to build a Database in BiqQuery, that willbe populated later using an API
$30-250 USD
Closed
Posted 7 months ago
$30-250 USD
Paid on delivery
Project Description:
We are looking for an experienced database developer to design and implement a transactional database in Google BigQuery. This database will serve as the backbone of our business operations and will also be used to train algorithms for various purposes. The database will initially include tables for products, suppliers, clients, RFQs, offers, and quotes.
Project Requirements:
1. Database Design:
Design a relational database schema for Google BigQuery to accommodate the following tables: Products, Suppliers, Clients, RFQs, Offers, Quotes, and a junction table for Products and Suppliers.
Table Descriptions:
Products:
A table to store detailed information about products, including attributes such as product name, description, category, and more.
Suppliers:
A table to capture essential supplier details, enabling efficient management of supplier relationships.
Clients:
A table for storing client information, including contact details and company-specific data.
RFQs (Request for Quotation):
This table will manage RFQ-related information, including request status, required delivery dates, and attachments.
Offers:
The offers table will contain data regarding offers made in response to RFQs, including pricing and offer statuses.
Quotes:
This table will store detailed quotes, including product-specific quantities, unit prices, and additional quote details.
ProductSupplier (Junction Table):
A table to associate products with their respective suppliers, including supplier-specific product codes and pricing information.
2. Table Specifications:
Define table structures, data types, and relationships.
Ensure that the Product table can be populated through an API, and provide guidance on the API integration.
3. Data Volume:
The database is expected to handle up to 50,000 products, 1,000 suppliers, and 100 clients initially.
4. Integration:
Develop a plan for data population, focusing on the Product table through an API, and offer recommendations for populating other tables.
5. Data Maintenance Tool (Future Development):
Create a scalable database structure that allows for easy integration of a data maintenance tool to complete and update the other tables as needed.
6. Documentation:
Provide clear and comprehensive documentation for the database schema, relationships, and API integration (if applicable).
7. Google Cloud Environment:
The Google Cloud environment will be provided to the selected candidate for database implementation and development.
Phool understands that you are looking for an experienced database developer to design and implement a transactional database in Google BigQuery. We have the expertise necessary to deliver this project successfully. With over 10 years of experience in database design and development, Phool can effectively design and implement a relational database schema for Google BigQuery to accommodate the necessary tables. Additionally, our team has developed a variety of successful projects that can provide guidance on the API integration process.
We believe our combination of skills and experience make us the perfect fit for this job. If you're interested in working with us on this project please don't hesitate to reach out with any questions or queries you may have!
Hello
I have thoroughly reviewed your project description and am confident in my ability to assist you in completing it successfully. I believe it would be highly beneficial to delve deeper into the specifics of the job to determine the most effective way forward. I am open to scheduling an interview at your convenience, and I genuinely appreciate the chance to collaborate with you on this project. Your response is eagerly anticipated, and I'm excited about the prospect of working together. Thank you for considering my proposal.
Looking forward to your prompt reply!
Best regards
Apurva!!
Dear client,
I must say, your project has piqued my interest like a squirrel spotting a hidden acorn! As an experienced database developer, I fully understand the importance of a well-designed and efficient database in driving business operations and training algorithms.
I am ready to embark on this exciting journey of creating a transactional database in Google BigQuery that will be the backbone of your operations. With my skills in SQL, MySQL, and database programming, I am confident in my ability to design a relational database schema that will accommodate all your needs.
From storing detailed product information to managing supplier relationships and handling RFQs, offers, and quotes, I will ensure that each table is meticulously designed and tailored to your requirements. I will also provide guidance on API integration, so you can easily populate the Product table and streamline your data entry process.
Rest assured, I am prepared to handle the data volume you expect, and I will develop a robust plan for data population and maintenance. Additionally, I will create comprehensive documentation to guide you through the database schema, relationships, and API integration.
With access to the Google Cloud environment, I am ready to dive headfirst into this project and deliver a quirky, funny, and professional database solution that will leave you chuckling with delight.
Looking forward to the opportunity to work with you!
Yours humorously,
Hi there! My name is Narendra and I am a professional with extensive experience in developing web applications, specifically travel portals with real-time notifications, supply chain management tools, inventory management software and social media portals similar to LinkedIn and Facebook.
Dear Client
We are excited about the opportunity to design and implement a transactional database in Google BigQuery that will serve as the backbone of your business operations and support algorithm training. We will design a robust relational database schema that accommodates the specified tables, including Products, Suppliers, Clients, RFQs, Offers, Quotes, and the junction table for Products and Suppliers. Each table will be designed to capture relevant information accurately and efficiently.
For each table, we will define the table structures, data types, and establish the relationships needed to ensure data integrity and consistency. We will also ensure that the Product table can be populated through an API and provide guidance on the API integration. The database will be designed to handle the initial data volume of up to 50,000 products, 1,000 suppliers, and 100 clients. The schema will be scalable to accommodate future growth and additional data. We will develop a detailed plan for populating the database, focusing on the Product table through an API. Our recommendations for populating other tables will be based on best practices and efficiency. The database structure will be designed to allow for the future integration of a data maintenance tool.
We look forward to the opportunity to create a robust and efficient database that will support your business operations and algorithm training needs.
Best regards
Hello,
I am Preeti, having almost 15+ years of industrial hands-on experience working with multiple programming languages & database(s) and preparing relevant technical documentations.
Currently working as a freelancer, can support in the remote work as mentioned herewith on your feasible times.
Can assure you of qualitative deliverables at optimum charges.
Hello there!
My name is Shikha and I am a senior web and mobile app engineer with extensive experience in database design, table specifications, data volume and integration.
I understand that you are looking for an experienced database developer to design and implement a transactional database in Google BigQuery. Specifically, you need the database to accommodate three tables: Products, Suppliers and Clients.
I believe I am the perfect fit for this project because of my expertise in Android/IOS app development (Swift 5/4/3/2), React Native, Angular JS and other relevant frameworks. Additionally, I have the ability to work in the Java EE environment as well as UNIX, Linux and Windows systems.
Additionally, I provide clear and comprehensive documentation for the database schema, relationships and API integration (if applicable).
Hi there! My name is Syed Muhammad and I'm a skilled web developer specializing in CMS (Content Management System) development, with a strong focus on WordPress. I understand that you're looking for an experienced database developer to design and implement a transactional database in Google BigQuery. You need the database to serve as the backbone of your business operations as well as be used to train algorithms for various purposes.
Hello,
I'm Catur, and I serve as a Technical Lead at US company. With 13 years of experience in leading technical teams and driving innovation, I am passionate about software development.
Current assignment in real job:
1. Data Engineer and Data SRE working on Data Warehouse
2. Tools: Airflow
3. Programming language: Python
4. Platform: Amazon EKS
It's a pleasure to connect with you.
Thanks & Kind Regards,
Catur
https://www.freelancer.com/u/catbig
Hey, How are you? I have 5+ years of working experience doing IT jobs. I am full stack developer have a strong working experience of every framework specially SQL, MySQL, Database Programming, Database Development and BigQuery. Please start chat, So we have a detail discussion regarding to project. And I have read your project details as well.
You can check my portfolio as well: https://www.freelancer.com/u/Sidrairfan078
Waiting for your Reply. Thanks! Sidra
I would be happy to bid on this project to design and implement a transactional database in Google BigQuery. With my experience as a database developer, I can create a relational database schema for Google BigQuery to accommodate the required tables, such as Products, Suppliers, Clients, RFQs, Offers, Quotes, and the junction table for Products and Suppliers. I will ensure table specifications, data types, and relationships are defined properly and provide guidance on API integration for populating the Product table. Additionally, I can develop a plan for data population, offer recommendations for other tables, create a scalable structure for future data maintenance tools, and provide clear and comprehensive documentation. With access to the Google Cloud environment, I guarantee efficient implementation and development.
Hello there! My name is Nayab and I am a web developer with 3+ years of experience. I specialize in developing and maintaining websites, utilizing programming languages and technologies to ensure seamless user experiences and functionality.
I understand that you are looking for an experienced database developer to design and implement a transactional database in Google BigQuery. This database will serve as the backbone of your business operations and will also be used to train algorithms for various purposes.
I believe that I am the perfect fit for this project! With my extensive knowledge in databases, I am confident that I can design and implement a relational database schema for BigQuery that can accommodate the various tables required by the project. Additionally, I can provide clear documentation on the design specifications as well as recommendations for populating other tables through an API.
Furthermore, I have access to the Google Cloud environment which would be provided for database implementation and development purposes.
I would love to discuss this project further with you if given the opportunity! Please feel free to contact me if you have any questions or would like more information regarding my profile or project requirements at any time."
Hi there, I'm Bajrang , a seasoned full-stack developer on a mission to turn your digital dreams into reality. With a passion for coding and a knack for innovation, I'm here to bring your projects to life with precision and creativity.
Greetings Cristian V.,
I am an expert Cybersecurity specialist and a Senior System Administrator with over 20 years of experience.
I can help you with your project "Need to build a Database in BiqQuery, that willbe populated later using an API" right away, contact me for more details.
Regards,
Mike Corney
Data Engineer | Proficient in SQL, Python, BigData | I help teams with critical data validation and pipeline development, leads to appreciation by the leadership team
