$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

ITDA1001 Database Fundamentals

tag 0 Download5 Pages / 1,235 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

Create an ER Diagram from the above scenario, being sure to:

  1. a) Use Crow’s Foot Notation
  2. b) Mark cardinality, existence, primary keys (with an underline), and foreign keys (with the letters “FK” in brackets).
  3. c) Ensure the entities are in a normalised state
  4. d) Write any assumptions you make if you think it important to clarify the reasons for  building particular relationships, creating particular attributes, or leaving something out.
  5. e) Place your name and student number within the drawing
  6. f) Insert that ER Diagram into your Word document. If you use Lucidchart or similar you could take a screenshot.

Add a 2nd table to your database.

o It should store details about bookings made by a customer so name it “Booking” or something similar. If your ER diagram doesn’t show a customer entity linked to table that lists bookings (party hires) made by customers, then add one now. Ensure your Booking table contains, at the minimum, attributes to store the date of the booking and any customer feedback.

o Build a relationship between the Booking table and the Customer table and make it impossible to create a new Booking that doesn’t belong to an existing Customer.

o Insert the details of at least 6 bookings. Enter details into every column of each record. The bookings should all belong to just 3 customers – 1 for one customer, 2 for another, and 3 for the 3rd

  1. Use a DELETE statement to try to delete a customer who has a booking. It should not be possible.
  2. Display all bookings grouped by customer. Display full booking details, but don’t show any customer details.
  3. Display the customer names and booking dates of all customers who have made a booking and sort them from the most recent booking to the least recent.
  4. Display the names of customers who have not yet made a booking.
  5. Create all the tables you have drawn up in your ER Diagram and build the relationshipsbetween them. Choose your data types carefully. Note that you will need to buid the tables on the “one” side before the tables on the “many” side.
  6. Add at least 3 records to every table and then display them all. Note that you will need to insert records into the tables on the “one” side before inserting into tables on the “many” side.
  7. Display the names of all customers who have rented inflatables
  8. Display the names of all customers who have rented chairs or inflatables
  9. Display a count of the number of booking days of each customer
  10. Display the total amount of money received from each customer. That is, display one one value per customer.

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help (2020) Database Fundamentals [Online]. Available from: https://myassignmenthelp.com/free-samples/itda1001-database-fundamentals/dana-bullaboy-and-thomas-whitelock.html
[Accessed 01 August 2021].

My Assignment Help. 'Database Fundamentals' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/itda1001-database-fundamentals/dana-bullaboy-and-thomas-whitelock.html> accessed 01 August 2021.

My Assignment Help. Database Fundamentals [Internet]. My Assignment Help. 2020 [cited 01 August 2021]. Available from: https://myassignmenthelp.com/free-samples/itda1001-database-fundamentals/dana-bullaboy-and-thomas-whitelock.html.


Looking for MLA citation generator tool? Visit MyAssignmenthelp.com today to get free access to citation machine at amazing discounts. Our free citation machine will make your citation super easy. Relax and stop worrying about properly citing your sources. Enjoy the features of our top-notch citation machine and deliver an A+ assignment. Also get free essay generator tools apart from citation generator APA to citation generator MLA. If you want a flawless result, ask our experts to do citation for you. Our professionals can manually check your paper and bring out the best version, so that you score a top grade.

Latest Management Samples

MORG4038 Management And Organisations

Download : 1 | Pages : 8

Answers Introduction This report will evaluate the management strategy adopt by PureGym Corporation. The first sections of the report will briefly describe the company’s unique attributes and other features. The second part will focus on analysing the organisational structure of PureGym Company. The third part will suggest a managerial approach which can be adopted by PureGym’s management. The fourth sections will evaluate two inn...

Read More arrow

FIN200 Financial Accounting

Download : 0 | Pages : 10

Answers: 1. It is important to consider the fact that several factors are viewed by the tertiary sector staff members while deciding over the situation on placing the individual superannuation contribution that have certain benefit plan in along with the investment choice plan (Pratt 2013). On analysis, it has been found several issues that gets associated with the time value of money concept as it help in decision-making process in the most a...

