Using sql server openerpKazi

Site-uri web,IT si Softaware limbaje PHP, WEBSITE DESIGN, Graphic Design, HTML, C++, SQL

Zdravei Radoslav, Tursq si web developer na Python sus slednite sposobnosti: *Legacy Django (<1.2) project needing brushing up to 1.4/1.5. Deep knowledge of Django/Python best practices. Skills: - Python (4 years) - Django (2 years) - SQL & Django-South (2 years) Dobro zaplashtane. Svurji se ako si zainteresovan. Inna Amesheva

...<image1><image1> <image2><image1> <image3><image1> <image4><image1> <image5><image1> <image6><image1> </category> <category> <name>category 2</name> <image1><image1> <image2><image1> <image3><image1> <image4><image1> <image5><image1> <image6><image1> </category>‏ i will provide 2 tables sql file...

Title: Automated Data Retrieval from Websites Using CRM and CID Numbers Description: We are looking for an experienced developer to automate the process of retrieving data from specific websites using CRM and CID numbers. The goal is to develop a script or tool that will: Look up Doctor's Specialization: Use CRM numbers to search on the website: CFM Doctors Search Extract doctor's information including their specialization. Look up Disease Descriptions: Use CID numbers to search on the website: MedicinaNet CID10 Search Extract the disease description. Deliverables: ( ) A script or tool that can take a list of CRM and CID numbers as input. Automate the search process on the specified websites. Extract

I have a WordPress site where I'm facing some issues with taxonomies. Specifically, I'd like to organize my games by categories using custom taxonomies. Please read the SPECIFICATIONS BEFORE BIDDING - I need assistance with fixing the taxonomy issues and setting up the custom taxonomies to organize my games. - The main objective here is to help me effectively categorize the games on my site. - This will involve back-end work and ensuring that the taxonomies are correctly linked to the relevant content. SPECIFICATIONS (REFERENCE IMAGES PROVIDED): ----------------------------------------------------------------------------------------------------------------------------------------------------------------- I need to remove the Service Number Taxonomy that was added and ...

I need a male voiceover artist to deliver a friendly, engaging voiceover for my Discord server's rules. The script is less than 50 words long and simply outlines the server regulations. Freelancers with previous experience in voiceover work, particularly in a casual and friendly tone will be ideal for this task. Understanding the nuances of Discord would be a plus.

I am in need of a Wordpress developer who can design a Wordpress websitefor professionals. The site will need to have a Learndash integration and customization, as well as be built on Elementor for easy management and updates. Key project requirements include: - Creation of a professional and user-friendly website with Elementor - Integration and customization of the Learndash feature - Focus on user registration and login for course access - Ensuring a seamless e-commerce functionality for course purchase. Ideal candidate should have: - Proven experience in developing Wordpress sites with Elementor - Strong understanding and experience with integrating and customizing Learndash - Ability to create a user-friendly and visually appealing interface - Previous experience with e-commerce fun...

I'm seeking a skilled freelancer to implement Continuous Integration and Continuous Deployment (CI/CD) using GitHub Actions, set up logging for each service, and configure an HTTPS domain for our web application hosted on Google Cloud Platform (GCP). The ideal candidate should have extensive experience with GCP, CI/CD pipelines, and HTTPS configuration. Scope of Work: 1. CI/CD 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...

I'm seeking a talented graphic designer to create a t-shirt design, incorporating a combination of logo, text and illustrations. We own a fireworks company. We have attached a logo that needs to be incorporated. While the theme isn't specified, your artistic input is highly appreciated; feel free to craft something that represents your unique style. Ideal Skills for this Job: - Experience in graphic design, particularly in clothing. - Strong portfolio showcasing your ability to integrate text, logo and illustrations. - Creative flair and originality. Note: The color scheme for this project hasn't been fixed. Again, I would value your opinion on what would make the design stand out. Excited to see how your creativity unfolds this project!

hello I am currently planning to start a startup. I am currently entering the IT field (fields such as Facebook and Instagram) and need a programmer to join me. The working hours per day will be more...hours per day will be more than 40 hours, and a small salary may be paid per month. I have very creative ideas and am ready to grow into a global company. If you join me, I will provide you with an additional salary increase and a higher position as the company grows (e.g. Data Manager/Marketing Manager, etc.) Anyone who can do any of the following is welcome. -programmer -translator -lawyer -Server maintenance -Marketing expert -Anyone else who can contribute to the growth of the company Anyone who has a lot of passion and is starting a journey with me for my company is alway...

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...

