Dbms project erd jobs
I'm in need of an expert in SQL and VBA who can assist with a one-time project. The job will entail: - Writing complex SQL queries - Automating tasks in Excel using VBA - Conducting data analysis and generating reports This will be performed on Microsoft SQL Server. As such, considerable experience with this DBMS is a requisite. Primary skills and experience for the role include: - Expert level proficiency in SQL and VBA - Extensive experience with Microsoft SQL Server - Familiarity with automating Excel tasks and data analysis - Previous experience in report generation This is a one-off project with the possibility of future collaborations for similar tasks. If you have the necessary skills and experience, I'd like to hear from you.
I'm in need of an expert who can set up and configure a MySQL database with Oracle APEX. The main purpose of this setup is to manage and retrieve product inventory and sales transaction data. Key tasks include: - Designing the database to efficiently handle product inventory and sales transactions. This involves creating an Entity-Relationship Diagram (ERD), and writing Database Definition Language (DDL) and Manipulation Language (DML) statements. - Configuring the Oracle APEX environment to interact with the MySQL database and ensure smooth data retrieval and management. - Ensuring the system is secure, ensuring no unauthorized access to the database. - Providing a high-level overview of the system's architecture and functionality. Skills and experience required: - Stro...
Create a database and CREATE TABLE statements for all tables in your ERD (Part A) including primary and foreign keys. 2. INSERT INTO statements for populating the database i. Insert five rows of (made-up) data into each table. Make sure that the data you enter in these tables should be sufficient to return at least one row for each query in Task 3. AL should hold at least 5 bottles of Penfold Grange 2010 in some branch or other
I'm in need of an experienced MySQL and Neo4J expert who can help me with designing a database schema and an ERD Diagram from a CSV file. Make a report of the database with proper screenshots and run some queries. more details in chat... Requirements: - Proven expertise in MySQL and Neo4J - Solid understanding of database schema designing - Producing an ERD Diagram
...solution using ThingWorx Platform Experience on Thingworx extension development is added advantage Must have executed at least 3 medium/large implementations on ThingWorx Experience in writing ThingWorx services in JavaScript Industry standard UI creation using ThingWorx Mashups Experience with PTC Kepware Experience with DevOps is a plus Experience on working in scrum framework DBMS Skills: RDBMS (PostgreSQL, MSSQL and others) and NoSQL Basic understanding of SQL and API connections Functional understanding of JSON, REST APIs and read API documentation Understand business requirements and translate them into well engineered and integrated technical solutions Certification in Cloud Technologies is a big plus Client focused to understand and appropriately...
...position, under my direct supervision, focusing on the technology domain. The successful candidate will be responsible for: - Mainly assessing business needs and working together to identify the right solutions - Lending a hand in project management tasks when required - Documentation of a variety of business and functional requirements, using both the Business Requirements Document (BRD) and Function Requirements Document (FRD) formats - Diagramming, primarily creating Data Flow Diagrams (DFD), Use Case diagrams, User Journeys, and Entity Relationship Diagrams (ERD) - Having wireframing knowledge would be a distinct advantage Ideal skills required for this role include excellent analytical ability, communication skills, ability to grasp new concepts, and time management...
Technical skills required - Android Development Expertise: Proficiency in Android studio, Kotlin; Experience with android SDKs UI design: Familiarity with material design and responsive design principles DBMS: Experience in database such as MangoDB, Firebase, SQLite Security and Privacy: Understanding of data encryption, secured authentication. Understanding on survey methodology would be a Plus. Purpose: Build survey platform to facilitate detailed market research through customizable surveys, enabling precise data collection and analysis Turnaround Time: 1 Month Scope of work – Survey platform is an android based mobile application. Survey creation and management to take place on web. Survey Creation and Management: Should offer intuitive survey builder functionalities &n...
I'm looking for a Python trainer who can help me take my skil...visualization, as well as machine learning and AI. Key requirements: - Experience in developing and implementing data analysis and visualization projects - Proficiency in machine learning and AI techniques - Ability to provide interactive workshops, including hands-on coding exercises - Experience in teaching online lectures and tutorials Bonus if you have experience with Database Management Systems (DBMS). Your role will involve: - Conducting interactive workshops - Providing hands-on coding exercises - Offering online lectures and tutorials - Implementing practical projects that involve data analysis and machine learning If you have a proven track record of training and a deep understanding of Python, pleas...
...individuals experienced in Mobile Application Development with a knack for creating complex, yet user-friendly applications and server side development. Key Aspects: - Initial focus on developing complex features for the Android application. - iOS application development would follow suit, adopting the functionality of the original Android application. - server side application developer using java and DBMS Skills & Experience: - Proven experience in cross-platform mobile application development. - Proficiency in both Android and iOS application development. - Ability to understand and implement complex app features. - Strong communication and collaboration skills. - Should have experience in developing scalable backend application - Should have experience in CI/CD pipelin...
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.
I urgently need an expert coder well-versed with Database Management System. The specific DBMS that will be used is not specified yet, so the ideal freelancer will be someone comfortable working with multiple types including MySQL, Oracle, SQL Server, PostgreSQL, MongoDB etc. Key requirements: - Extensive knowledge and experience in various Database Management Systems - Flexibility and adaptability to any DBMS - Ability to deliver high-quality work on a urgent timeline This project has a high level of priority, so I need someone who can start working immediately. I'm looking for a freelancer who can communicate effectively and complete the project ASAP. Your expertise in navigating different DBMS will be a significant factor in accomplishing this ...
I am urgently requiring the development of an incremental ETL pi...incremental ETL pipeline. To do this job successfully, you will need to provide two main deliverable: -Architecture diagram: Demonstrates your plan for the ETL pipeline structure. -ERD diagram: A depiction of entities, their relationships, and the data flow. Ideal Skills and Experiences: -Broad experience in ETL, particularly incremental ETL pipelines. -Proficiency in creating architecture and ERD diagrams, showcasing complex data flows. - Familiarity with a variety of technologies for implementing ETL process. While we skipped the preference, a broad knowledge base will be advantageous. I am in a hurry for this project, therefore your ability to work efficiently and effectively within a tight sc...
Hi Abhijeet B., I noticed your profile and would like to offer you my project. We can discuss any details over chat.
I'm seeking an expert to create an automated dashboard, aggregating training metrics from an eLearning Management System database. It is essential that Excel function...feeding data into this dashboard should be user-friendly. Key responsibilities: - Design a dashboard that will display updated training metrics from a database - Automate Excel functions - Allow user-friendly data import Ideal candidate: - Proficient in Excel - Knowledge of DBMS (Database Management Systems) - Familiar with eLearning Management Systems - Experience in creating user-friendly interfaces - Strong time management skills, as the project needs to be completed within a month Our understanding of the exact DBMS is currently unclear; thus the freelancer needs to be comfortable working w...
I'm seeking an experienced PHP and MySQL developer to assist in modifying an existing Xero application. The task is to create PHP code to change the app's present means of stor...work should be done in a demo environment and I will add the code to the live site. Key Details: - The Xero App in question can be found at this link: - We've chosen MySQL as our preferred DBMS. Ideal Candidate: - Proficient in PHP and MySQL - Familiar with database structure modification - Understanding of Xero apps is a plus - Can optimize for security and speed - Transparent and maintains good communication. I look forward to working with someone who can add value to this project. Please feel free to reach out if you need any additional information.
I'm in need of a highly skilled professional who can work on connecting an AI project to a phonetic animation. This is an exceptional opportunity for creating a visual representation of pronunciation in a fun and educational manner. Key functionalities to be developed will include but not limited to: 1. Connect our phonetic animation to a custom AI project. 2. The connection should be through a database - we're open to suggestions on efficient DBMS to use as we didn't settle on any yet. The perfect fit for this job will have: - A strong background in AI project development - Experience in working with the different database management systems and proficiency in choosing the one fitting our needs. - Experience in developing and integrating with ...
...intricate packages and procedures that are vital to my business operations. The Successful Candidate Should: - Be highly proficient in PL/SQL and well-versed in Oracle DBMS. - Have a strong understanding of complex business logic implementation. - Be capable of designing and building robust database solutions that can handle heavy traffic. Key Responsibilities: - Designing and implementing complex packages and procedures in PL/SQL for Oracle. - Translating business requirements into efficient and scalable database solutions. - Ensuring that all developed solutions adhere to specified coding standards and best practices. This project requires you to have previously worked on complex Oracle PL/SQL projects and has a thorough understanding of business logic implementation....
I'm in need of a proficient D365FO ERD expert who can assist in designing an Entity Relationship Diagram for system blueprinting purposes. The ERD will be applied to financial systems. Your responsibilities will include: - Proficient understanding of ERD design and functioning - Expertise in D365FO - Ability to perform tasks with a focus on system blueprinting - Knowledge in financial systems Your skills and experiences that make you an ideal candidate are: - Experience in designing ERDs for financial systems - Proven skills in D365FO - Track record with system blueprinting - Ability to optimize and troubleshoot ERDs. I'm looking forward to a professional who can design an ERD that will work efficiently with the financial system I'm wor...
...handling capabilities. The core objectives is to design DB in a way where it can be stored efficienciently, boost retrieval speed, and ensure utmost data integrity. This project requires precision and forward-thinking to lay a robust foundation for our data management ecosystem. **Ideal Skills and Experience:** - Expertise in database systems (Sql & NoSql) - Proven track record in optimizing database architectures for performance and reliability - Strong understanding of data security and integrity measures - Familiarity with the demands of various industries, enabling a flexible and adaptable approach to design **Project Goals:** - **Storage Efficiency:** Implement compact, yet expandable, storage mechanisms to handle growing data volumes without compromising perfor...
...entities, staffing requests, and responses. 5. Communication Module: • Implement an API-driven internal messaging module for seamless communication. • Archive messages for reference purposes. 6. Enhancements (Updates): • Introduce additional API features such as group association and lookup tables. 7. Entity Relationship Diagram (Update): • The requester will provide an Entity Relationship Diagram (ERD) as part of the system design documentation. 8. Agile User Stories (Update): • The requester will provide Agile user stories as part of the system design documentation. 9. Active Request Filtering: • Implement APIs for displaying and filtering active staffing requests. 10. Deployment in Docker Containers (Development): • Containerize the applicati...
Seeking a talented and experienced Software Requirements Specifications Engineer, ERD Designer, and Roadmap Specialist to create a plan and blueprint for our developers, system administrator, and project manager to follow. Experience working closely with teams and developers to gather requirements, analyze business needs, and prioritize features is required. The website is in development and we are close to completing a minimal viable product using a MEVN stack: Mongo, Express, Vue3 (+Quasar), Node. There are 4 or 5 different SRS documents. I hired 2 project managers until I found the current person helping us out. The previous ones created their own SRS which was part of the reason they were let go.
I'm seeking an Excel specialist who can thoroughly analyze a dataset of less than 1000 rows. Your tasks will encompass: - Advanced data analysis - Manipulation of formulas and functions - Development of sophisticated charting ...Excel functions will position you well for success in this job. Your proficiency in converting raw data into easy-to-understand charts is also crucial. Please bid only if your Excel 365 skills are top-notch and validated by a demonstrable track record. Your task is to design a data model and ERD for the new database, using both Excel and Access as data sources. In addition, you must build the data model using Access based on the sample data that you create in Excel and Access. The data model and ERD should include the following entities (tables...
I'm seeking a skilled database developer to create a comprehensive town archives database. This project will focus on preserving the town's rich history, encompassing a wide array of information categories. The database should be robust, user-friendly, and secure, catering to historians, researchers, and locals interested in our heritage. **Key Information Types to be Stored:** - Historical documents - Photographs of significant landmarks and events - Land records including maps and plots - Personal records including birth, death, wars participated in, occupation, and more - Organizational records for businesses, military, churches, schools, and others **Specific Data Points Required:** *For Individuals:* - Name, Birthdate, Occupation, Death date - Relationship status,...
I'm in the initial stages of an exciting project to develop a comprehensive music file database for a music streaming service, to be integrated with our existing website. The project's path hasn't been fully decided yet, and as such, I'm open to suggestions on whether to build upon a pre-existing database or create a new one from the ground up. **Key Requirements:** - **Database Creation/Enhancement**: Ability to either construct a new music database from scratch or enhance an existing one, depending on what we decide is the best course of action. - **Integration Expertise**: Proficiency in integrating the database seamlessly with our current website, ensuring a smooth streaming experience for users. - **Music Streaming Focus**: Understanding of the needs and ...
I need an experienced Laravel developer to quickly fix a bug with dates in the transaction history of my app. The dates aren't displaying correctly, which is critical for the accuracy of our financial reports. **Required Skills:** - Proficient in Laravel & PHP - Experienced with MySQL or similar DBMS - Solid understanding of MVC frameworks - Strong debugging skills **Responsibilities:** - Diagnose the issue with date values - Implement the correct display format for dates - Ensure data integrity in the transaction history **Ideal Candidate:** - Quick problem-solver - Attention to detail - Good communication skills - History of successful bug fixes in Laravel Please provide examples of previous Laravel projects you've fixed with similar issues. I'm looking for...
I'm on the lookout for a skilled Flutter and NestJs developer with a considerable emphasis on both frontend and backend development. -The backend in Nestjs is already developed, needs only few adaptation. -The frontend should be developed in flutter. -The frontend should be simple to use and support right to left language. -One fea...for a skilled Flutter and NestJs developer with a considerable emphasis on both frontend and backend development. -The backend in Nestjs is already developed, needs only few adaptation. -The frontend should be developed in flutter. -The frontend should be simple to use and support right to left language. -One feature is to be developed on the front end in addition to the login, register. the erd of the program is joined, more details will be d...
...which revolves around creating an ERD, and database normalisation using MySQL. Key Requirements: - Data modeling: You'll need to effectively capture and express rich information, processes, and relations in our database through your excellent data modeling skills. - Entity-relationship diagram (ERD): This is the primary focus of my assignment, so you must be adept at creating and understanding ERDs. - Database Normalization: The project involves implementing normalization rules to ensure our database is efficient. SQL Queries Assistance: - Moreover, I require assistance with writing and executing SQL queries for this particular project. Hence, your skillset must also include command over SQL programming. Your extensive knowledge and expertise in My...
I'm seeking an expert to craft a technical paper circa 3000 words, that delves into t...an in-depth technical analysis of data modeling. - Explore entity-relationship diagrams (ERD). - Discuss normalization techniques in detail. - Address data integrity constraints and their importance. **Ideal Candidate:** - Advanced knowledge of relational database theories. - Proficiency in creating detailed ERDs. - Experience with database normalization and enforcing data integrity. - Capability to translate complex technical concepts into a well-structured paper. Your submission should not only reflect a strong theoretical foundation but also demonstrate practical applications and real-world relevance. In-depth research, analytical skills, and technical writing proficiency are crucial fo...
Case Background Oakmont & Partners LP has been busy building data models for a number of new clients and Monica is excited to start a new modeling effort for a local non-profit that provides assistance to homeless and others in need. She is keen on applying her UML and ERD modeling skills that she acquired while taking a corporate training class taught by Ars Doceo. She knows that the first step in building a conceptual data model is to conduct requirements analysis. So, she sets up an interview with Kaileen Ormond, the Director of Social Pedagogy who has been with the organization for over 18 years. To make sure she remembers what is being said, she decides to record the interview. The following is a transcription of part of that recording: "... Let me give you a scenario...
...essential. I wish for this database to run on iOS, Android, and Web. It is crucial that the professional hired for this project can effectively test the improved database on my server across all these platforms. Leveraging your expert skills to create strong relations between the database tables is an integral part of this project. Having someone with previous experience in e-commerce platforms or delivery service apps will add significant value to our project and is highly desirable. Looking forward to turning this startup app into a super app with your expertise. Project Deliverables: Enhancement of Multi-Service Delivery App Database 1. Entity-Relationship Diagram (ERD): - A detailed diagram visualizing the enhanced database structure. - Clear...
I'm looking to have an ASP.NET C Sharp application developed for data management purposes. This application will be web-based, accessible via any standard browser. The application will handle: - Data entry: The user should be able to enter and upload relevant data easily and efficiently. - Data report generation: The ...system to authenticate users who are accessing the platform. - Access control: Some sections of the application should be restricted, only accessible to specific roles or individuals. Ideal Skills: - Proficiency in ASP.NET, C Sharp, and web-based application development. - Experience with complex data-management systems. - Knowledge in user authentication and access control security measures. ERD DIAGRAM https://miro.com/app/board/uXjVNCwN6Ew=/?share_link_...
hello. I am experienced and passionate full stack developer, especially front-end. I have been developing for 7 years. Until now, I have mastered Mern(mongodb+express+react+node.js) and Mean(mongodb+express+Angu...Mern(mongodb+express+react+node.js) and Mean(mongodb+express+Angular+node.js) stack. I developed lots of website in react.js, Angular, and Vue.js using tailwind css and material UI in many platform such as Fuse React, Fuse Angular, MDB React, NGX-ADMIN. In back-end, I have a deep experienced in node.js, laravel and Django and especailly Node.js and Laravel is my main backend skill. Also, I get used to use DBMS such as MongoDB and MySQL. I am ready for long-term relationship with you. If you are interested in me, let's have a chat. I will do my best to satisfy you. Th...
Bootcamp project only not commercial. You have been asked to create a project management system for a small structural engineering firm called “Poised”. Poised does the engineering needed to ensure the structural integrity of various buildings. They want you to create a Java program that they can use to keep track of the many projects on which they work. Poised stores the following information for each project that they work on: ● Project number. ● Project name. ● What type of building is being designed? E.g. House, apartment block or store, etc. ● The physical address for the project. ● ERF number. ● The total fee being charged for the project. ● The total amount paid to date. ● Deadline for the project. ● The name, tele...
...Entity-Relationship (ER) Diagrams. This project aims to provide a comprehensive yet concise analysis of existing research, identify gaps in current literature, and evaluate understandability and challenges related to ER diagrams. Your task will be to address the following research questions in the review: - Highlight the main findings and key points from previous Eye-tracking experiments and ER diagrams studies. - Detail the current challenges and limitations in ER diagram understandability. - Identify and suggest areas of ER diagram research that are yet to be extensively explored. The Literature should be 5 pages divided into two parts: - The First part of the Literature Review should talk about studies that influence comprehension of concept models, process diagrams and E...
Create an ERD using for a VERY BASIC, 3-4 entity database.
Draw the composition diagram of this ERD as context to build the conceptual: https://www.coffeesuppliesdirect.co.uk.
I am looking for a freelancer who can assist me with database design using ERD and SQL. Purpose: - The main purpose of this project is database design. Specific Entities and Relationships: - I have a detailed list of specific entities and relationships that must be included in the ERD. Scale: - The scale of the database is small, with less than 50 records. Ideal Skills and Experience: - Strong knowledge and experience in ERD and SQL - Proficiency in database design - Attention to detail in following specific requirements - Ability to handle small-scale databases efficiently
I am looking for a freelancer to complete a mini SQL project for me. The specific task that needs to be completed is database design. I do not have a preferred database management system (DBMS), so I am open to suggestions from the freelancer. The expected volume of data for the database is small, up to 1GB. Ideal skills and experience for this job include: - Strong knowledge and experience in SQL - Proficiency in database design - Familiarity with different DBMS options, such as MySQL and PostgreSQL - Ability to handle and optimize small-sized databases - Attention to detail and accuracy in data analysis If you have the necessary skills and experience, please submit your proposal. Thank you!
Looking for IT panelists for Hiring Fresher from reputed Engineering colleges for Product Based R&D Team. Time Zone : India & 10 am to 6 PM , Based on the Candidates count . Weekdays (Mon to Friday). Mode of Panel : Online Qualification & Skill Set: Minimum 8 Years exp in Development Background, Java & C++, Good in logical and Problem Solving, Data Structur...Hiring Fresher from reputed Engineering colleges for Product Based R&D Team. Time Zone : India & 10 am to 6 PM , Based on the Candidates count . Weekdays (Mon to Friday). Mode of Panel : Online Qualification & Skill Set: Minimum 8 Years exp in Development Background, Java & C++, Good in logical and Problem Solving, Data Structure & ...
I am looking for a freelancer who can teach me about databases, specifically ERD and Queries output. Skills and experience required for this job: - Ability to explain and teach database concepts such as ERD and writing queries
The Project is comprised of two distinct components: Part 1: Database design, optimization, and implementation - report (Learning Outcome 1) Part 2: Demonstration of key design and implementation – video demo + source code/scripts (Learning Outcome 2) Project Scenario The research team has requested the development of a database to support a project focused on movie production companies. The objective of this project is to employ machine learning, neural networks, and other methodologies to extract pertinent information regarding the status of movie production companies in Europe, as well as the overall condition of this industry within a specific group of countries, including the United Kingdom. The research institute, whose identity will not be discl...
Project Description: We are looking for a skilled web developer to create a website for our ecommerce blogs. The main purpose of the website is to sell products, so it should have a strong focus on showcasing and promoting our products effectively. The frontend of website should be in React JS and backend is in python(Django). so i am looking for skilled developer which has experience in full stack development, React, Django, PostgreSQL, DBMS etc. also developer has experience in SMTP. so that developer can integrate the mail functionality. which generally user will use to get reset password link Aesthetic: The desired aesthetic for the website is simple and minimalistic. We want a clean and modern design that allows our products to take center stage. Skills and Experienc...
We will create a networking website where students and professors can view opportunities provided on campus. This includes students finding groups to collaborate on personal projects, study sessions, research opportunities, professors looking for students who can take up on campus jobs and etc. The details of the person who posts the opportunity as well as the person who applies will be given so skill matching can take place. This will allow people on campus to connect and collaborate.
I'm looking for a database professional to help me with a simple DBMS project. I need someone with experience in MySQL. The work will involve both designing the database structure and implementation. We will create a networking website where students and professors can view opportunities provided on campus. This includes students finding groups to collaborate on personal projects, study sessions, research opportunities, professors looking for students who can take up OCJs and etc. The details of the person who posts the opportunity as well as the person who applies will be given so skill matching can take place. This will allow people on campus to connect and collaborate.
I am looking for a skilled freelancer who can help me with my project involving database management system (DBMS) and web server setup. DBMS Preferences: - The preferred DBMS for this project is MySQL. Web Server Software: - I am open to suggestions for the web server software, but I would prefer a middleware solution that can integrate with the DBMS and provide reliable performance and security. Specific Requirements: - I have specific requirements for the DBMS and web server, which I will discuss in detail with the selected freelancer. These requirements include: - Efficient data storage and retrieval - Seamless integration between the DBMS and web server - Robust security measures to protect sensitive data - Scalabili...
I am looking for a skilled freelancer who can help me with 2 SQL queries. The specific requirements for the project are as follows: Database Management System: - The DBMS that I am using is MySQL. I am using HeidiSQL so the code needs to be compatible with HeidiSQL. Performance Requirements: - Performance is not a key factor for these queries. Ideal Skills and Experience: - Strong knowledge and experience in SQL and working with MySQL. - Ability to write efficient and optimized SQL queries. - Attention to detail to ensure accurate retrieval of data based on specified conditions.
I'm looking for someone experienced creating ERDs for a small business project and experienced in SQL for database schema in MySQL workbench. Contact me for more details
Best wishes for a wonderful day. SQL is required for this endeavour. Currently, I only have to complete CLO2. For this endeavour, an Entity-Relationship Diagram (ERD) and a database diagram are essential components. In addition, it is essential to include DDL and DML instructions. These are the only elements that are genuinely required. After the construction of the entire database, it will still be necessary for you to construct queries using SQL server in order to respond to the inquiries. Needed by Nov 5th.
