City state schools databaseJobs

...videographers from around the globe to capture long-duration videos of "views from a window." Whether it's a scenic landscape, a bustling city square, or a lively construction site, we want to see what's happening outside your window. The footage should be filmed from a window, balcony, or roof, capturing the environment in a wide shot. Other filming locations can be discussed individually. Requirements: Minimum video length: 3 hours (longer is preferable). Resolution: 4K, filmed on any camera or smartphone. The camera must be stable (tripod or similar). Original ambient sound only, no editing, no voiceovers or background noise. Provide location details (country, city, area) separately; no personal data. Raw, unedited video only. The video might be us...

...facing is related to database interactions. I use 2 types of phones: samsung s4 gt-i9505 and samsung s4 gt-i9515. They should be identical, but the application running on gt-i9505 phones frequently gives this error: ": server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request." I need someone to help me debugging this error as the application can't be shared. I appreciate that this isn't a high-urgency task, so you'll have some flexibility with timing. However, it's important to me that the issues are resolved effectively and efficiently. Ideal skills and experience for this project include: - Proficiency in Django development - Strong understanding of database...

...throughout the video. Creativity is yours. Music : - -- -- - - -- - Video script - - - - - - - - - - The video opens up with our female heroine that is dressed in a cyber punk armour looking at a dystopian city from up on a hill. From afar it looks peaceful and the sky has a welcoming colored tone. Far from the higher means In a world that ‘ll forever be surreal We’ll find our own demands As we get closer to the city we focus on a big skyscraper and notice a man dressed in a suit looking down at the streets. People below are starting to gather and protest in a peaceful manner. Climbed through high roads of steel In a search for anything that’s real Fame blinds, it won’t redeem As we get closer to the man

...chance to shape the future of defense training. About Us: VRAS is a startup with strategic collaborations within the Israeli defense industry. Our focus lies in developing advanced VR simulations tailored for the defense sector. We aim to provide security forces, military, and law enforcement with affordable and innovative XR training solutions. Company Vision: At VRAS, we envision a future where state-of-the-art technology optimizes defense training, ensuring peak performance in real-life combat scenarios. Why Join Us: Strategic Partnership: This is more than just a job – it's an opportunity to become a key partner in our expansion, leading our machine learning initiatives to new heights. Leadership Role: As the Senior Machine Learning Engineer, you'll spearhead...

Vær venlig at Tilmelde dig eller Log ind for at se detaljer.

Seeking a Northeastern US based expert in Warehousing & Distribution to review a proposed building blueprint sit...a Northeastern US based expert in Warehousing & Distribution to review a proposed building blueprint site plan, to evaluate and understand whether it's best classified as "Warehouse Storage" or a "Truck Terminal" variety of intended use. Then, write a fact-based summary, detailing the specific definition and intended use of each of these two building classifications, including pictures, and state how and why this specific proposal aligns with one of the two. The provided write-up must be in a format, with necessary sourcing footnotes, etc., where it could be admissible as evidence. The selected industry expert should have 15+ years...

I'm in urgent need of an experienced gardener who can bring my 500 to 1000 square meters lawn back to life. It's currently overgrown and requires a heavy cut. Necessary Skills and Experience: - Proven experience in lawn care and maintenance. - Knowledge on how to handle overgrown grass and bring it back to an appealing state. - Ability to perform the task with no specific areas to avoid, therefore, meticulous attention to detail is required. This job will best suit a detail-oriented, responsible, and experienced gardener who understands the importance of bringing an overgrown lawn back to its natural beauty.

I'm looking for a proficient Data Entry Expert for online database management on MySQL. Your tasks will involve entering and managing data in the MySQL database effectively and efficiently. Key Requirements: - Must possess strong online data entry skills. - Should have experience in working with MySQL. - Familiarity with structured form data is essential. - Attention to detail to ensure data accuracy. - Strong organizational skills to manage and track data in a large-scale database. Your responsibility will be to keep the database updated. This project requires an efficient individual who can deliver accurate work within the stipulated timeline. If you think you're suited for this job, let's connect.

This system would use GPS to track the location of garbage trucks and ensure that they are picking up trash from all parts of the city. The system could also provide real-time updates on the level of garbage in each truck, so the city can adjust its collection schedule as needed. In addition, the system could send alerts to residents when their trash has been picked up, so that they can put out their garbage on the correct day.