...FINAL; NO LATER CHANGE IS ALLOWED. READ CAREFULLY BEFORE YOU BID. See ATTACHMENTS. Cannot share Code before you accept. I have a Journal App built in PHP/JavaScript/Laravel which allows to enter Journal entries, country, some photos and one video of limited size, different costs etc (see ). The job is to implementing the feature of Travel Route Map Creation using Leaflet and OpenStreetMap (both free, opensource). There is a tutorial here Users will be able to search a place in map, create lines of different colors from one place to another, add/tie blog posts, links and pictures with the map, dates, notes and then only map creator can download the map as Image/PDF. Leaflet free plugin

hello We are currently looking for someone to manage the server that will run our website and app. (Please enter “ITO” to confirm) -Work: Anywhere you want -Job description: Manage everything from server hosting to operation In particular, maintenance/repair to ensure that security is very strong. Video conference once a week Submit work details and inspection results as a report every three days -Salary: $100/month ((Budgets may continue to increase as the company grows in size and sales increase))

I need a highly adept project manager experienced in WooCommerce and dropshipping, who can help in setting up a large-scale e-commerce website. This website will host an extensive range of product categories. We are looking at using Ali2Woo as we want to achieve large bulk product uploads. Key Responsibilities: - Managing the overall project - Overseeing necessary WooCommerce configurations - Implementing a bold and vibrant website design Required Skills and Experience: - Extensive experience with WooCommerce - Familiarity with dropshipping business model - Ability to manage large-scale e-commerce projects - Experience in creating and implanting bold, vibrant web designs This isn't just a coding job. The ideal candidate is someone who can take the lead in making strategi...

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

I am looking for a developer with experience on modding Call of Duty Black Ops 2 and bot development on Discord. The project objectives include: CUSTOM IN-GAME COMMANDS AND PERKZ - Creating custom Plutonium server settings for Black Ops 2 Zombies. - For the commands, i want there to be the basic commands that anyone can use, and “vip” commands for the players who have vip role. - Most if not all of the custom perks scripts i want have already been published on the plutonium forum. - Also needs stats tracking DISCORD BOT - Developing a Discord bot capable of linking a player's Discord account to their in-game GUID. - Granting players access to vip in-game commands thru the discord bot - in-game points rewards for when a player links their discord account to the...

...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 in creating admin dash...

As an investor seeking to streamline my algorithmic trading operations, I am in need of an able Python Developer who specializes in automation tasks. This role requires an individual with: - Mastery of Python and experience with automation tasks, most especially within the investment and stock market scenario. - Skilled and knowledgeable in stock market terminology with experience in use of Websockets for API integration Suitable candidates are expected to have good communication skills to effectively understand and implement required changes in a timely fashion. Help me maximize my trading potential with your Python expertise!

...doing -Number of positions: 5 (subject to change) -Tasks: Preventing hacking / preventing data leakage / monitoring servers in real time / modifying and maintaining websites / adding new website features / developing new web and app features / increasing server security / ensuring compliance with privacy laws .... and most other services required to run apps and websites. -Meetings: All work is done at your location, and once every 7 days, we have a video conference with all developers, and you can send us a report of your daily work and server checks. (Time and more information to follow) -Budget: $150~$200/month/1 person (subject to adjustment) -We still have a lot of time before monetization, so please take your time bidding. Also, everything is subject to change, so pl...

We have a project developed with VS2022, c#, datatables, SQL database, javascript and similar.... The user experience is not good. We need a professional and nice interface and user experience, but, mantain our actual code and funcionality.

Hi, I am looking for a developer to maintain, make upgrades and fix bugs on my current website and booking system. The system has been done in SQL written in C# by my old developer. He has had a change of career and can no longer work on things but is happy to do a handover to make things easier. This will be an ongoing business relationship and not a one off thing so will need someone with good communication and accurate times of completion. Thanks, Luke.

...CodeIgniter 4, ensuring all features and functionalities remain intact. Optimize SQL Queries: Review and optimize all SQL queries to handle heavy loads efficiently. The current system experiences performance issues during peak times, and the new version should resolve these. Fix Bugs and Security Issues: Identify and fix any existing bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise i...

I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future reference.

