Entity Relational Diagram
$2-8 AUD / hod.
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
Identifikační číslo projektu: #16538293
O projektu
23 Freelnceři na váš projekt zveřejňují nabídky v průměru $8/hod.
Hi there, I am database expert. I am willing to hep you to create ERD. Please contact me for discussion ya
Hi there I do database development 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. Thanks.
hi.. i am software engineer 3+ years experience in software industry ...working on these type of work alot ... hire me ... i will send u asap.
Hello! I'm an experienced software developer (8+ years) and I'm interested in your database project. I already have previous experience with the creation of database from scratch and modeling. Best regards
I am having more than 8 years of experience in IT industry.I have worked on .net(c#.net,vb.net,asp,asp.net,mvc) with sql server 2005/2008/2012/2014/2016 and oracle(pl/sql). I can provide you better solution by utili Další
Hello, I have been working as an IT BI DWH Professional since last ~ 7 years and have very vast experience around all its 3 layers (ETL, DWH & Reporting). Below are some key areas of my skills: • Expert in SQL Další
Hi, A SQL Server, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) expert here. I would like to have a detailed document of your requirements s Další
hi there! I am an expert in developing Entity Relationship Diagram. If you please hire me, I shall complete the task upto your best satisfaction level. Thank you!
I've worked with SQL for more than 20 years now. I've worked with almost every version of SQL Server, PostgreSQL and MySql. I have experience and expertise solving and writing complex queries and stored procedures. Další
have the good experience on Data warehouse, entity objects and sql server...................................................
Hello. I have read and understood the requirements of this work. The job is creating ad ERD for database structure to cater for A&H Boating company. I have been doing such project developing custom applications for Ban Další
I have over 16 years of data modeling for Enterprise (ERP) systems. Very excited and love to see/work with growing companies like yours. I've looked over your project - appears you have following basic objects to m Další
