Securing Higher Grades Costing Your Pocket? FLAT 25% OFF on all orders
loader

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

Phone no. Missing!

Enter phone no. to receive critical updates and urgent messages !

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

0 Page
Table Design And Dependency

...

Course

ICT285

Subject

Database

University

Murdoch University

Season

Spring

0 Page
The SQL Statements

...

Course

ICT285

Subject

Database

University

Murdoch University

Season

Spring

45 Pages
6672 Database Design

Questions Part 1. General questions. (15 marks) 1. Please compare the file-based systems and database management systems [7 marks]   2. A. Please descible the meaning of super key, candidat ...

Course

6672

Type

Programming

Subject

Database

University

University Of Canberra

Season

Spring

60 Pages
General Data Management Operations

Page 1 of 11 MIS609 Data Management and Analytics Name: University: Page 2 of 11 Table of Contents Introduction: ................................ ........................... ...

Course

MIS609

Subject

Database

University

Torrens University

Season

Fall

MAN6905-Databases and Business Intelligence

Question

Answered

Assignment

“Flowers-4-Friends” is a new venture started by a group of young students, who want to setup an online flower ordering system. The website will enable customers to specify various combinations of flowers that will be delivered to a specified location and person, with an appropriate message. 

The system needs to be able to store and validate customer details (provided online). Things such as the name, date of birth, phone number, and the delivery address must be entered. A valid email address must also be provided and stored, this will be used to provide a receipt of the order made and feedback on its delivery status.  

The website will allow an order to be taken for bunches of flowers 24 hours of the day, 7 days a week. The order will include the preferred time of delivery, date, quantity and type of flowers to be delivered. A detailed description of the type or types of flowers that make up the bunch will be provided. 

Flowers can include Roses, Tulips, Azealias, carnations and many others. The availability of the flowers depends on the season. Information on whether a type of flower is available or not will be kept up to date by the operators, based on information from their suppliers. 

The flower warehouse is used to prepare the bunches of flowers for delivery. All delivery staff come to the flower warehouse to pickup their deliveries for the morning or afternoon shifts and make their deliveries as per orders. The organisers will group orders in similar areas together to minimise travel for delivery staff. Each of the delivery staff use a vehicle provided by the business which enables up to 30 bunches of flowers to be transported at any one time. 

The order usually includes a message, which is usually placed with the bunch of flowers. Special instructions for the delivery staff are also provided, especially if the delivery requires special directions or specific person to be contacted and given flowers.

The young university students have asked you to come up with a data model that will enable them to store the data required for the business.

Provide the following for the new database that is in third normal form and free of anomalies:

1.Entity Relationship Diagram.

2.Relational Model (showing fields, primary keys, foreign keys and composite keys).

3.What assumptions have you made?  

MAN6905-Databases and Business Intelligence

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

11 More Pages to Come in This Document. Get access to the complete answer.

More MAN6905 MAN6905-Databases and Business Intelligence: Questions & Answers

Q
icon

We aren't endorsed by this University

Table Design And Dependency

...

View Answer
Q
icon

We aren't endorsed by this University

The SQL Statements

...

View Answer
Q
icon

We aren't endorsed by this University

6672 Database Design

Questions Part 1. General questions. (15 marks) 1. Please compare the file-based systems and database management systems [7 marks]   2. A. Please descible the meaning of super key, candidate key and primary key. (3 marks) B. Provide a candidate key for Recharge Plan table, primary key an ...

View Answer
Q
icon

We aren't endorsed by this University

General Data Management Operations

Page 1 of 11 MIS609 Data Management and Analytics Name: University: Page 2 of 11 Table of Contents Introduction: ................................ ................................ ................................ ................................ .... 3 Kind of data that ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.io then please raise the content removal request.

Choose Our Best Expert to Help You

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile Chat Now
Have any Query?
close
Subtraction Payment required!

Only one step away from your solution of order no.