Hello! I need someone who is an expert in web programming with PHP to translate any kind of PDF for free in using PHP. This PDF must not lose its quality. It must remain intact and it must preserve the ORC format, style and all. I want the translation to be exactly like the one from onlinedoctranslator.com. I know you're going to tell me that the Google Translate api isn't free, but you can use this library (link removed) . Then it has to choose the number of pages in the PDF. Even if the PDF is 100 pages or more, it must be able to translate it. It must support encrypted PDFs and PDFs protected by passwords. I will use your code in my site. You can visit it and you'll see that the PDF translation is missing. I've told you everything and I hope you'll give ...

I am looking for a freelancer to help me in drawing the developed Artificial Neural Network (ANN) which will predict data related to education. The visual representation of th...versus the actual data will be shown in the form of spreadsheets. Your role will be to: - Draw the developed ANN for education prediction - Show the selected parameters for the developed ANN - Visualize the predicted data versus the actual data in spreadsheets Ideal skills and experience: - Solid understanding of Artificial Neural Networks (ANN) - Experience in data visualization, particularly using spreadsheets - Familiarity with educational data or at least a background in developing predictive models in a related field - Ability to clearly communicate complex technical concepts in a simple, understanda...

Hi there! I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

I'm seeking an expert in Python and VBA who can develop a real-time data statistical analysis tool for use on Windows. The tool must be able to process financial data. Though the format of my data wasn't specified, please be ready to handle a diverse range of formats, including but not limited to CSV files, SQL databases, and Excel files. Skills and Experience: - Mastery of Python and VBA - Experience with statistical data analysis - Familiarity with financial data - Proficiency in handling diverse data formats. - Skill in working on Windows OS. Ultimately, I require a reliable system for my ongoing financial data analysis needs. Your track record of similar successful tasks will be a plus.

...application from a 2008 server to a dedicated server. Key Requirements: - Migrate ASP.NET 3.5 application: The current application is running on ASP.NET 3.5 and needs to be seamlessly moved to the new dedicated server. - Hosting Environment: The application should be set up on a dedicated server. Experience with dedicated servers is crucial. - Identify Specific Requirements: I'm unsure of any dependencies or specific requirements the application might have, so the ideal candidate will need to assess this and make necessary recommendations. Ideal Skills & Experience: - Proficiency in ASP.NET 3.5: Extensive experience with ASP.NET 3.5 and above is essential. - Server Migration: Proven track record of smoothly migrating applications from one ...

I am seeking an experienced engineer who can assist me in the design and analysis of a new project. Ideal skills and experience for the job: - Proficiency in AutoCAD for design and analysis - Strong background in engineering, particularly in the area of design and analysis - Excellent problem-solving skills - Ability to work closely with me to understand my vision for the project and bring it to life

I'm seeking a specialist to locate a VPS/VRoot server that can provide minimized latency to a website origin hidden behind a Cloudflare proxy. The task encompasses: - Identifying the server with the lowest possible ping based in Europe. - The server should run on a Windows operating system. - The ultimate objective is to improve user experience by minimizing latency. Ideal freelancers for this job will have a robust understanding of server locations, operating systems and how they interplay with website latency. Experience with Cloudflare proxies, Windows-based servers, and in-depth knowledge on achieving optimal latency is distinctly beneficial. The website would be and I require the lowest ping when buying an item on the sites trading page. Ping can b...

I need an experienced Linux admin who can help me set up a CentOS server to function as a web, database, and file server. The ideal candidate will be familiar with CentOS and have experience configuring a server with multiple services. Key Requirements: - Install and configure CentOS on a server - Set up Nginx as the web server - Configure the server to also function as a database and file server - Ensure the server is secure and optimized for performance - Provide documentation of the setup and configuration for future reference.

Hello, This is a $20 project. Looking for a freelancer to develop a python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should target restaurants that have a phone number and *do not* have a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (in meters) - Ensure the business/place is a restaurant, bakery, etc. Key Data to Retrieve, output in a .CSV: - Business Name - Address - Phone Number - Google Maps URL Thank you, trooper501

I am in need of a skilled AppSheet developer to create a custom app for my small warehouse inventory business. Key Features: - Inventory Tracking: I require a system that will consistently track and update inventory in real-time to ensure accuracy. Other Details: - Products: As a small warehouse, I have less than 50 different types of products. - User Access: The app will not need to support multiple users accessing and updating the inventory simultaneously. Ideal Skills: - Proficient in AppSheet development - Experience in building inventory tracking systems Please respond with your relevant experience and sample work for further consideration.