I am seeking an artist to create six small-medium sized (larger than 8x10, but less than 16x20 inches) pieces of art, each representing a different city. - Art Style: I prefer a realistic style. It should encapsulate the city's spirit and charm. I am also open to somewhat abstract pieces as well. - Subject Matter: Feel free to choose your subject, it can be an iconic monument, a historical building or a captivating city skyline. Whatever you believe best embodies the city. - Size: As mentioned, each artwork piece should be medium size, 16x20 inches. Ideal candidates should have previous experience in creating realistic cityscapes and should be adaptable with varying subjects. Please provide samples of past work with your bid.

...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: - Strong expertis...

...high-quality textures from our provided high-resolution images. These textures not only need to be created but also integrated into the configurator. Additionally, fine-tuning of lighting, shadows, and the entire scene is required to achieve an extremely realistic appearance. To provide you with a clear idea of what we aim to achieve, we have attached some images and a video showing the current state and the desired outcome. To assess the quality of your work, we would like to commission the following tasks initially: Convert the "Wild-Oak" image into an extremely realistic texture using all necessary mappings. Apply this texture to the furniture piece and optimize the scene with lighting and shadows. Upon successful completion of this task, we would like to integrat...

...migrations to create the tables. Implement Eloquent to interact with the database. Integrate Laravel Mail to send emails. For frontend, use Blade along with Bootstrap (or Tailwind CSS). Maybe something ready, open-source. Frontend is not a priority. Optional: - Write Pest (or PHPUnit) tests to verify and ensure the operation of core functionalities, including user operations. Documentation: A file should contain instructions for installing and running the task. Task 2: The application should store information about our new customers. • The database should contain 2 tables – customers and countries. o Fields for customers – ID, First name, Last name, Email (should be unique), Phone, Country ID, City, Active, Created, Changed. Yo...

...It's preferred to have a minimalistic design to the user interface. This not only involves the effective use of space, but also keeping the interaction intuitive and high on usability. • Functionality Enhancements: Enhance existing features of the application for better performance and improved user experience. Ideal Skills: - Advanced knowledge in React.js, including concepts like immutable state - Experience with popular React.js workflows - Familiarity with RESTful APIs - Ability to understand business requirements and translate them into technical requirements - Aptitude for learning and applying modern technologies quickly. The selected freelancer should showcase their experience in their application. Assure me that you're the right fit for this proje...

I need a Django professional to manage a sensitive task involving the masking of our project's database. Your primary role will entail implementing encryption on our data. Key Responsibilities: - Generate an encryption key. You’ll be responsible for creating a robust and secure encryption key. - Implement Database Encryption. Utilise your Django expertise to seamlessly integrate encryption without compromising the performance or accessibility of our database. - Maintain Data Format. It is critical that the encrypted data retains its original format. Ensure that no distortions occur during this process. Ideal Skills: - Proficient in Django - Knowledgeable in database structures and encryption - Proven ability to generate secure encryption keys - Exp...

...in Oklahoma City, Oklahoma Friday April 26th. I need the advertisement to be in digital format and I need help creating the artwork or images to include in the ad. The advertisement should effectively promote my erotic massage business and convey that i'll be in Oklahoma City, Oklahoma Friday April 26th and i'll be taking only 3 appointments that day so space is limited. The target audience should be women who are interested in relaxation and stress-relief after a long week. I need someone who is creative and experienced in creating ads that will raise awareness of my business. Important details to add to the advertisement Only for women - please add to all entries Location: Holiday Inn Express & Suites Oklahoma City Dwtn - Bricktown, an IHG Hotel -...

Seeking a SQL specialist (4-5 hr/day part time remote job) excelling in data partitioning, ...time remote job) excelling in data partitioning, indexing, complex query calculations, and impeccable SQL design. Here's a snapshot of what my project entails: - Enhancement of a medium-scale database (1,000 - 10,000 records) using best practices - Expertise in SQL Design for efficient data management - Aptitude for complex query calculation to enhance speed and accuracy - Proficiency in data partitioning and indexing - Equally prioritizing both query optimization and database design - Excellent communication skills for steady project updates Ideal candidates must have a knack for balancing database design and query optimization. Let's push the boundaries of what S...

