Find Jobs
Hire Freelancers

MySQL Database Creation -- 3

$30-250 USD

Closed
Posted about 1 month ago

$30-250 USD

Paid on delivery
Create a relational database for the following data in a single tables with parts store. You may use alphanumeric to represent store and use surrogate key as primary key. Bring a hard copy in class and answer two quires in class. (points Project creation 20 + two query 20) 1. Vendor 1: Low Hardware, 1200 Harding st, Pine Bluff, AR 71602, Phone 870-535-1000 Supplies screw Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .02 300 Yes 100 .04 6-12 Yes 3/4” .03 300 Yes 200 .06 6-32 Yes 1” .04 400 Yes 200 .08 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes 20 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” .06 400 NO 0 .12 8-32 Yes 1” .07 400 NO 0 .14 8-32 Yes 1 ¼ .08 100 Yes 100 .16 8-28 NO ½” .06 0 Yes 50 .12 8-28 NO 1” .07 0 Yes 50 .14 ¼-20 Yes ½” .05 400 yes 100 .10 ¼-20 Yes ¾” .06 400 Yes 10 .12 ¼-20 Yes 1” .07 500 yes 200 .14 ¼-20 Yes 1 ¼ .09 500 yes 200 .16 ¼-20 Yes 1 ½” .10 600 Yes 100 .18 ¼-20 Yes 2” .15 500 Yes 20 .30 ¼ -24 Yes ½ .06 100 yes 50 .12 ¼ -24 Yes ¾” .07 100 No 0 .14 ¼ -24 Yes 1” .08 200 Yes 100 .16 ¼ -24 Yes 1 ¼” .10 100 Yes 200 .20 2. Vendor 2: AEC Hardware store, 202 main St, White Hall, AR 71604, Phone 870-543-7689 Size Steel Size Unit Price QTY Stainless Steel QTY Unit Price 6-32 Yes ½” .01 300 Yes 100 .04 6-12 Yes 3/4” .03 200 Yes 20 .06 6-32 Yes 1” .03 400 Yes 200 .08 6-32 Yes 1 ¼” .05 100 Brass 0 .10 6-32 Yes 1 ½” .06 400 Yes 200 .12 8-32 Yes ½” .04 300 Yes 20 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 No ¾” .06 0 Brass 0 .12 8-32 Yes 1” .07 200 Brass 0 .14 8-32 Yes 1 ¼ .08 100 Yes 10 .16 8-28 NO ½” .06 0 Yes 50 .12 8-28 NO 1” .07 0 No 0 .14 10-24 Yes 1” .10 100 Brass 100 .20 10-24 Yes 1 ½” .12 100 Brass 150 .25 10-24 yes 2” .16 100 Brass 50 .30 12-24 Yes 1” .12 200 Brass 0 .35 12-24 Yes 2” .18 50 Brass 0 .50 ¼-20 Yes ½” .05 100 yes 10 .10 ¼-20 Yes ¾” .06 400 Yes 200 .12 ¼-20 Yes 1” .07 500 yes 100 .14 ¼-20 Yes 1 ¼ .09 500 yes 20 .16 ¼-20 Yes 1 ½” .10 700 Yes 100 .18 ¼-20 Yes 2” .15 500 Yes 20 .30 ¼ -24 Yes ½ .06 100 yes 50 .12 ¼ -24 Yes ¾” .07 100 No 0 .14 ¼ -24 Yes 1” .08 200 Yes 100 .16 ¼ -24 Yes 1 ¼” .10 100 Yes 200 .20 3. Vendor 3: Home Depot, 1000 Markham st, Little Rock, AR 71605, Phone 479-225-1235 Size Steel Size Unit Price QTY Stainless Steel/Brass QTY Unit Price 6-32 Yes ½” .01 300 Yes 10 .04 6-12 Yes 3/4” .03 300 Yes/Yes 200/100.06/.10 6-32 Yes 1” .03 400 Yes/Yes 20/50 .08/.11 6-32 Yes 1 ¼” .05 300 No 0 .10 6-32 Yes 1 ½” .06 500 Yes/Yes 200/5 .12 8-32 Yes ½” .04 300 Yes 200 .08 8-32 Yes ½” .05 400 Yes 100 .10 8-32 Yes ¾” .06 100 Yes/Yes 10/75 .12/.15 8-32 Yes 1” .07 400 Yes/Yes 50/5 .14/.15 8-32 Yes 1 ¼ .08 100 Yes 100 .16 8-28 Yes ½” .06 200 Yes 50 .12 8-28 Yes 1” .07 200 Yes 100 .14 10-24 Yes 1” .10 100 No/Yes 200 .15 10-24 Yes 1 ½” .12 200 Plastic 150 .15 10-24 yes 2” .16 100 Plastic 200 .20 12-24 Yes 1” .12 100 No/No 0 .50 12-24 Yes 2” .18 50 No/No ¼-20 Yes ½” .05 400 yes/yes 100/50 .10 ¼-20 Yes ¾” .06 400 Yes/yes 10/50 .12 ¼-20 Yes 1” .07 500 yes/Yes 200/5 .14 ¼-20 Yes 1 ¼ .09 500 yes/yes 200/75 .16 ¼-20 Yes 1 ½” .10 600 Yes/Yes 100/10 .18 ¼-20 Yes 2” .15 500 Yes/yes 200/50 .30 ¼ -24 Yes ½ .06 100 yes/Yes 10/25 .12 ¼ -24 Yes ¾” .07 100 No/yes 0/50 .14 ¼ -24 Yes 1” .08 200 Yes/Yes 100/50 .16 ¼ -24 Yes 1 ¼” .10 100 Yes 200 .20 5/16-18 Yes 1” .20 50 Plastic/Brass 50/50 .25/.50 5/16-18 Yes 2” .25 50 Plastic 100 .30 5/16-18 Yes 3” .30 10 none 5/16-18 Yes 4’ .35 .20 Brass 10 .35 All the answers must have a question, query and the answer. Copy the answer from mysql paste it on MS word and save.
Project ID: 38003221

