Find Jobs
Hire Freelancers

Modelling Assignment Create ERD of Case Study.

$10-30 AUD

Zamknięte
Opublikowano prawie 6 lat temu

$10-30 AUD

Płatne przy odbiorze
Task 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. Use [login to view URL] to create your ERD Requirements Either save your ERD diagram as a PDF or embed it in a Word document. Don't use any other file formats Don't submit your file in XML
Identyfikator projektu: 16598675

Informację o projekcie

10 ofert
Zdalny projekt
Aktywny 6 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
10 freelancerzy składają oferty o średniej wysokości $48 AUD dla tej pracy
Awatar Użytkownika
As per the project description give it requires to have a good understanding about creation of ER Diagram for the given case study. I have very good knowledge in field of ER & Dimension Data modeling and completed multiple projects related to same. I always work to provide Best Delivery with 100 % customer satisfaction. Would be looking forward to work on this opportunity and will ensure to deliver best.
$35 AUD w 1 dzień
4,9 (33 opinii)
5,0
5,0
Awatar Użytkownika
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.
$88 AUD w 1 dzień
4,7 (5 opinii)
3,7
3,7
Awatar Użytkownika
A proposal has not yet been provided
$45 AUD w 3 dni
5,0 (2 opinii)
1,5
1,5
Awatar Użytkownika
Im recently out of school and im familiar with these kind of assignments. I have been working in business intelligence as a programmer for a year , and this seems like a very straightforward project. Relevant Skills and Experience BI programmer
$66 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
Hi there! I am a database specialist. I can complete this tak. I am a CSE student of the best engineering university of our country. I think u can keep faith in me
$27 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
A proposal has not yet been provided
$55 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
A proposal has not yet been provided
$35 AUD w 2 dni
0,0 (0 opinii)
0,0
0,0
Awatar Użytkownika
i have created this assignment for someone else i have the copy of that if you need award me with this project.
$30 AUD w 1 dzień
0,0 (0 opinii)
0,0
0,0

O kliencie

Flaga AUSTRALIA
Australia
0,0
0
Członek od mar 31, 2018

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.