I have a project that involves entering textual data from physical documents into a database we are creating. Key details: - The data is textual in nature and will be provided to you in physical document form. You will need to accurately transcribe this information into our database. - The primary goal of this project is to create this database. Ideal skills and experience: - Strong attention to detail is critical for this project as accuracy is a key requirement. - Previous experience with data entry is preferred, especially when working with physical documents. - Familiarity with database software would be a bonus, although not necessary. - Excellent organisational and time management skills to ensure the project is completed efficiently.

We are looking to analyze the effect of YouTube advertising on consumer behavior. As part of our ongoing market research initiatives, we need an expert to collect and analyze consumer behavior data specifically related to this advertising platform. The online questionnaire has been prepared by us. We need you to collect data from real responses from the city of Ahmedabad Key Responsibilities: - Collection of consumer behavior data through a ready questionnaire from Ahmedabad. Ideal Skills: - Experience in market research - Ability to gather, analyze and interpret complex data - Knowledge of consumer behavior - Familiarity with YouTube as an advertising platform Understanding our consumer's response to YouTube advertising will contribute greatly to our marketing strategies...

I'm looking for a screenplay writer who can bring a dramatic twist to a city-based murder mystery. The script will be centered on the following elements: * A serial killer story * Revenge of the protagonist If you can write a screenplay on a plot that i have please contact us

write a query in the attached database that copies the last record created in the customer table and copies it to the merge table overwriting any record that exists in the merge table. There should only ever be one record in the merge table. Return the testdb access database to me with the query that performs the above action. Piece of cake for access DB guru

I'm seeking a skilled legal writer experienced in appellate briefs, specifically for the State Appellate Court. I require assistance with: - Structuring and Organizing: The brief should be well-organized and adhere to the court's rules. It must be 20 pages long. - Legal Arguments: You'll need to compile compelling legal arguments. - Citations and Authorities: Proper referencing of authorities and citations is needed. Ideal candidate will have experience in writing appellate briefs, a strong understanding of the State Appellate Court rules, and excellent legal research and writing skills.

I am seeking a proposal writer w...proposal writer with an understanding of smart city development, specifically focused on transportation improvements. The emphasis of the proposal is to map out a detailed strategy on how to upgrade existing road infrastructure to a more advanced, smart city-ready standard. The key aspects I want addressed in the proposal are: - Detailed plans for the implementation of automated traffic management systems. It is essential that you have knowledge and experience in smart city development, sustainable road construction practices, and Automated Traffic Management Systems. Strong technical and communication skills are needed to effectively articulate ideas and conform to the standard proposal format. Your input can help shape the future...

...it to draw IMEI numbers both randomly and from a database based on specific parameters. Key Features: - **Dual Functionality**: The tool should be capable of generating IMEI numbers randomly or by allowing me to specify certain parameters. - **Parameter Selection**: The parameters that I should be able to choose from when generating IMEI numbers are the device brand and the operating system (OS). - **Web Interface**: The tool should be accessible through a user-friendly web interface that allows me to easily generate the IMEI numbers. Skills and Experience: - Proficiency in Python, as I believe the tool can be built on existing scripts like ``. - Experience in working with databases, ideally with knowledge of the TAC database. - UI/UX design skills to create a simple an...

...competent freelancer with an understanding of MS Access Database creation. This project is aimed at developing a food manufacturing cost-tracking function on top of an existing product management database, while cleaning the existing database up and adding reporting functions. The project involves: 1. Cleaning up existing Database file of Products to a new layout (Can start again or build on existing file). 2. Adding the manufacturing cost analysis function to the database (Allows user to define ingredients and fixed costs for a product and calculate it’s cost price). 3. Adding the sub-recipe costing function – same as above, however, for internal products not sold. 4. Adding the ingredient purchase price and tracking to the database...

I’m seeking a skilled SEO expert for optimizing my retail store's Google My Business listing for local search results, specifically targeting the city. As an ambitious retailer, I want to efficiently rank for product names. Ideal skills and experiences: - Specialization in local SEO - Focused knowledge of optimizing Google My Business listings - Strong experience with keyword research and planning for product names - Demonstrated success ranking for local business, preferably retail stores Potential freelancer should detail their strategy for local SEO optimization and outline their experience with similar projects.