About the project

56 proposals
Remote project
Active 10 hours ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
56 freelancers are bidding on average $135 USD for this job
User Avatar
Hello, I have 10 years of experience in Linux and Mysql. I will create data in a single tables with parts store. Regards, VishnuLal
$200 USD in 1 day
5.0 (308 reviews)
7.0
7.0
User Avatar
Hi there I propose to create a single table relational database for the parts store data provided. Each vendor will have a unique alphanumeric representation and a surrogate key will be used as the primary key for the table. This database will allow for efficient storage and retrieval of all the information related to the vendors and their supplied parts. Query 1: Retrieve all information for Vendor 1 (Low Hardware) SELECT * FROM parts_store WHERE vendor = 'Vendor 1'; Query 2: Retrieve the total quantity and unit price for all stainless steel screws provided by Vendor 2 (AEC Hardware Store) SELECT SUM(QTY), SUM(Unit Price) FROM parts_store WHERE vendor = 'Vendor 2' AND Steel = 'Yes' AND Stainless Steel = 'Yes'; Answer: - Query 1: Displays all the information for Vendor 1 (Low Hardware) - Query 2: Returns the total quantity and unit price for stainless steel screws provided by Vendor 2 (AEC Hardware Store). I can provide links to similar works from my portfolio. Please go through my profile its 15 years old see the work I did over the years. ---> No Win No Fee means that your satisfaction is my utmost priority. <---- Lets discuss the job details. Moreover, I am willing to start the job and perform tasks without even being hired; it is just to show my commitment to this project. Looking forward to hear from you. Regards Shah
$163 USD in 7 days
4.8 (62 reviews)
7.1
7.1
User Avatar
Hello, I can start immediately. I have 13+ years of experience and I ensure you I can complete the project within budget and timeline. I'm not just a developer; I'm your dedicated partner. I'm committed to working with you. Count on me for any upgrades or specific requirements you may have along the way. I have few questions about the requirement. Can we discuss this over chat? Looking forward to hearing from you soon. Best regards, Sneha
$190 USD in 7 days
5.0 (68 reviews)
6.6
6.6
User Avatar
⭐⭐⭐⭐⭐ Hi there, I am full stack developer with 7+ years of experience in website and desktop app development with Oracle, MySQL, MariaDB, SQL Server, PostgreSQL, MongoDB and more. I have strong expertise in Database design, Database modeling, Database optimization, SQL, PLSQL, Dynamic queries, pivot tables, Stored Procedures, Functions, Database Normalization, UML, ER Diagrams, Rational Schemas, Data dictionary and more. I have read all details, an easy job for me. Have a look at my profile for my portfolio and similar projects I've completed with reviews. Message me, I would like to discuss further details over chat.
$160 USD in 1 day
4.9 (41 reviews)
6.0
6.0
User Avatar
Hello, I'm AZAD, a long-time developer with commendable expertise in MySQL and database management. Over my extensive 8+ years of experience, I have created numerous proficient databases just like the one you need for your parts store with data from three different vendors. My coding and logical comprehension skills would ensure an optimized structure that meets all your requirements. My mastery over several programming languages such as Wordpress, Joomla, Php and knowledge of CSV integration have resulted in developing robust, functional backend systems for users. Having worked with similar large data sets before, maintaining data integrity while guaranteeing excellent query efficiency won't be any issue. Designing relevant and insightful queries is what I'm exceptional at - it would enable easy retrieval of pertinent answers from the database.
$140 USD in 7 days
4.8 (38 reviews)
5.9
5.9
User Avatar
Hi I am vinay having more then 13 yrs of exp i. Mysql database admin I can do this task for you quickly
$140 USD in 7 days
4.8 (49 reviews)
5.2
5.2
User Avatar
Alongside my extensive software development skills, I have also worked on a number of AI-focused projects utilizing Python, including deep learning and natural language processing systems. My experience in these areas have honed my abilities in data analysis which aligns perfectly with your project's need for a well-rounded, informed opinion on AI. Moreover, my passion for technology is not limited to programming but extends towards staying updated with the latest trends; AI being one of the prime areas of interest. With this enthusiasm, combined with my comprehensive proficiency in multiple languages and frameworks adaptable to new technologies and precise organizing talents, I am confident in providing you an excellent service aligned with your expectations.
$30 USD in 7 days
5.0 (6 reviews)
4.0
4.0
User Avatar
Please Check This Rest we can discuss in Chat Box Store 1: Low Hardware Vendor Table: Vendor_ID (Primary Key) Vendor_Name Address City State Zip_Code Phone_Number Part Table: Part_ID (Primary Key) Part_Name Size Material (Steel, Stainless Steel, Brass, Plastic) Unit_Price Quantity_Available Vendor_ID (Foreign Key referencing Vendor table) Store Table: Store_ID (Primary Key) Store_Name Address City State Zip_Code Phone_Number Store_Part Table: Store_Part_ID (Primary Key) Part_ID (Foreign Key referencing Part table) Store_ID (Foreign Key referencing Store table) Quantity_Available Store 2: AEC Hardware store The structure would be the same as Store 1, just with different data for vendors, parts, and quantities. Store 3: Home Depot Again, the structure would be the same as the previous stores, just with different data for vendors, parts, and quantities.
$45 USD in 7 days
4.9 (6 reviews)
3.2
3.2
User Avatar
Hello, I'm an IT expert with more than 20 years of experience in the IT industry . I'm Cisco Certified networking professional 300-100 and 300-115 and Linux Certified Professional lpi 101, 102,103 and red hat certified system administrator and VMware Certified Professional 4, 5,5.5 and Data Center and Microsoft System administrateur /Engineer ranging from 2003 to 2019 .
$100 USD in 1 day
5.0 (5 reviews)
3.1
3.1
User Avatar
Hi there, I'm an expert developer with 10+ years of experience and already done a lot of projects in relational databases like my sql, ms sql server and ms access, also I have rich experience in develop automation tools and office programming. I'm so interested to know a bit more details and work with you in this project. I can deliver a high quality work to you. Warmest regards
$400 USD in 7 days
5.0 (4 reviews)
3.2
3.2
User Avatar
I am expert in database creation and can help you achieve full marks i understand question completely
$50 USD in 7 days
5.0 (5 reviews)
2.9
2.9
User Avatar
Drawing on my extensive experience in database programming and my proficiency in MySQL, I am well-equipped to seamlessly create and manage your relational database for the parts store. Notably, my expertise isn't restricted solely to SQL; I am also proficient in Transact-SQL, pgSQL, and PL/SQL. Hence, I can confidently navigate any challenges or customizations your project may require. Additionally, by implementing powerful data visualization tools such as Power BI and Looker, I would enable a deeper understanding of the complex data stored in your MySQL database. This would prove incredibly valuable while tackling the two queries attached to this project, ensuring precise results are delivered with ease. Finally, not only am I adept at managing databases on-premise but also highly experienced with cloud-based platforms like BigQuery, Google Cloud Platform (GCP), and Oracle Cloud Infrastructure (OCI). As a result, I bring a holistic approach to database architecture that will empower your business to extract maximum value from its data infrastructure. I look forward to the opportunity to leverage my skills and experience for the successful completion of your project!
$140 USD in 7 days
5.0 (3 reviews)
2.9
2.9
User Avatar
Hi, let me do this for you. I will also create the SQL statement and the English explanation of the processes. Regards David.
$31 USD in 2 days
5.0 (1 review)
2.5
2.5
User Avatar
⭐⭐⭐======Hi Kalia W. =====⭐⭐⭐ I am excited to submit my proposal for your project. I have developed a strong set of skills that make me confident in my ability to deliver high-quality work to your project. My approach to any project is to first gain a deep understanding of the client's needs and requirements. I will work closely with you to ensure that I understand your project goals and objectives, and that I am able to deliver results that meet or exceed your expectations. In terms of technical skills, I have extensive experience in MySQL and Database Programming. I'm able to work independently, be detail-oriented, have strong problem-solving ability and excellent communication skills. Overall, I am confident that I can provide the best result beyond your requirements, and help you achieve your project goals. Looking forward to the opportunity to work with you and contribute to the development of the new website. Thank you.
$200 USD in 7 days
5.0 (1 review)
2.6
2.6
User Avatar
I am a professional, experienced, smart and premium developer. I can solve any of your problems. I have already done sth like this in my startup. Lets talk more. I guess we will reach to something.
$100 USD in 2 days
5.0 (1 review)
2.1
2.1
User Avatar
Dear Kalia W., I saw your project titled "MySQL Database Creation -- 3" and I'm interested in submitting a proposal. With over 10 years of experience in software development, I have a proven track record and strong expertise in the required skillset, including MySQL. Here's a bit more about my skillset: Skills: MySQL, Database Programming I'm confident I can deliver exceptional results for your project. Would you be open to discussing this further? Thank you for your time. Sincerely, A Mateen
$140 USD in 7 days
5.0 (1 review)
1.2
1.2
User Avatar
Hello Kalia W.! I'm thrilled about the opportunity to collaborate on your Project MySQL Database Creation -- 3. Rest assured, I'm dedicated to helping you achieve your project goals with utmost satisfaction. My approach involves providing daily updates and transparent notes on the progress, ensuring you're always in the loop. With extensive experience in MySQL, Database Programming, I guarantee top-notch quality and optimal performance at the most competitive rates. Timely completion and your satisfaction are my priorities. If given the chance, I'm confident you'll be delighted with the results. I'm ready to dive into further discussions and kickstart the project right away. Let's connect chat to explore your project requirements in detail. Regards, Murtaza
$120 USD in 3 days
5.0 (1 review)
1.0
1.0
User Avatar
My whole work goes around SQL , you can give a chance to me for the SQL based work. You wont Complain for sure.
$100 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Feel free to contact me for MySQL Database Creation .shoot me message to discuss further more details .i provide the comments,images,videos,demos and live sessions in order to help the clients. Make payment only after the work is done. Thank you
$200 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I propose creating a relational database with a single table named "Parts_Store" using a surrogate key as the primary key. The table will contain data such as part numbers, descriptions, quantities, prices, and store codes represented alphanumerically. This design will efficiently organize and manage the inventory data for the parts store.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Alexander, United States
5.0
18
Payment method verified
Member since Nov 11, 2020

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.