whatsapp

Connect on Whatsapp : +97143393999, Uninterrupted Access, 24x7 Availability, 100% Confidential. Connect Now

Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
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.

loader
250 words

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Students Who Viewed This Also Studied

14 Pages
ITNET301A Mobile Computing and Security

Assignment In this assessment students are required to develop a mobility policy for a nominated organisation that is enforceable, manageable, user friendly, and secure. Students must identify the un ...

Course

ITNET301A

Type

Programming

Subject

It Write Up

University

Tafe NSW

120 Pages
Software Architecture

CN702 1 - ADVANCED SOFTWARE ENGINEERING 1 Introduction Prior to software implementation or coding is system design where software architecture is provided. System architecture is import ...

Course

CN7021

Subject

It Write Up

University

University of East London

Season

Spring

109 Pages
Software Development Life Cycle

CN702 1 - ADVANCED SOFTWARE ENGINEERING 1 Introduction Software development process involves activities which when effectively executed will help produce a good software product. Generall ...

Course

CN7021

Subject

It Write Up

University

University of East London

Season

Spring

51 Pages
ITC596 IT Risk Management

Tasks: Assignment Two is comprised of two parts and your report should be no more than 5 pages excluding the cover page, table of contents and references. Part One  Plan, Develop and Manage ...

Course

ITC596

Type

Essay

Subject

It Write Up

University

Charles Sturt University

Season

Spring

DBFN212 Database Fundamentals

Question

Answered

Assignment

A tours operator company wants to get its database developed. They have provided the following requirements. The system needs to keep track of people. For each person, it records his/her address. Each address consists of country, province/state, city, street, street number, zip code/post code, and a list (possible empty) of phone numbers and a list of email address. Each person in the database can be an old customer (have taken a tour of the company), a current customer (is booked to take a tour or is on a tour right now), a tour guide, an employee (works for the tour company), or any mixture of these (for instance an employee can take a tour and so can be a customer as well). The sex and age of each person must also be recorded. The system also keeps track of all tours, past and future. Each tour has a unique number, itinerary, guide (at least one, but may be more than one), its status (completed, in-progress, in-the-future), and the list of participants. The amount paid by each person for the tour is also recorded. Each person is provided with an itinerary that consists of list of the dates the tour covers and for each date it includes the place of breakfast, the place of lunch, the place of dinner, and the accommodation and room. The type of room whether shared or private should also be mentioned on the itinerary. Each day in the itinerary also includes a simple English description of the activities during that day.

Tasks to be completed:

a. Create a complete ERD with entities and relationships using given scenario.
b. Convert the ERD to a set of relational tables in at least 3NF and draw a dependency diagram
c. Create a database using MySQL- with primary keys, foreign keys, and other attributes mentioned for each entity using proper constraints.
d. Input some significant data in each table showing your understanding of the scenario.
e. Create FOUR queries. (One SELECT, one Numeric function and two JOIN)

DBFN212 Database Fundamentals

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.

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

MyAssignmenthelp.com is the best assignment help provider serving thousands of students in New York City, Boston, Washington D.C. and Chicago. With a team of qualified and experienced online assignment experts, we deal with all types of assignment writing tasks. Our popular assignment help services include marketing assignment help, auditing assignment help, finance assignment help, statistics assignment help, help with law assignments. We guarantee that students, who decide to buy assignments online, get work worth their money and time.

More DBFN212 DBFN212 Database Fundamentals: Questions & Answers

Q
icon

We aren't endorsed by this University

ITNET301A Mobile Computing and Security

Assignment In this assessment students are required to develop a mobility policy for a nominated organisation that is enforceable, manageable, user friendly, and secure. Students must identify the unique policy and security challenges of their organisation and its industry, enumerate threat vectors ...

View Answer
Q
icon

We aren't endorsed by this University

Software Architecture

CN702 1 - ADVANCED SOFTWARE ENGINEERING 1 Introduction Prior to software implementation or coding is system design where software architecture is provided. System architecture is important since it describes the major components that make a system and how the elements and components ...

View Answer
Q
icon

We aren't endorsed by this University

Software Development Life Cycle

CN702 1 - ADVANCED SOFTWARE ENGINEERING 1 Introduction Software development process involves activities which when effectively executed will help produce a good software product. Generally, the basic activities involved are system analysis, design coding , testing and maintenance. Al ...

View Answer
Q
icon

We aren't endorsed by this University

ITC596 IT Risk Management

Tasks: Assignment Two is comprised of two parts and your report should be no more than 5 pages excluding the cover page, table of contents and references. Part One  Plan, Develop and Manage a Security Policy  Background:  Consider that the Commonwealth Government of Australia i ...

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.com 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
Have any Query?