...Development: You will be responsible for developing different components of the application. Your expertise in ReactJS is crucial for creating these components in an efficient manner. - State Management: Proficiency in state management with Redux is mandatory, as you will be handling the state of the application using Redux and Redux Toolkit. - API Integration: You will need to integrate various APIs into the project, ensuring seamless communication and data exchange between the application and external sources. Skills and Experience: - Fluent in Telugu - Proficient in ReactJS with prior experience in component development, state management, and API integration - Strong understanding and experience with Redux and Redux Toolkit - Familiarity with Material UI ...

...extensive experience in MS Access database management. The project involves merging and transforming existing MS Access databases. Key Tasks: - Database Merging: You will be required to merge multiple MS Access databases into a single, coherent database. - Data Transformation: The data within these databases will need to be transformed to fit the new structure. - Query Optimization: Your role will also include optimizing queries to ensure efficient data retrieval and manipulation. Key Objectives: My main goal is to facilitate easier data management through this process. The end result should be a well-structured, consolidated database that is optimized for performance. Ideal Skills: - Proficiency with Python and MS Access - Extensive experience in data...

I'm in need of an experienced architect or interior designer who can create a detailed renovation plan for my old waterfront home in Annapolis, Maryland. The property has gotten into a dilapidated state and I am looking to completely transform it into a modern style while preserving its coastal charm. Key Renovation Aspects - Interior Remodeling: The interior space of the house, which stands at 1300 sq ft, requires a full overhaul to bring it up to modern standards. This includes but is not limited to, flooring, walls, ceilings, and fixtures. - Exterior Painting: The exterior of the house will need a fresh coat of paint to restore it to its former glory and protect it against the elements. - Kitchen Renovation: A complete modernization of the kitchen is necessary to make the s...

Project Title: Customizable Excel-Based Mark Book System for English Learning Area Tracking This reads like a lot, but I am only trying to be clear. It's just a mark book. Project Overview I need a skilled Excel developer to create a solution that helps schools track student progress against specific English Achievement Standards across year levels of the Australian Curriculum. The goal is to pinpoint areas needing improvement, empowering schools to target resources effectively. Is it Speaking and Listening, Reading and Viewing, or Writing and Creating? If so what particular Aspect (sentence? Key Requirements Foundation: Excel workbooks to accommodate multiple teachers and classes. Structure: Year Levels (tabbed sheets) with each year's Achievement Standa...

I need a NoSQL database system that can effectively manage our company's purchases, production, and inventory. The project needs to be completed within a month. Attached the Project details ... Key Features Required: - Scalability: The system should be able to handle large amounts of data and growing demands. - Flexibility in Data Modeling: I'm looking for a system that can adapt to our changing business needs without compromising on performance. - High Performance: It's crucial that the system can process data efficiently and provide real-time insights. Ideal Skills and Experience: - Proven experience in designing and implementing NoSQL database systems. - Strong understanding of data modeling and its impact on system performance. - Ability to deliver a sca...

...spaces that inspire creativity and cater to a variety of photographic styles. Job Description: We are seeking a dynamic remote Content Writer to craft and manage compelling content across our website and social media platforms. This role involves writing engaging blog posts about photography and the experience of shooting in our studios, creating fresh descriptions for our studio spaces in each city, and developing a robust content plan that aligns with our brand and audience's interests. Key Responsibilities: - Write captivating blog posts focused on photography techniques, trends, and the unique experiences offered at our NY, LA, and Chicago studios. - Write SEO-optimized texts. - Regularly update studio descriptions to reflect the unique features and ambiance of each ...

I'm looking for a skilled developer to create a React component that can load SCORM packages and interact with users. Key requirements: - The component should be able to load SCORM 1.2 and 2004 packages - It should be compatible with iSpring exported packages - It should listen and store all the events to an API - It should store the suspend data and resume the last state of the user - It should track the same events as on scorm debugger We will provide package examples that should be compatible

