Find Jobs
Hire Freelancers

Logical and Physical Database modelling

$30-250 AUD

Zavřený
Zveřejněno přibližně před rokem

$30-250 AUD

Zaplaceno při doručení
Hi, I have attached am image of the fastCabs erd model. Please see it to understand this case: A private taxi company called FastCabs was established in Hobart in 1992. Since then, the company has grown steadily and now has offices in most of the main cities of Australia. However, the company is now so large that more and more administrative staff are being employed to cope with the ever-increasing amount of paperwork. Furthermore, the communication and sharing of information within the company is poor. The Director of the company, Liam Andrew feels that too many mistakes are being made and that the success of his company will be short-lived if he does not do something to remedy the situation. He knows that a database could help in part to solve the problem and has approached you and your team to help in creating a database application to support the running of FastCabs. The Director has provided the following brief description of how FastCabs operates. Each office has a Manager; several taxi owners, drivers and administrative staff. The Manager is responsible for the day-to-day running of the office. An owner provides one or more taxis to FastCabs and each taxi is allocated for use to a number of drivers. The majority of owners are also drivers. FastCab taxis are not available for hire by the public hailing a taxi in the street but must be requested by first phoning the company to attend a given address. There are two kinds of clients, namely private and business. The business provided by private clients is on an ad hoc basis. The details of private clients are collected on the first booking of a taxi. However, the business provided by business clients is more formal and involves agreeing a contract of work with the business. A contract stipulates the number of jobs that FastCabs will undertake for a fixed fee. When a job comes into FastCabs the name, phone number and contract number (when appropriate) of the client is taken and then the pick-up date/time and pick-up/drop-off addresses are noted. Each job is allocated a unique jobID. The nearest driver to the pick-up address is called by radio and is informed of the details of the job. When a job is completed the driver should note the mileage used and the charge made (for private clients only). If a job is not complete, the reason for the failed job should be noted. 1. Given the sample ER Model for the FastCabs case study (on page 4), draw the corresponding GRD, exhibiting all the primary keys and foreign keys. For simplicity, no other attributes nor multiplicity constraints are required. Please note, for the ER diagram you created in Assignment 1, the artefact of the conceptual database design, map the ER model into the relational model according to how it was designed in the ER diagram. An updated ERD is required as part of this question. 2. Create the database tables in SQL for all the relations in your GRD and enforce all the relevant constraints including primary and foreign keys. Provide screenshots of the SQL statements and executions.
IČ projektu: 35980929

O projektu

20 nabídky
Vzdálený projekt
Aktivní před rokem

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
20 freelanceři nabízejí v průměru $213 AUD za tuto práci
Avatar uživatele
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am available almost 24-7 and am very responsive. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 Kindly contact me via chat for further details and discussion. Thank you Sandeep
$180 AUD v 3 dnech
4,9 (42 recenze)
6,4
6,4
Avatar uživatele
Hello, I am an expert in database management. I have more experience in relational database writing. I am a B.Sc. degree holder in computer science. I do give A++ quality papers to my clients. Kindly please try my services thank you.
$140 AUD v 4 dnech
4,8 (26 recenze)
5,3
5,3
Avatar uživatele
Hi I am database expert having more than 13 years of experience in sql development and worked in oracle/mysql/Db2/Sql server. Lets discuss your requirement and you can pay once you are satisfied
$400 AUD v 7 dnech
5,0 (21 recenze)
4,4
4,4
Avatar uživatele
Hi There, I have gone through your requirement and willing to help you in designing logical and physical model of Fast cab . My expertise are in database development and database programming and 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
$100 AUD v 7 dnech
5,0 (23 recenze)
4,3
4,3
Avatar uživatele
Greeting, I'm data analyst, i have elaborated several ERD and databases for systems, i've read your requirement and i assure you that i can delivre a professionnal work. Let's exchange please for more details about your requirement, i will be glad to offer you my services. Regards !
$250 AUD v 5 dnech
5,0 (1 recenze)
2,6
2,6
Avatar uživatele
Hi, dear client. I have read your requirements carefully. I have rich experience of completing similar tasks several times. Being prompt and punctual is the key point to makes me standing out and I can start work right NOW. Once you hire me, you will certainly get what you want at the highest quality. Please drop me a message so we can talk it over on a private chat. You won`t be disappointed. I promise. Best regards.
$150 AUD v 7 dnech
5,0 (1 recenze)
2,1
2,1
Avatar uživatele
Hello, I am interested in the project you are offering, and for that, let me offer you a project submission proposal to help you solve the problem you. Thank You.
$225 AUD v 7 dnech
4,9 (2 recenze)
1,7
1,7
Avatar uživatele
Hello Client ! I am a skilled full stack developer. Having rich experience in Java , Python , C , C++ , C# , Mysql , Sql , Oracle , Object Oriented Programming , Data Structure , Algorithms . I have a perfect grip on “Database Administration” , and work in “Oracle” Mysql”. I want to assure you that these are my areas of expertise and I can do any work related. Here I am also assuring you that the quality of work will not be compromised . I am able for work full time on your time zone and start work right now . Please send me a message for further Details . Thanks and Best Regards
$140 AUD v 3 dnech
5,0 (1 recenze)
0,8
0,8
Avatar uživatele
⭐Hello, Vandana⭐ Hope you are doing well! I have been involving web application development and I have rich experience in database design and development. I can improve your database using Indexes, Triggers and Procedure. Can we discuss more over the chat? Best regards.
$1 000 AUD v 20 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
As a skilled and experienced data engineer, I am confident that I have the technical abilities and experience to complete the tasks you have outlined. I have extensive experience in translating ER Models into relational databases and creating corresponding SQL tables. I am well-versed in enforcing constraints, including primary and foreign keys, to ensure the integrity of the data.I would love the opportunity to bring my skills and experience to your project Thank you for considering my proposal. Mounir
$100 AUD v 4 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hello I read your project description. You are searching for a database developer with knowledge of SQL for your FastCabs website. It manages your website document. Please start a conversation so that we may continue to discuss the idea. and immediately begin work. Thanks, Shailesh. 
$220 AUD v 10 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
1. i have developed applications for cab rental and Uber-like companies 2. I use PowerDesigner for the scheme construction 3. The conceptual model can be impacted on any physical model (any database).
$270 AUD v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Understand and knows the process of designing database and business aspect. Know data modelling tools like ERWIN and SQL developer. Knows how basic Data table modelling are done, Running SQL and the data density are the driving factors for designing database tables. Additional services can be provided on product licensing, Data purging, backup and recovery techniques etc.
$140 AUD v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hi Hope you are doing well. I have done these types of projects before. I can perform all the tasks required for the project. lets talk about it over the chat. I can also send some samples of my previous work related to creating database, keys, grd, with all the screenshots. Thanks
$70 AUD v 7 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
I will finished your task within 4 days. I have good knowledge of DBMS. And I have designed database for more than 100 website.
$100 AUD v 4 dnech
0,0 (0 recenze)
0,0
0,0
Avatar uživatele
Hello I can do this. Please share the details of the task so that I can check and confirm accordingly.
$140 AUD v 7 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z AUSTRALIA
Griffith, Australia
4,6
3
Ověřená platební metoda
Členem od říj 12, 2022

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.