Construction jobs database clonecông việc

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'm seeking a skilled designer to create a precise 2D floor plan for construction planning. This floor plan needs to be highly accurate and detailed, as it will serve as a vital blueprint for the construction process. Key Requirements: - Show the room layout, including the position of doors and windows, in exhaustive detail - Use the exact room measurements and dimensions provided by me Ideal Candidate: - Experienced in creating floor plans for construction projects - Detail-oriented with a strong understanding of construction elements and processes - Proficient in using floor plan software and tools - Ability to interpret and effectively use given measurements and dimensions - Reliable in meeting deadlines and maintaining open communication channels.

I'm in need of an experienced Java developer to create a robust backend for my e-commerce project which is expect...experienced Java developer to create a robust backend for my e-commerce project which is expected to handle more than 500 daily users. Key tasks will include: - Constructing and ensuring the smooth operation of a backend, capable of managing high traffic. - Successfully integrating PostgreSQL database, chosen for its advanced features and performance. - Setting up a secure and efficient payment gateway. The ideal candidate should possess proven experience in high-load e-commerce project construction, particularly with Java, PostgreSQL and payment gateway integration. Understanding and previous usage of related technologies will give candidates a signifi...

I'm looking for an expert developer capable of building a webapp and its corresponding iOS and Android apps, aimed at CV job matching. It will be focus on "temporary jobs" and a sort of tinder for jobs (swipe right or left) candidates and jobs. The primary focus will be facilitating the process of recommending suitable job candidates to employers, therefore enhancing the efficiency of the hiring process. Key aspects for the system to consider in the algorithm include the candidates' skills, experience level, and education. Requirements: - Strong experience in app development - Familiarity with developing job matching algorithms - Knowledge of integrating databases for job seekers' information - Understand complex business processes and tran...

...sculpting in blender or Zbrush. - Models need to be 100% solid without exception. - My price is non-negotiable, so please don’t start chatting to me to try and negotiate price. - Do not cut and paste a pitch/response to this or I won’t take it seriously. - Message me some pictures of your photoreal 3D sculpting of PEOPLE if you want to be considered. - If this job is done properly, plenty more jobs. - The Project MUST be completed by April 7th as it is for a birthday on the 10th and I need a couple of days to print it. NOTE: The model is of the woman and three children. We can make an adjustment so it looks like they are on a single couch. Will need to include their legs even in the model, will have to use imagination for that. Can provide reference pictures ...

I am in immediate need of skilled individuals with interior design and construction industry experience for guest posting on my website. Our platform focuses extensively on home, interior design, and the construction field. Your knowledge and insights in these areas can significantly contribute to our content. Key Requirements: - Demonstrable past work in the field of interior design or the construction industry - Excellent writing skills with proficiency in English - Based in Europe or the Americas for timezone alignment Given the urgency of this project, a quick turnaround time would be highly appreciated. Please share examples of your past work along with your application. Looking forward to your submissions.

I am seeking a skilled web developer to construct an e-commerce website from the ground up, tailored toward selling physical products. Key Features: * Efficient Inventory Management system: The website must have an integrated stock control feature that makes inve...experience and build trust. Preferable Skills & Experience: * Proven experience in e-commerce website development * Knowledge and understanding of inventory management systems * Expertise in integrating review mechanisms * Familiarity with shipping calculators or similar tools This project necessitates a systematic and detail-oriented developer with a strong background in e-commerce platform construction. The main goal is to create a user-friendly, functional, and efficient website that offers an optimal shoppi...

Vui lòng Đăng Ký hoặc Đăng Nhập để xem thông tin.

I have an AutoCAD architectural submission plan that has been flagged by the city for non-compliance with building codes. These issues need to be corrected. Key details: - Only the building codes compliance aspect needs to be addressed. Scale, dimensions, and labels are fine. - Corrections s...city feedback while positioning the plan for a seamless approval process. Ideal freelancer for this project: - Extensive experience with AutoCAD architecture. - Familiarity with city building codes, and architectural submission plans. - Proven record in adjusting plans based on regulatory feedback. Your task is crucial as the corrected plan will play a significant role in moving forward with construction. Thus, attention to detail and accuracy are paramount. I look forward to seeing your ...

