Find Jobs
Hire Freelancers

create erd diagrams for the following task

$8-15 AUD / hour

Closed
Posted about 6 years ago

$8-15 AUD / hour

Overview of business case: A&H Boating is a small start-up company that sells small boats in Geelong. A&H Boating keeps its models in several showrooms across the city. At this stage customers cannot view the available models online so to order they must visit one of the showrooms. A&H Boating has been using an Excel spreadsheet to track their business activities, however, this has caused many redundancies and inefficiency. With view to their expanding business and under the new management, they decided to investigate the option of implementing a database system. Accordingly, they hired you to design a relational database to better track and record their operational data. A&B business rules and instructions for creating your ERD: 1. A&H Boating can get boats from several different manufacturers. Each manufacturer produces one or more different types of boats. Each and every type is produced by only one manufacturer. Every manufacturer is identified by a manufacturer code. The company name, street, city, state, postcode, phone number, and account number are kept in the system for every manufacturer. For each type, the type name (i.e. Paddle, Inflatable, Jet Ski, etc.) and purpose (i.e. fishing, day boating, etc.) are kept in the system. • Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule. 2. Every type has one or more models. Every model is produced as part of a type. For each model, the model number, engine, length, beam, suggested retail price, retail price and dry weight must be kept in the system. • Add the entities, attributes, relationships between entities, cardinality and optionality of each relationship that are described by this business rule to the ERD that you created for business rule 1. 3. Each type’s models are stored in a specific warehouse. Each warehouse stores the models of only one type. Each warehouse is identified by a warehouse ID. For each warehouse address, postcode, phone number are kept in the system. • Add the entities, attributes, relationships between entities, cardinality and optionality of each relationship that are described by this business rule to the ERD that you created for business rule 1 and business rule 2. 4. Each warehouse can be visited by prospective customers with prior booking. Customers can book a visit to a specific warehouse by calling A&H Boating hotline. Customers need to provide full name, date of birth, address, email address and contact number during booking a visit to a warehouse. • Add the entities, attributes, relationships between entities, cardinality and optionality of each relationship that are described by this business rule to the ERD that you created for business rule 1, 2 and 3.
Project ID: 16551419

About the project

17 proposals
Remote project
Active 6 yrs 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
17 freelancers are bidding on average $17 AUD/hour for this job
User Avatar
INTRODUCTION I am a database programming expert with interest in UML, Data Modelling and Database Design. I possess the drive to solving problems in object oriented data architecture. I am a Computer Science Graduate and currently a database application consultant. I can help you with your ERD Modelling Task. WHY CHOOSE ME? You only pay 30% milestone upon 50% job completion. I have 100% project completion history. SKILLS • SQL programming • A talented Database programmer • Business Intelligence Developer • Database Design • UML • HTML, CSS and Web Hosting
$12 AUD in 40 days
4.8 (29 reviews)
6.2
6.2
User Avatar
Hi there, I went through the requirements and I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details.
$12 AUD in 40 days
5.0 (97 reviews)
5.6
5.6
User Avatar
ONE OF THE TOP SQL FREELANCERS AROUND... PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS and ensure yourself that I can do this very well and very quick... My SQL Level 3 badge really makes me one of the TOP... My latest project was about ERD
$16 AUD in 40 days
5.0 (18 reviews)
5.2
5.2
User Avatar
I'm a Bsc degree holder in computer science. I have worked on many papers in report writing, research.I have read and understood your requirement and I know you will never regret, thank you.
$12 AUD in 40 days
4.8 (24 reviews)
5.1
5.1
User Avatar
A proposal has not yet been provided
$33 AUD in 1 day
4.6 (59 reviews)
5.4
5.4
User Avatar
Have created ERD already for other customers. Glad and willing to do it for you. Thank you, Regards,
$15 AUD in 10 days
5.0 (11 reviews)
4.6
4.6
User Avatar
Having a 5 year professional experience I believe I can perform you job in quick time. Also the ERD will be fully relational. Lets chat to discuss in detail.
$27 AUD in 5 days
5.0 (3 reviews)
3.5
3.5
User Avatar
A proposal has not yet been provided
$13 AUD in 15 days
5.0 (5 reviews)
3.4
3.4
User Avatar
A proposal has not yet been provided
$33 AUD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Database design is core of my work. having more than 15 years of experience in data warehouse. Data analysis, data modeling using modeling tools like ERwin. Expert in creating conceptual, logical and physical data model. I can help you in lot of areas such business View creation on top of tables , performance tuning, data governance etc. Connect with me and we can definitely work together to achieve the objective of this project. Sam Sharma
$15 AUD in 12 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Thorough Knowledge of Database and Database Administration. worked with Many databases creating relationships with various entities. Conversant with various business processes. Timely delivery if the committed task.
$11 AUD in 35 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello There, Your requirement is no less than designing ERD for a few modules on a mini-ERP. I am an experienced ERP consultant and have spent around 20 years in the field and am confident that I can help you in meeting your objectives. I have observed that you are looking for master data capture only and there is no expectation towards transactional data entry. With that in mind, i am sharing my initial thoughts on key elements that we will need: 1. Warehouse 2. Location & Address 3. Items 4. Item attributes 5. Item Categories 6. Item Serial Number 7. Price List 8. Supplier 9. Supplier Location 10. Customer 11. Customer Contact details It is evident from the fact that capture of boat's serial number in the database would require some kind of inventory management system. We will need to think through how will the serial numbers enter into the system (against receipts from suppliers) and how do they get taken out (sale to customers). The inter-relationships between the above entities are also pretty intuitive but i feel that we can have conversation/ review your requirement details along with use cases to do a better job with the design. Thanks for reading through and hoping to work with you regards Amit Bansal
$15 AUD in 40 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 15 years of experience at Oracle Technologies .Strong implementation capabilities in various business sectors: Oracle E-Business Suite, ERP Systems ,Oracle Apex Government DB Management Systems , Construction Real Estate DB Systems . and also have basic knowledge in Oracle Cloud Development . Oracle OCP, OCA , DBA Certified
$16 AUD in 40 days
0.0 (0 reviews)
1.4
1.4

About the client

Flag of AUSTRALIA
Australia
0.0
0
Member since Mar 24, 2018

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.