Database design project

$30-250 AUD

Closed

Posted

7 months ago

$30-250 AUD

Paid on delivery

Database design project I am looking for a database designer who can create a SQL database system for my project. Skills and experience required: - Strong knowledge and experience in SQL database design and development - Proficiency in data modeling and database normalization - Familiarity with best practices and industry standards for database design - Ability to understand and work with complex data structures and relationships - Experience in optimizing database performance and ensuring data integrity The ideal candidate should have a good understanding of the client's requirements and be able to design and implement a SQL database system that meets their needs efficiently and effectively. Additionally, since the client is not sure if they require a front-end interface for their database, it would be beneficial for the database designer to have experience in front-end development as well. This would enable them to provide the client with options and recommendations based on their specific needs and preferences. You are required to investigate and understand a publicly available dataset, design a conceptual model for storing the dataset in a relational database, build the database according to your design and host the data, and develop SQL queries in response to a set of requirements. The objective of this assignment is to reinforce what you have learned in the whole course. Specifically, it involves how to build a simple application that connects to a database backend, running a simple relational schema. Part A: Part A: Understanding the Data (0 Marks, Preliminary Work) Part B: Designing the Database (10%) Part C: Creating the Database (10%) Part D: Data Retrieval (15%)

SQL

Database Programming

MySQL

Database Administration

Database Design

Project ID: 37270859

About the project

59 proposals

Remote project

Active 6 mos ago

Looking to make some money?

Email address

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

59 freelancers are bidding on average $173 AUD for this job

@RockStone435

Hi, I have read details. As far as I understand it, I think you are looking for someone who can go through the requirements from your side, and prepare a database architecture for it. We will need your project goals, work flow, and information on the entities involved. Some projects require typical database elements that include logins, sessions, profiles etc. further it depends upon the complexity of the project itself. We will need to identify the entities involved in the project, and go through the data flow that is to be handled. Based upon that, we can create the database structure. one more thing, since you are not sure about the interface, at times when we talk about desktop and web-based applications, the database structure may differ. Web-based applications may include more tables to manage with the data processing that is done online. Since the client isnt sure about the interface yet, we may be interested in knowing atleast if its going to be web-based or desktop-based. I would also like to know if you need us to create tables, their storage variables etc. OR you need a more complete and complex design that include stored procedures, views etc (if we talk about SQL SERVER). Lets discuss this thorougly please. Note: you can provide me with the dataset that you already have, and I can create the schema. Tx.

$150 AUD in 7 days

4.9

(311 reviews)

8.0

@infowider11

Proposal for Database Design Project >>> Design and implement a SQL database system for a publicly available dataset <<< I am confident that I have the skills and experience necessary to complete this database design project successfully. I am eager to work with the client to understand their requirements and design a database system that meets their needs. I have experience in front-end development, including HTML, CSS, and JavaScript. I can provide the client with options and recommendations for a front-end interface for their database, if they require one. Part A: Understanding the Data Investigate the dataset and identify the key entities and attributes. Understand the relationships between the entities. Part B: Designing the Database I will Develop a conceptual model of the database using an entity-relationship diagram (ERD). I will Create a relational schema for the database. Part C: I will Creating the Database Part D: Data Retrieval I'll Develop SQL queries to answer the requirements specified by the client. The Deliverables; Part A: Documentation of the dataset and the data model Part B: ERD and relational schema Part C: SQL code to create the database and populate it with data Part D: SQL queries to answer the requirements ➥ INITITATE CHAT TO ME. ASAP* Awaiting for your response ! !! Looking forward to hearing back from you. Best regards, Shweta A.

$400 AUD in 16 days

4.9

(66 reviews)

8.0

@techplusintl

Hi there, ★★★ Database Design & Development Expert ★★★ 10+ Years of Experience ★★★ I've read requirements and ready to create a SQL database system. I have completed multiple projects across various domains like Manufacturing, Inventory Management and Vehicle Monitoring System. I do have strong SQL and Excel expertise, through which I will be able to provide you standard and professional way of solutions to your requirements. Services I offer: ✔️ ER, EER Diagrams ✔️ Database creation(Tables, Views, etc) ✔️ Database Design(Normalization, Constraints, etc) ✔️ Programming(Joins/Triggers/Sub queries/Functions/Operators/Views/Sequence) ✔️ Database Modeling, Standardisation ✔️ Bug Detection & Fixing ✔️ Data Security ✔️ Group and sort ✔️ Excel macros, formula ✔️ Data import/export/backup/restore (any format) Databases I work on: ✔️ Oracle ✔️ MySQL ✔️ MS SQL Server ✔️ MS Access ✔️ Sqlite ✔️ NoSQL ✔️ MongoDB As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team