I am seeking a professional who is skilled in using Revit to create an architectural model of an existing building. This model will be used to generate construction documents. The level of detail desired for this project is basic, yet essential, components. This includes but is not limited to walls, windows, and doors. 3D revit model, no renders or furniture just a bare box for the interior people to work from Building plans are not readily available, therefore, I will be expecting the freelancer to create the necessary plans using data that I will provide. The ideal freelancer for this job should have: - Proven experience working with Revit - Strong understanding of architectural layouts - Ability to accurately create building plans from given data - Good communicatio...

I'm looking for a competent developer with experience and expertise in MySQL database, proficient in working with business data. Tasks involve designing and creating a powerful and secure API. Specifically, the API needs to handle my business data appropriately. The key skills and experiences needed include: - Strong knowledge of MySQL database - Proven experience in API development - Solid understanding of business data management - Android programming language proficiency My ideal developer should have previous work experience that they can showcase, particularly examples of API and MySQL database creation. A fast turnaround and high-quality work are my key expectations. Applications without relevant experience or lack of MySQL and Android language proficien...

...the following drawings for development applications & construction stages of various projects: - Detailed floor plan - Detailed elevations - Detailed cross-section Drawing Details: It’s essential to note that these drawings need to be detailed with materials and finishes. Therefore, I am not merely seeking a basic outline. 3d renders - would be good to have this priced as an optional extra only Ideal Skills and Experience: I would prefer someone possessing a high understanding of architectural design elements, as well as practical experience in producing professional, detailed construction architectural drawings. You should also have an acute understanding of materials and finishes. Knowledge and experience in residential construction design is a plus...

I'm currently in need of a professional who can accurately dispose of kitchen renovation waste, which includes items such as boards and an old stove. The amount of waste is medium-sized. Key responsibilities would include: - Ensuring safe and secure packaging of...accurately dispose of kitchen renovation waste, which includes items such as boards and an old stove. The amount of waste is medium-sized. Key responsibilities would include: - Ensuring safe and secure packaging of the waste. - Implementing correct recycling methods. The ideal freelancer for this project would be: - Experienced in waste disposal, preferably with a focus on renovation or construction waste. - Knowledgeable about recycling processes. - Detail-oriented, and health & safety conscious. Offer ...

...including MEP (Mechanical, Electrical, Plumbing) systems, structural steel, and miscellaneous metal. The ideal candidate will have a proven track record of producing accurate estimates, managing project budgets, and fostering positive relationships with clients, subcontractors, and suppliers. **Responsibilities:** - Conduct detailed take-offs and material quantity calculations for all aspects of construction projects, including but not limited to structural steel, miscellaneous metal, MEP systems, and other trades as required. - Analyze project plans, specifications, and other documentation to accurately assess project requirements and identify potential cost-saving opportunities. - Collaborate with project managers, engineers, architects, and subcontractors to develop comprehen...

I'm seeking a proficient and creative landscape architect to undertake the design and planning of a compact, less than 1 acre, lan...undertake the design and planning of a compact, less than 1 acre, landscape for a set of 3 buildings. The primary purpose of this project is to enhance the aesthetic appeal of the area. - Requirements: - Develop and execute a comprehensive landscaping plan centered around aesthetic appeal. - Create unique and engaging designs tailored to a small space. - Produce detailed drafts to aid construction process. Ideal candidates will have exceptional design skills and significant experience delivering similar projects. A keen eye for aesthetics and a proven track record of delivering visually impactful design in compact spaces will set you apa...

I'm in need of a consultant versed in the implementation of software development, particularly at the idea phase. Your task will be to guide, explain, and offer expert advice on the methods and techniques essential for a successful setup. Key areas of focus will be: • Penning down a software development plan • Establishing milestones and clearly defined objectives • Identifying key technologies and tools appropriate for this stage Ideal candidate should have: • Proven expertise in spearheading software projects • Profound knowledge of various software development tools and technologies • Exceptional communication skills, with the ability to explain technicalities in plain English. This will be an ongoing consulting role throughout all the phases of...

