E/R and UML Diagram

Completed Posted 2 years ago Paid on delivery
Completed Paid on delivery

Cruise Ship management database system

The following data model is designed to hold customer ordering information relating to a restaurant chain. For this scenario we need to define the following facts:

These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation. Assuming that the restaurant chain has restaurants in many locations throughout the United States and each restaurant has employees and food items to offer:

 Restaurants – A restaurant may have location information, phone number, etc.

 Employees - An Employee may have information such as address, phone, DOB, etc.

 Menu items – name, price. e.g. Hamburger, $3.50

 Customers – Name, address (for delivery purpose), payment method. etc.

A customer may visit multiple restaurants in the chain.

The Entities are related as follows:

 Customers may order menu items from various restaurant locations.

 Restaurants can have various kinds of menu items.

 A customer may write feedback to a restaurant

When asking questions of the database we may need to know:

1. Which customer ordered which items in which location?

a) Create an E/R diagram capturing the objects and relationships described

above. Describe all your design choices and constraints.

THEN

b) Create an UML diagram capturing the objects and relationships described

above. Describe all your design choices and constraints.

SQL Coding UML Design Database Development Oracle Database

Project ID: #30709567

About the project

11 proposals Remote project Active 2 years ago

Awarded to:

(65 Reviews)
5.7

11 freelancers are bidding on average $50 for this job

AShegavker

Hi, I have gone through the requirement & understood what exactly you're looking for. I am available now to discuss further - lets connect! Looking forward to opportunity. Thanks!

$50 USD in 3 days
(14 Reviews)
4.5
Vickybobo

Hello! I hope you are doing well. I am an experienced database adminstrator using SQL for a long time. I have read your project description and I am very interested in your project. I can help you to complete the tas More

$50 USD in 1 day
(15 Reviews)
3.8
bmoatar1

Hi, how are you doing now? I have full skill in E/R data modeling and PL/SQL Oracle. I can make E/R model and Relational Entity and implement with in Oracle database. Hope to contact you. Best regards!

$30 USD in 3 days
(5 Reviews)
2.0
denpopov

Hi, As I am a Software Manager, I am very interested in your project. I can do it and I can start work right away. I have good experience in creating E/R and UML diagram. I am looking forward to working with you. Rega More

$30 USD in 2 days
(0 Reviews)
0.0
VindyaPerera

Hi, I can handover well presiced UML Diagram design with ER Diagram as i have experience of more than 4 years in similar capacity. I hope to have much better understand of your business structure by contacting you time More

$25 USD in 8 days
(0 Reviews)
0.0
looopNetwork

I already read your project. However, I've already have experience in UML, ERD and EERD. Also, I'm ready to do it I can finish it in one day.

$20 USD in 1 day
(0 Reviews)
0.0
KenJanka

Hello good day, I have a lot of experience in software development. I can do this database design for you. If you award me the project, I can start working on it right away.

$125 USD in 7 days
(0 Reviews)
0.0