Find Jobs
Hire Freelancers

create erd diagrams for the following task

$8-15 AUD / hour

已关闭
已发布大约 6 年前

$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.
项目 ID: 16551419

关于此项目

17提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
17威客以平均价$17 AUD/小时来参与此工作竞价
用户头像
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 在40天之内
4.8 (29条评论)
6.2
6.2
用户头像
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 在40天之内
5.0 (97条评论)
5.6
5.6
用户头像
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 在40天之内
5.0 (18条评论)
5.2
5.2
用户头像
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 在40天之内
4.8 (24条评论)
5.1
5.1
用户头像
A proposal has not yet been provided
$33 AUD 在1天之内
4.6 (59条评论)
5.4
5.4
用户头像
Have created ERD already for other customers. Glad and willing to do it for you. Thank you, Regards,
$15 AUD 在10天之内
5.0 (11条评论)
4.6
4.6
用户头像
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 在5天之内
5.0 (3条评论)
3.5
3.5
用户头像
A proposal has not yet been provided
$13 AUD 在15天之内
5.0 (5条评论)
3.4
3.4
用户头像
A proposal has not yet been provided
$33 AUD 在10天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在12天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在35天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在40天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在40天之内
0.0 (0条评论)
1.4
1.4

关于客户

AUSTRALIA的国旗
Australia
0.0
0
会员自3月 24, 2018起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。