We are a reputable construction company based in the dynamic Bay Area, and we're seeking a captivating banner design to promote our services at our residential projects. The banner will be approximately 4 feet by 2 feet (horizontal) and will be prominently displayed outside our current projects. Key Features: - The banner should be approximately 4 feet by 2 feet (horizontal). - The design should incorporate our company logo and name, contact information, and our license number. - We're open to your creative interpretation for colors and branding elements. - The style choice is also up to your discerning eye, whether that be modern and simple, classic and elegant, or bold and creative. The ideal candidate for this project: - Should have experience in banner design. - Ex...

I am in need of a seasoned expert in web and database development focusing on creating an efficient database structure and developing both backend and frontend functionality. and i want know just what to use for this project and only consultant Key Responsibilities: - Design and structure a NoSQL and sql database - Develop back and front end functionality using JavaScript with Node.js Ideal Skills: - Extensive experience in NoSQL and sql database structuring - Proficiency in JavaScript and Node.js - Ability to make informed suggestions on database and language use - Hands-on experience in Website design would be an added advantage Your goal will be to provide robust, secure and efficient database support to my website's functionality. S...

‏ am studying as a construction engineer, and my specialty is land surveyor. I am in the final year of my education. I am studying a course called Mapping from aerial and satellite photographs. I have a homework assignment in this course, but I do not have enough time to solve it. I will send you the syllabus in Hebrew, as well as the requirements for the assignment itself. And I will send You have educational materials in the Hebrew language as well, and I send you a previous task that I solved in this course so that you know the direction of the solution. Read it all, and if you think that you can solve it successfully, tell me that. Let’s start working. I will pay 130$ when you finish the work (I will pay a third of the price when you send me the middle. the solution)

I am in need of an experienced voice-over artist who can deliver an authoritative and impactful reading for an educatio...experienced voice-over artist who can deliver an authoritative and impactful reading for an educational audiobook aimed at adults. Your work will involve bringing life to the book while maintaining a level of professionalism. Ideal Skills: - Voice over - Educational content - Ability to express tone of authority and impact Experience: Ideal candidates have past experience in voice over jobs for educational material and an understanding of how to draw in adult listeners. Project Requirements: - Deliver an authoritative and impactful voice over reading - Understand and implement the correct tone for the educational genre - Ability to connect with adult...

As someone who needs assistance with both creating a PostgreSQL database and connecting to it using pgAdmin, I am seeking a skilled freelancer who can navigate these tasks with ease. For this project, the PostgreSQL database doesn't require any complex table structures or relations - basics will do. The data to be stored leans more toward user data, so comfort and familiarity with handling this sort of data within PostgreSQL is a big plus. In short: - Create a simple PostgreSQL database - Connect to this database using pgAdmin - Handle and organize user-specific data within the database Ideal candidate should have: - Proven experience with PostgreSQL database creation - Knowledge in connecting databases using pgAdmin - Familiarity with str...

I'm searching for an Artificial Intelligence expert to develop a program that can understand and interact with my local database. Your work will involve; - Training the AI to perform data classification, clustering, and prediction. - Programming the AI to utilize this data to generate new documents. - Specifically, these documents will be engineered judgment reports. Ideal skills would include proficiency in AI, machine learning, data processing, and report generation, with a penchant for accuracy, detail orientation, and understanding complex engineering terms and concepts.

In connection with the launch of an international project, which aims to support the professional realization of specialists from various fields and spheres of the economy, we are looking for Affiliate Associates to participate in the construction of a structure of regional representatives for individual countries. If you are a communicative person and like to make new contacts, you know how to work independently and manage small or larger groups of people, you know a foreign language at a minimum working level (written and spoken), please fill out the attached Questionnaire and send a short summary with your professional experience and skills. We will offer those who successfully passed the competition: - high remuneration, which is based on their personal activity - dynamic env...

Hi akshaynaveen, Im looking for someone to design a turbofan engine. Something on par with PW535E1. I want to make and build it for an experimental business jet i would like to make in the future. Could you do something like this? How long would it take? What would you charge me? I am in residential construction, i would like to build jets in the future…

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 location would be United States, and then...