Read More arrow

HLTH 1306 Health Practitioner Practice

Download : 1 | Pages : 4

Answers: 1. The following write up is my reflection on lectures, tutorials, policy, and readings about obesity, physical activity, and nutrition. This will involve identification and justifications of my ideas, beliefs, and values on obese population as they have been confirmed and others changed or challenged from the study. The write up will also contain my application of the information gained to my professional practice. Obesity has risen t...

Read More arrow Tags: Australia Mawson Lakes Management University of New South Wales 

COMP8440 Free And Open Source Software Development

Download : 0 | Pages : 2

Answer: The advancement in the technology has brought about changes in the structure of the software engineering. On the other hand, the development of the software, based on their specifications of open and closed source has made significant improvements in their structure. It has helped in the better understanding of the evolution and the modifications made. However, the reliability and the appropriateness of the modifications are determined...

Read More arrow

400210 Health Promotionn And The Nurse

Download : 0 | Pages : 14

Answer: Introduction Health promotion program is series of actions to encourage good health and wellbeing. Spreading consciousness about good health and wellbeing is a part of such promotional actions that includes enlightening people with the ways to stay fit and healthy. Promotion of practices and values that influences a community about good health is also a part of health promotional program (Eldredge et al., 2016). According to the Worl...

Read More arrow
Next

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Mechanical Engineering

Assignment: 8 Pages, Deadline: 8 days

Passed my subject because of you. Thank you........................................................................

flag User ID: 2***76 Sydney, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

Healthcare

Essay: 1 Page, Deadline: 17 days

Instructors comments on marking :



The depression rate has been increased by 31% among teenagers in America as a consequence of the excessive us ...

flag User ID: 6***41 Campbell River, Canada

student rating student rating student rating student rating student rating
19 Jul 2021

English

Assignment: 0 Pages, Deadline: 4 days

Grate job on my assignment. I got a 100 on it. thank you. I have two questions? 1)Whats The distance from Clarksville,TN to Dayton, Ohio? What's the ...

flag User ID: 7***74 United States

student rating student rating student rating student rating student rating
19 Jul 2021

Assignment

Essay: 5 Pages, Deadline: 6 days

Great job by an incredible organization that truly goes above and beyond to assist in any matter. I truly thank you again for your help.

flag User ID: 5***89 Hillsborough, United States

student rating student rating student rating student rating student rating
19 Jul 2021

Networking

Programming: 4 Pages, Deadline: 30 days

Very Good Team and they attend to you whenever u need them and make all the changes required as soon as possible.

flag User ID: 6***7 Brisbane, Australia

student rating student rating student rating student rating student rating
19 Jul 2021

It Write Up

Assignment: 4 Pages, Deadline: 16 days

This was short assignment but i was satisfied with the work. I got good grades and passed the assignment. The assignment was overall good. I ordered i ...

flag User ID: 6***34 Canada

student rating student rating student rating student rating student rating
18 Jul 2021

Healthcare

Essay: 4 Pages, Deadline: 6 days

the revised version of the assignment was ok, based on the feedback for all the parts.

flag User ID: 5***77 Australia

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Home Work: 4 Pages, Deadline: 4 days

My assignment always done on time sometime before the given time. MY ASSIGNMENT team is very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

Nursing

Assignment: 4.8 Pages, Deadline: 5 days

My Assignment was done very good. Good work and it was delivered on time. Very responsive.

flag User ID: 4***34 United States

student rating student rating student rating student rating student rating
18 Jul 2021

HRM

Thesis: 6 Pages, Deadline: 9 days

YOU WORKED HARD ON THIS ASSIGNMENT AND DID EXACTLY WHAT WAS ASKED. THANKS, AND I CAN'T WAIT FOR YOU TO DO WELL ON THE NEXT WORK.

flag User ID: 4***64 United States

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?