I need a freelancer to conduct thorough research and build an extensive list of destination marketing organisations in 17 cities across North America. These include New York City, Los Angeles, Chicago, Boston, Orlando, Miami, Dallas, Houston, Seattle, Philadelphia, Washington, Denver, Minneapolis, Toronto, San Francisco, Hartford, and Cleveland. Key data points needed: - Names of CEOs and CMOs - Email addresses - Telephone numbers - LinkedIn profile links In addition to this, please include the advertising agency of record for each organization. This assignment demands exceptional research skills, meticulous attention to detail and familiarity with LinkedIn and other relevant resources. Prior experience in industry-specific research or creating contact lists would be an add...

I'm on the hunt for a talented graphic designer to make the perfect logo for our security guard business. We're prioritizing a logo that encapsulates elements of trustworthiness and safety. It's not just a decoration, it's a key component in representing the essence of our brand. Company details: Name: New York City Guard Service: Security Guard company Colors: Dark Blue: #092265 Yellow: #e3f877 Orange: #fd5921 Design should resemble New York City police logo Key requirements: - The logo must exude the feelings of safety and trustworthiness to anyone who sees it. - The logo must stand out proudly and resolutely when used in various use cases (websites, business cards, merchandise, signage, etc.) - Concise, minimalist design yet impactful would be perf...

I'm looking for an experienced grant writer who can help my non-profit organization secure funds. The main objective of our organization is to promote the campaign of Stephen C. Maxwell for the Governor of Tennessee in 2026. We're committed to using this funding to support our campaign activities and amplify his vision for the state. Your responsibilities will involve: - Researching and identifying suitable grants - Crafting compelling narratives for grant proposals - Managing all aspects of the application process Ideal Skills: - Proven experience in grant writing preferably for political campaigns - Knowledge of Tennessee political landscape - Strong written communication and persuasive writing skills - Attention to detail and ability to meet deadlines.

...permitting for industrial facilities. Specifically, I require assistance with obtaining an air permit for a large peanut roasting facility. Key Responsibilities: - Analyzing the air emissions of the facility including particulate matter (PM), volatile organic compounds (VOCs), and carbon monoxide (CO). - Preparing all necessary paperwork for permitting this facility. - Ensuring compliance with local, state, and federal air quality regulations. Ideal Skills and Experience: - Proficiency in environmental engineering, particularly air quality and emissions. - Prior experience with permitting industrial facilities, preferably food processing or similar. - Strong understanding of local and federal air quality regulations. - Adept at paperwork preparation and ensuring regulatory comp...

I'm looking to hire a web developer and designer proficient in building an aesthetically pleasing and functional character-storage site that is equally immersive. Key Features: - A platform for managing and displaying detailed character profiles. - Capabilities to categorize data such as names, descriptions, stats, abilities, and corresponding images or artwork. - An integrated search feature to filter out specific character types. Artwork Requirements: - The site should be able to host a variety of artwork formats like character illustrations, and digital paintings. - The developer should implement features for GIF support, to showcase more dynamic character pieces. The ideal candidate has previous experience designing and developing similar sites, a keen eye for aesthetics, exce...

I'm in need of a data handling professional. Gig is $36 Max. I have a large excel file that houses data from multiple sources but the columns are misaligned. I want it to be organized to Name, email, city, state, phone number, additional info columns. Your task will be to: - Correctly align the columns - Merge any duplicate records Ideal freelancer would have: - A strong background in Excel - Experience in data cleaning - Proven track record of handling large datasets - A keen eye for detail to spot and fix misalignments

I'm in need of a professional Android developer to create an app that centers around collecting and sharing the vehicle and owner's information. Key Features: - Data Collection: The app should be able to collect the vehicle make and model, registration number, owner's name, Adhaar Card Number, along with the state, district, and address of the owner. Additionally, I would require the app to have the capability of taking the photo of both the vehicle and the owner. - User Authentication: The app should allow users to log in using a unique login id and password. Ideal Candidate: - Proficient in Android app development with a portfolio of relevant projects. - Experienced in data handling and secure storage on mobile devices. - Familiar with developing apps that requi...

Hi, this is an offer for the project we talked about.