Construction company looking for a website to showcase projects. Current website needs modern view with a much more higher scale look

We're seeking a structural engineer to assess and approve our self-made construction documents for a residential treehouse permit application in Tioga County, NY. The treehouse is located in a rural area and will be of wooden construction. It is a tiny house and Appendix Q applies. Key Project Elements: - Structural review & approval of submitted designs. - Construction based in rural area, taken into account during assessment. - Wooden build consideration, specifically. Ideal candidate: - Has experience with rural, residential projects. - Possesses knowledge of structural dynamics specific to wooden construction. - Is able to provide documentation or proof of approval suitable for permit application. We're excited to see your bids and hear ...

I need an expert in Python and using DigitalOcean servers to upload and configure an automation tasks script I've written in Python. Experience in digital ocean is a key requirement for this project. Skills & Experience Needed: - Deep knowledge in Python Coding - Proven experience in configuring and deploying scripts on DigitalOcean servers I already have a DigitalOcean server set up and ready for use, it's just a matter of placing the script in the right location and making any necessary changes for it to run smoothly. Any additional tips or advice on maintaining the script or server would be appreciated as well.

An experienced architectural professional is urgently needed for a residential design project. This task is not limited to just creating modern design plans, but also entails providing construction supervision and comprehensive project management. It is imperative that the freelancer has a strong background in modern architectural design. Ideal skills and experience: - Proven experience in modern residential design - Strong track record in construction supervision - Demonstrable project management skills - Fluent in latest drafting, design and project management tools.

I'm looking for a professional with technical expertise in the civil engineering field. In particular, the ideal candidate will have insight on construction related to farm tracks. Key job requirements: - Broad and deep technical expertise in civil engineering - Focused specialization in construction of farm tracks - Past experience acting as an expert witness - Strong ability to communicate complex technical knowledge clearly Your task will primarily involve working alongside our legal team, interpreting and providing technical advice on matters related to the case. Therefore, having previous relevant experience will be highly advantageous.

...application Chatwoot where the enqueued queue keeps increasing, despite the server being far from its maximum capacity. Detailed Project Requirements: - Identify and analyze why the Sidekiq Enqueued Queue is growing unchecked. - Implement appropriate solutions to manage and curb the increasing queue size. Server/Database Information: - Server Infrastructure: Virtual private server (VPS). - Database: PostgreSQL. Sidekiq Task Handling: - Primarily used for data processing and background jobs. Ideal Candidate Experience & Skills: - Solid understanding and experience with Sidekiq and its functioning. - Proficiency with PostgreSQL databases. - Extensive experience with virtual private server (VPS) environments. - Capable of troubleshooting and resolving qu...

We are looking for a seasoned virtual assistant who thrives in a remote work setup and is a master of efficiency. You will be responsible for: - Posting jobs - Managing all the applicants by sending one time message. Your experience on LinkedIn will be a huge advantage for this project, ideally, please include how many years you have been on LinkedIn. We are more interested in the quality of your work than the duration of your time on LinkedIn. Ideal Skills: - Proven experience as a virtual assistant - Strong understanding of LinkedIn's platform and features - Excellent organizational and multitasking abilities - Strong communication and people skills If you're confident in your ability to meet the requirements of this job, please apply and showcase your expertise...

I am looking for a professional cap... ideally speeding up the project process. Key Responsibilities: - Create foundation design and drawings for single-family homes - Stamp designs as approved for construction - Apply professional engineering judgement to develop designs that are safe, functional, and compliant with local codes and standards Ideal Skills & Experience: - Proven experience in structural engineering - Knowledge of single-family home construction and specifically crawl space foundation styles - Familiarity with local codes and standards in Rifle, CO - Proficient in using CAD files - Professional Engineering (PE) license to Stamp designs for construction Please note: Special site conditions such as steep slope, flooding risk, or dense vegetation d...

I'm seeking a talented graphic designer to develop a construction hoarding banner that serves as a promotional tool for our project. Here's what I need: - A visually appealing banner that aligns with our company's color scheme. - The banner must incorporate our company branding and contact details. - Experience with promotional or advertisement design is advantageous but not a must. - Strong attention to detail and understanding of effective visual communication. A successful design will provide moving exposure to our company, making it memorable and appealing. If you have a knack for creating designs that draw the attention of viewers, I'd love to see your bid.