I'm looking for a skilled developer to create a user-friendly website for my MMORPG game server. Key elements of the project include: - Designing an engaging and intuitive UX/UI template for the website that resonates with the game's theme and aesthetics - Inclusion of essential features to enhance user experience Your expertise in web development, specifically in the gaming sector, will be crucial to this project's success. A strong understanding of user behavior, and the ability to translate that into a visually appealing and functional website is a must. Please provide a portfolio showcasing your previous work in this area. Experience with MMORPGs or gaming websites will be highly valued.

I'm in need of a skilled OpenCV programmer to help me with a bug in my WhatsApp automation script. Here's what you need to know: - The specific issue is that the automation isn't starting as expected. - The script is written in Node.js. - I haven't been able to locate any error messages or logs that might be related to the issue. You should ideally have experience with: - WhatsApp automation - Node.js - OpenCV Your task will be to identify the root cause of the automation failing to start and rectify it.

I need a Cloudflare expert to set up and configure my server for a high traffic website. - Tasks: The primary task will be setting up and configuring the server for the website. This includes but is not limited to ensuring the server is set up correctly, testing its performance and functionality, and making any necessary adjustments. - Specific Optimization: Experience in optimizing servers for high traffic websites is a must. - Cloudflare Specifics: While the primary focus is on server setup, knowledge of Cloudflare and its CDN (Content Delivery Network) feature is highly desired. Ideal Freelancer: A Cloudflare expert with experience in server setup and optimization, particularly for high traffic websites. Knowledge of setting up and configuring ...

Hi, I am looking for expert to connect SQL database togoogle looker studio so we can analise data and creat reports, it is a long term coopartion. Please provide implementation cost and hourly charge. Best.

...programmer who is well-versed in SQL Server 2019. The primary task is to ensure that new columns added to the database are correctly displayed in the Excel report generated by the application also fix some minor areas that will discuss in detail Key Responsibilities: - Troubleshoot and fix the issue of new columns not being displayed in the Excel report - Ensure that all relevant data is correctly fetched from the SQL Server 2019 database - Implement a seamless solution that does not affect the overall functionality of the application Ideal Skills and Experience: - Strong proficiency in C# programming language - Expert knowledge of SQL Server 2019, including stored procedures and functions - Prior experience with similar tasks involving Excel ...

If you read it start your message with 'REACT'. I'm looking for a React specialist to help me deploy a wallet connect feature on my server. This is a React project that I need to deploy on my server. The project is for a wallet connect feature for crypto. There is already a working example from GitHub and I need it deployed on my server. Experience in the following areas would be ideal: - Proficiency in React - Experience with deploying projects on servers

We are in the final stage of migrating an existing Django Project to a new machine in a docker compose stack. The database is already moved over. We are stuck with python dependency issues. You need to have good knowledge in - Django and Python3 - Docker, especially Compose stacks - Postgresql You will be working with a system admin who is in the middle of the migration and take over the dependency part, tmate will be used to work together. If you have read this, please add "HDJX34K" to your bid or it will be considered spam, ignored and removed. Your job: - docker compose build - have a look at the python dependency issues - try to resolve them and rebuild. - eventually adjust Django's accordingly. We want this work done now, and you must be able to start immediately.

App para elaborar presupuestos fuera de la tienda. actualmente tengo un sistema de escritorio elaborado en sql server para facturacion. El sistema Funciona perfecto y tiene la opción de realizar cotizaciones pero quiero incorporar una app para realizar las cotizaciones de los clientes foráneos ya que tengo un empleado que los visita semanalmente y me toca estar transcribiendo los pedidos. Seria una app que permita cargar los inventarios y los clientes al momento de estar en la tienda Y luego poder realizar los pedidos o cotizaciones offline cuando se este fuera. Para luego cuando llegue a la tienda hacer la actualización o descarga de pedidos. que tan dificil es hacer la app para android y para ios.

We are seeking an experienced freelance developer to design and develop an online service booking platform targeted at legal professionals. The project includes creating both a web application and a mobile application for service providers. Responsibilities:Design and develop an intuitive user int...booking system with calendar and availability management. Implement secure payment systems and automatic notification features. Ensure compatibility between the web and mobile to best practices for security and data protection. Required Skills:Proven experience in web and mobile in front-end and back-end technologies (e.g., React, Node.js).Experience with SQL or NoSQL understanding of UX/UI design to meet deadlines.