$250 AUD in 2 days

4.9

(138 reviews)

7.7

@talhaamin

Hello, I am an expert in database designing and especially when it comes to designing databases for various assignments, I can not only understand the requirements but also have a look at the lectures to make sure, the assignment is according to the requirement and gets good grades. Lets discuss the details over chat.

$80 AUD in 7 days

5.0

(37 reviews)

7.5

@extreamcode

Hi There, I hope this message finds you well. I am writing to express my interest in your database design project. I have extensive experience and knowledge in SQL database design and development, making me an ideal candidate for this project. With my strong background in data modeling and database normalization, I am confident in my ability to create a well-structured and efficient SQL database system for your project. I am familiar with best practices and industry standards for database design, ensuring that the system will meet your requirements and adhere to industry standards. I have a proven track record in working with complex data structures and relationships, allowing me to handle any challenges that may arise during the database design process. Additionally, I have experience in optimizing database performance and ensuring data integrity, which are crucial aspects of a successful database system. Furthermore, I understand that you are unsure about the need for a front-end interface for your database. In this regard, I have experience in front-end development as well, which enables me to provide you with options and recommendations based on your specific needs and preferences. I can assist you in making an informed decision regarding the front-end interface, if required. For this project, I will thoroughly investigate and understand the publicly available dataset, design a conceptual model for storing the dataset in a relational database, build the database...

$140 AUD in 15 days

4.9

(20 reviews)

6.9

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep

$180 AUD in 3 days

4.9

(76 reviews)

6.9

@Truonggiang86

Hello there, I've been working as database specialist for over 13 years and I've done many database designing. I believe that first we need to create the ERD for the database, maybe Crowfoot notation or chen notation, next we will convert ERD to logic diagram and then implement the database in MYSQL. Finally we need to write some queries for data retrieval. Pls share me your requirement so we can discuss. Waiting for your response if interested. Thank you!!!

$350 AUD in 3 days

5.0

(61 reviews)

6.4

@awais26

Hello, Thanks for job posting. I read your project description . I have extensive experience in SQL server DBA and development. I am one of Microsoft certified SQL server DBA. I specialized in SQL server and Azure. Provided DBA services to many clients. Contact me and let's talk together about project details. I hope to make a magical one. Thanks

$80 AUD in 7 days

5.0

(28 reviews)

5.6

@prakash2813

⭐⭐⭐⭐⭐ 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, SQL, PLSQL, Dynamic queries, pivot tables, Stored Procedures, Functions, Database Normalization, UML, ER Diagrams, Rational Schemas, Data dictionary and more. This should be 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.

$130 AUD in 2 days

4.9

(40 reviews)

5.8

@anayapallavi

I can create a SQL database system for your project. Please initiate a message for further discussion.

$125 AUD in 3 days

5.0

(10 reviews)

5.1

@nyarOnyari

Hello, I have read your project description about Database Design. I am an expert in database systems and I have developed many database systems including but not limited to a database system for a School, County Bursary, Pos System and Sacco system. I have used tools such as SQL Developer, SQL Plus, SQLYog, MySQL Workbench, SSMS etc. Am confident I can handle your project. Kindly open a discussion with me so that we talk the best way to work. If you award me the project I will work closely with you throughout the whole project life span, communicating continuously at every stage with updates until the project comes to fruition, in perfect condition, and ready for submission. Hope to work with you soon! Thanks Nyaronyari

$150 AUD in 5 days

5.0

(40 reviews)

5.1

@jaswinder527

Hello Sir, I can do this work. We have 22 years of experience in MS SQL Server, C#, ASP.NET, MVC, Entity Framework, J SON, VB.NET, Win Forms, Desktop application, J Query, JavaScript, HTML 5, CSS, Bootstrap, modern UX/UI design, design, and development. We will build this website as per your requirements and will give you unlimited revisions to ensure the quality of the website. Please send Hi on chat so that we can discuss more. Thanks

$500 AUD in 12 days

4.6

(3 reviews)

5.1

@noureen23