I am undergoing a rebrand due to a change in company name and the addition of a new service. I am specifically expanding to include graphic design services, and it's essential the new logo reflects this evolution. Key aspects: - Modern and appealing: I'm aiming to grab the attention of our new target audience. - Relevant to freelancers: The logo needs to speak directly to...this project: - Experience with graphic design aimed at freelancers. - Demonstrable logo creation and rebrand work. - Understanding of how different design elements impact freelancer's decisions. Their current logo is attached and we like the style and aesthetic. New company name is Refresh Idaho and is focused on Remodeling. The new logo should not be about painting. It should be more about constru...

I'm looking to build a multivendor auction application specifically for Android. Key Features: - The app needs to include a 'Buy it now' option for instant purchase. - Secondly, it should be equipped with a 'Reserve price' function to protect the interests of sellers. Payment Details: - The app needs to have an integrated payment gateway, enabling secure and efficient transaction ...secure funds until goods are delivered. Potential freelancers should have strong experience in Android app development, specifically within e-commerce and auction apps. Understanding of payment gateways and Escrow service integration will be beneficial. Once the platform is complete and working we would like to build a second version for a second industry we work in, so this wou...

I'm in need of expert architectural design services for my new house. Key Requirements: - Both 2D and 3D floorplans. Precision and attention to detail is a must as these plans will be used for construction purposes. - A unique 3D static visualisation. This should be at an intermediate level of detail, with some furnishings and basic textures evident. Candidate must have: - Experience in architectural design, specifically in creating detailed floorplans and 3D visualisations. - An eye for detail and a keen sense for interior design and space planning. - Strong skills in relevant software such as AutoCAD, SketchUp or similar ones. I'm looking forward to visually bringing my new house to life.

I need an expert in data entry to assist in a task that entails the transfer of mixed numeric and textual data from online databases. The ideal freelancer should have the following skills and experience: - Familiarity with online databases and navigation - Accuracy in transferring both numeric and textual data - Attention to detail to ensure that no error occurs during data entry - Ability to work efficiently without direct supervision.

I am in search of an expert in Photon and potentially Playfab to help facilitate the implementation of a multiplayer tournament. This tournament should be able to support 8, 16, and 32 players. Key Requirements: - The API construction language is flexible, although having a ready-made project would be advantageous - The platform for this multiplayer tournament is primarily for mobile, with a focus on both Android and iOS systems If you have a project ready to show, it's better. Ideal Skills & Experience: - Proficiency in API development - Knowledge of Photon and Playfab is beneficial - Experience in mobile development, with a focus on Android and iOS platforms - Familiarity with tournament systems or multiplayer game mechanisms This project is expected to be both cha...

I am looking for an experienced and knowledgeable team to build a new cell tower at a height of 200 feet. The primary objective of this build is to improve signal coverage, expand network capacity, and enhance data speed. Skills and Experience Required: * Proven experience in cell tower construction * Deep understanding of network systems * Proficiency in working with relevant tools and equipment * Licensed in North Carolina * Sf-330 The project has no specific deadline, allowing for a thorough, meticulously executed job. However, regular status updates and efficient work habits are expected. This is a significant project that requires both technical proficiency and commitment. I am looking forward to discussing arrangements with potential freelancers.

I'm seeking the skills of a talented 3D artist to create an aerial view rendering of a warehouse. The primary goal is to use this rendering for construction planning purposes. Here are the specifics: - The rendering should include landscapes to give it a physical context. However, no additional structures like parking lots or surrounding buildings are required. - Rendering should be from an aerial perspective, not eye-level or interior. Would be best if you have prior experience in creating similar renderings and possess a strong understanding of construction planning and landscaping. Skills required: 3D Design, Architectural Rendering, Landscaping.