...and responsive. **Key Responsibilities:** - Design and build advanced applications for both iOS and Android using frameworks like Flutter. - Work alongside other teams to define, design, and deploy exciting new features. - Focus on application performance and user experience. - Maintain high standards of code quality and push for continuous improvement. **What You Need:** - BS/MS in Computer Science, Engineering, or related field. - 2-3 years of full-stack development experience, with significant focus on mobile apps. - Strong proficiency in Flutter or similar, front-end technologies (HTML5, CSS3, JavaScript), and backend development (Node.js, Django). - Experience with databases (SQL & NoSQL), cloud services (AWS, Google Cloud, Azure), and versioning tools like Git....

Hello! I need someone who is an expert in web programming with PHP to translate any kind of PDF for free in using PHP. This PDF must not lose its quality. It must remain intact and it must preserve the ORC format, style and all. I want the translation to be exactly like the one from onlinedoctranslator.com. I know you're going to tell me that the Google Translate api isn't free, but you can use this library (link removed) . Then it has to choose the number of pages in the PDF. Even if the PDF is 100 pages or more, it must be able to translate it. It must support encrypted PDFs and PDFs protected by passwords. I will use your code in my site. You can visit it and you'll see that the PDF translation is missing. I've told you everything and I hope you'll give ...

Hello^^^^. I'm using Amazon AWS and would like to request server maintenance. First of all, I would like to ask you to do as much as possible for server security and privacy, such as SSL installation, automatic backup once a day, DDOS attack prevention, system performance optimization, hacking prevention, encryption between data transmissions, real-time monitoring, data recovery, backdoor checking, backdoor checking and deletion of compromised files, attack root identification and blocking, suspicious process occupation identification and recovery, server hacking analysis, server access history tracking, password recovery and complexity setting, virus and malicious software checking,,data leakage prevention.....etc My current monthly budget is about...

I'm on the lookout for a skilled RHEL Engineer to assist in getting our server on the Certified Hardware List. The role will require expertise in the core language of RHEL. Although I'm unsure if proficiency in C is obligatory, having it would be a welcome advantage. Specifically, the Engineer will: - Understand the requirements for RHEL certification - Prepare the server for the process - Perform the tasks and tweaks necessary to meet certification conditions I anticipate that a strong understanding of programming, RHEL, and Linux-based operating systems will be necessary. Experience with server certification will also be highly beneficial.

...user login/signup, in-app messaging, push notifications, photo and file upload. Advanced features should also include GEO Fencing, QRCODE/Barcode scanning and face recognition. The app should be supported by SQL and allow user details to be saved and retrieved from a database. Furthermore, the app needs to integrate with Google services like Maps and Calendar. The design of the app should be minimalistic but seamless for easy user interface. Therefore, a developer with design skills would be perfect for this task. - ESSENTIAL SKILLS: - Android app development - Knowledge of SQL - Minimalistic app design - Experience in GEO Fencing, QRCODE/Barcode scanning, Face Recognition - API integration with Google services This project will require rigorous testing to...

I'm in need of a skilled developer with strong experience in NodeJS, React, and Next/NestJS. The p...Search Functionality: The application will have a search feature that allows users to find specific content or items efficiently. This will require robust search algorithms and user-friendly interfaces. - Payment Gateway Integration: The application needs to support payment processing. You'll need to integrate a payment gateway to handle transactions securely and seamlessly. Your experience in SQL will also be valuable to ensure efficient data management and integration with the web application. Please provide examples of your past work that demonstrate your expertise in these areas. I'm looking for a reliable, communicative individual who can deliver a high-quality...

...diagram, relational schema, database dump, SQL files, and queries for a library database system. Requirements: - ER Diagram: An ER diagram is required with rationalities similar to the example provided in this link: - Relational Schema: Develop a relational schema that effectively models the database. - Database Dump: Provide a database dump for the system. - SQL Files and Queries: The project should include a set of SQL files and queries that effectively interact with the database. - Managerial Queries: Develop a minimum of 20 managerial queries that will be used to analyze and manage the library database. Deadline: This project must be completed by Monday. Ideal Skills: - Proficiency in database design and SQL - Experience with ER diagram creation - A...