...freelance affiliates to join our team and partner with us in revolutionising education through STEM (Science, Technology, Engineering, and Mathematics) programs in K-12 schools. As STEM education becomes increasingly essential in preparing students for the future, schools across the nation are eagerly adopting STEM programs and tinkering labs. We are seeking motivated individuals who can help us establish partnerships with schools in their local area. What We Offer: Fixed Percentage for Lifetime: As an affiliate, you will have the opportunity to earn a fixed percentage of revenue every year from the business generated through schools you bring on board. This percentage will be provided for the lifetime of the partnership with the school, ensuring a steady a...

I am looking for an experienced Data Entry Operator for a specific task. The main pur...Data Entry Operator for a specific task. The main purpose of this task is to help organize our customer database. Apart from entering data, the operator should ensure that sensitive customer details are properly handled with care and confidentiality. To apply: * Present a detailed project proposal that shows you have fully understood the requirements of the job. Ideal Skills and Experiences: * Proven data entry work experience. * Sensitive to data privacy issues. * Strong attention to detail. * Proficient with Microsoft Office and data programs. Please note: data migration or data analysis is not needed for this role. The focus is on data organization. Let’s make our customer da...

...a comprehensive research and writing expert in the field of fusion energy. I need this project to cover a range of specific areas within this topic, including current research and development, potential applications and an overview of companies and supply chain companies related to fusion energy. Key deliverables include: - A minimum of 10 research papers and articles that showcase the current state of fusion energy research and development - Analysis of these findings with a focus on key insights and future outlooks - An in-depth review of the potential applications of fusion energy Ideal skills and experience for this job include: - Strong background in physics, ideally with a focus on energy - Prior experience in scientific research and writing - Ability to analyze and synth...

I am looking for a skilled profes...focus for the lead generation should be professionals in Madrid who are potential customers for our services. Ideal Skills and Experience: - A proven track record in lead generation will be highly appreciated. - Familiarity with the local Madrid market or previous experience in generating leads in the city would be a plus. - Strong communication skills and a proactive attitude are essential for this role. The quality of the job will be assessed on the base of the completeness of the database and the validation on the field. A good quality job will likely lead to the expansion of the service to all Spain and other European countries. Please be aware that this is not a media content generation job. Please don't apply if you don'...

I'm looking for an experienced individual who can perform research and registrations for my Company in various state procurement sites across the USA such as Alabama, California, Florida, and more. Your tasks include: - Understanding and following written instructions accurately - Executing company registrations as a vendor or supplier - Managing all necessary paperwork and forms during the registration process - Someone who can apply logic, and research NAICS or commodity codes that represent what Our company has to offer. As we are in the Debt/Recovery Data Services sector. Attention to detail, organisational skills, and the ability to diligence navigate state-specific procurement processes are vital. I'm eager to partner with someone who can remove the b...

I need a digital drawing expert who is accustomed to drafting commercial building designs for construction permit submission. The drawn design will be launched in a city for a construction permit. - Proficiency in digital drawing. - Background experience designing commercial buildings. - Familiarity with construction permit submission requirements. Your work will play a vital role in obtaining the construction permit for our project's inception in the city.

We need a flyer to appeal to Principals, Vice Principals, and Band Directors of Local Schools. DO NOT ADDRESS IT TO THE STUDENTS. ADDRESS IT TO THESE AUTHORITY FIGURES. Be creative! It must include: -The fact that we offer private lessons -The fact that we offer group lessons -The fact that we can help set up a School Jazz or Marching Band. Add a short paragraph about the importance of music. (just 2-3 sentences.) End it with 'Studies show that kids who are engaged in Music score 20% higher on their tests!' Please include our contact info: Store Number: 352-243-5868 Lesson Coordinator Number: 321-201-8038 And the included logo. We don't have it in a vector, but we'd rather you just make the background of the flyer black as well.

...table: Show all cities in a table format with infinite scroll (use this api to get the city data: ). The table should have columns city name, country, timezone etc. Implement search as you type for this table. Utilize an autocomplete feature to suggest possible locations as users type. Implement filter and sorting for each column Clicking on the city name, should take to to the weather page for this city Right clicking on the city name and opening in the new tab should also open the weather page for the city but in the new tab. Weather page: You can reach this page by clicking on the city name in the table section as mentioned in the previous section. Use https://openweathermap

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