Dear Client, I hope you having good day. I am Saima , holding a Master's degree in Computer Science with a specialization in database system design. I have extensive experience in Database designing and complex SQL queries . My experience makes me confident to assure you 100 percent accurate solution according to your requirement. ======My clients reviews are proof of my commitment and support ===== Looking forward to discuss details. Thanks for your time. Regards Saima

$60 AUD in 5 days

5.0

(28 reviews)

4.9

@Anilsingh1992

"START NOW" i have good experience in database design and normalization for more details please send a message i will show my some recent project thank you.

$140 AUD in 7 days

5.0

(6 reviews)

4.4

@bizmanas

I understand that you are looking for a designer who can create a SQL database system for your project and I believe I am the best fit for this job. With 15 years of experience in database development and web development, I am confident that I have the skills necessary to complete this project. My expertise includes strong knowledge and experience in SQL database design and development, proficiency in data modeling and database normalization, familiarity with best practices and industry standards for database design, ability to understand and work with complex data structures and relationships as well as experience in optimizing database performance and ensuring data integrity. Additionally, I have exposure to SQL Server 2012, 2014, 2016 and 2019 which would be beneficial for you in terms of front-end interface requirements. I would be delighted if you could please let me discuss this project further please. Thank you for considering me for this position!

$500 AUD in 7 days

4.9

(12 reviews)

4.5

@Dhawan8787

I understand that you are looking for a database designer who can create a SQL database system for your project and my experience in database design and development, strong knowledge and proficiency in data modeling and normalization, familiarity with best practices and industry standards for database design.

$140 AUD in 7 days

5.0

(4 reviews)

3.9

@professional800

Greetings Thanks for checking my proposal. I am full- time freelancer having job experience of more than two decades. It included more than a decade as a Manager in Public Listed Companies. Having In-depth knowledge of MS Access. I recently won four contests of MS Access at here. I have developed many software including accounting software, pilot log book, Machine Rental Business, Inventory System etc. It is my practice to do one project at a time therefore I would assist you full time according to your available time. You can check my scores and reviews. I would assist you until you would satisfy with your project Hoping for a positive reply from your side for a long-lasting working relationship. Regards

$85 AUD in 2 days

5.0

(8 reviews)

4.1

@akritisood94

Hi there! My name is Akriti and I'm a database designer with extensive experience in database design and development, data modeling and database normalization, best practices and industry standards for database design, as well as optimization of performance and ensuring data integrity. I have the necessary skills to help you design a SQL database system for your project. Specifically, I am experienced in SQL database design and development, data modeling and database normalization, optimizing performance and ensuring data integrity. Additionally, I have experience in front-end development which would be beneficial for this project as the client is not sure if they require a front-end interface for their database. I understand that you're looking for someone who can create a SQL database system for your project efficiently and effectively. With my expertise in SQL database design and development, data modeling and database normalization, optimization of performance and ensuring data integrity I believe I am the perfect fit for this assignment. Please feel free to reach out if you have any questions or would like me to further discuss the project further. Thank you!

$200 AUD in 1 day

5.0

(11 reviews)

4.1

@solutionmind

Hello Muhammad U., I hope this message finds you well. I have thoroughly reviewed your project description and I am confident that I have the skills and experience required to design and develop a SQL database system that meets your needs efficiently and effectively. As an expert in SQL, MySQL, Database Administration, and Database Programming with over 8 years of experience, I have a strong knowledge and understanding of SQL database design and development, data modeling, and database normalization. I am familiar with best practices and industry standards for database design and have the ability to work with complex data structures and relationships. In addition to my technical expertise, I am committed to professionalism and ensuring top-notch results. I have successfully completed projects for clients such as Urban Stay and Alison. My portfolio showcases my expertise and achievements. Regarding your project, please note that I also have experience in front-end development, which would be beneficial if a front-end interface is required for your database. This would enable me to provide you with options and recommendations based on your specific needs and preferences. I am confident that I can deliver high-quality work for your project. I am ready to investigate and understand the publicly available dataset, design a conceptual model for storing the dataset in a relational database, build the database according to the design, and develop SQL queries in response to the set of requirements outlined in the project description. Thank you for considering my proposal. I look forward to discussing further details and working with you on this project. Best regards, Muhammad

$210 AUD in 7 days

5.0

(3 reviews)

3.7

@esa59cfdec1d6569

Hi there, I checked your requirements and guarantee you it's gonna be done within the next few hours. Let's contact via chat so that I can start work immediately. Wish you the best.

$55 AUD in 1 day