OUR BUDGET IS $400 ALL BIDS OVER THAT PRICE WILL BE REJECTED IMMEDIATELY. If you really want this project I suggest using the chat feature. I need someone who is able to make m...you really want this project I suggest using the chat feature. I need someone who is able to make me a smooth and impressive looking 3D Website for our brand, the name of our company is RM MEDIA, and we are going to start selling 3D websites as well, now we are looking for someone that’s going to look at the bigger picture, if you do a good job we will hire you permanently for all our 3D website jobs and the pay will be much better. If you don’t have experience on don’t respond to this post. The price is non negotiable unless you have something so good I might consider investing a li...

I urgently need a ...optimizer. I have project management experience in the fields of information technology, construction, and management in both Arabic and English. Specific needs: - Reconstruct my current CV to attract more job opportunities. - Optimize my LinkedIn and Indeed profiles to improve my online presence and visibility. - Knowledge and understanding of the IT, Construction and Management sectors will ensure the proper emphasis is put. - Completion in the shortest possible timeframe. Ideal candidate should have: - Proven experience crafting compelling CVs for diverse industries. - Success in optimizing LinkedIn and Indeed profiles. - Proficiency in both Arabic and English. - An understanding of IT, Construction and Management sectors. - An ability to w...

I need a very talented person who can debug via anydesk/teamviewer for some schedule task related jobs. knowledge in hangfire debugging is mandatory

I require assistance with my MySQL database which contains birthday data. Currently, the birthdays are sorted by year, though I need them to be sorted by day. The given birthday data is formatted as a date. I need a professional who is an expert in MySQL to help sort these records and retain accurate data. * Key Job Requirements - Proficient in MySQL - Able to sort date-type data in MySQL - Detail oriented for data accuracy The ideal candidate should have a solid understanding of database management, more specifically in MySQL. Your role will be to sort the birthdays in the required order: day, then month. Confirmation of understanding of this order is essential for job success.

Hi, I have a dynamic button In web page when fire the button the page getting refresh so need solve it

we are looking for a seasoned virtual assistant who thrives in a remote work setup and is a master of efficiency. You will be responsible for: - Posting jobs - Managing all the applicants by sending one time message. Your experience on LinkedIn will be a huge advantage for this project, ideally, please include how many years you have been on LinkedIn. We are more interested in the quality of your work than the duration of your time on LinkedIn. Ideal Skills: - Proven experience as a virtual assistant - Strong understanding of LinkedIn's platform and features - Excellent organizational and multitasking abilities - Strong communication and people skills Prior experience in recruitment is a plus, but not mandatory. If you're confident in your ability to meet the requ...

I'm in need of a freelancer who can supply a database of local contact numbers needed for our telecalling campaigns. This project will involve curating a list of valid, local mobile numbers that our team can use to reach potential customers. Thus, experience in data mining and knowledge of local number systems is ideal. The selected freelancer will respect all guidelines in terms of legality and data privacy. here is the category. we need this data pan india general coucils corporate lawyers company secretary legal heads legal advisor chief council Regional council Please quote me per data. You must provide sample of 10 records to prove efficiency.

I'm seeking a skilled developer to execute the construction of a task management mobile app called "Taskify". Taskify is a mobile app designed to streamline task management. Users can create, organize, and track tasks effortlessly. Features include task creation, deadline alerts, priority management, and synchronization across devices. Skill Requirements: Proficiency in Java for Android app development Experience with Android SDK and XML for UI design Knowledge of SQLite for local data storage Understanding of notifications and background tasks Optional: RESTful API integration for cloud synchronization Optional: Firebase for user authentication and data backup Version control using Git for code management. - Primary Purpose: The key purpose of the Taskify app is ...

We currently run an online magazine for the transport and construction industry in Austria (). I plan to move to the Philippines in June this year and am planning a similar project there: Domestic News A regional online magazine was to be created and reproduced in a franchise. Each franchisee will fill the contents themselves. The website appears under a subdomain, for example www.domestic-news/manila I need: - An easy-to-use CMS with login for every franchisee o Customer data (company, name, address, email, web, telephone) o Customer data – export to Excel o Rubrics prepared according to template - Deactivation of categories without content - Expansion of categories by franchisees - Frontend design is already sketched (in the appendix) - All images in 3:2 format