$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,167 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

Party Hire Case Study

Party Kids is a company that rents out inflatables, tables, and chairs for children’s parties.

It is owned Ms Donta Pop and she has been very happy to see her business grow rapidly over the past 2 years. She has recently purchased dozens of new tables, a number of new types of inflatables and dozens of chairs.

To store it all, Ms Pop has rented out 2 new storage facilities, so that she now has one location on the east side of town, one central, and one in the west.

Ms Pop has been finding it impossible to keep track of customer details, bookings, and the storage location of her assets. She has been trying to manage with a paper system but has been making mistakes like hiring out an item twice for the same day. So, she has now hired you to shift her records into database.

You have interviewed Ms Pop and you believe you have enough information to begin planning the database. This is what you know:

  • Ms Pop owns over 500 asset items. She is carrying:
  • 3 inflatable models. She owns 20 inflatables in all.
  • 3 chair models. She owns 100’s of chairs.
  • 1 table model – a plastic folding table that seats 10 people. She has no plans to purchase a different model of table.
  • Assets within a model category are all the same price. For example, for cushioned seats the price is $10 per day, and for small plastic chairs it’s $2 per day.

Task 1

  1. Create an MS Word document named “Your Given Name– Your Student Number – Party Kids.docx" e.g. Harpreet – 123456 – Party Kids.docx.
  2. Create an ER Diagramfrom the above scenario, being sure to:
  1. Use Crow’s Foot Notation
  2. Mark cardinality, existence, primary keys (with an underline), and foreign keys (with the letters “FK” in brackets).
  3. Ensure the entities are in a normalised state
  4. 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. Place your nameand student number within the drawing
  6. Insert that ER Diagram into your Word document. If you use Lucidchart or similar you could take a screenshot.

Task 2

Create your solutions for following tasks in Microsoft SQL Server and:

  • Write a T-SQL comment above each SQL statement you write, stating your name, the task you are solving, and the purpose of the code. For example, “ Q1.Creating a database” and “Harpreet Q1: Creating a table”, above the statements required for question 1.
  • Paste all the SQL code that you write into your MS Word document. That is, paste it as plain text
  • Paste screenshots from Microsoft SQL Server into your MS Word document. The screenshots should show your codealong with the relevant messages window and/or outputs window

Task 2a

  1. Write two CREATE statements. One to

build a database named “PartyKids” and one to build within it a table named

“Customer” which will store details about PartyKids customers. The columns should match the attributes listed in your ER Diagram. All columns should be required columns (that is, don’t allow NULL values).

  1. Use a single INSERT statement to create the details of 7 customers. Name one of the customers “John P Smith” and record his address as 12/1 Flinders St, Melbourne 3000. [Note: If you didn’t include address details in the Customer entity in your ER Diagram, do so now and then redo task 2a.1]
  1. Use a SELECT statement to display full details of all customers
  1. Change the address of John Smith to 15/1 Flinders Street and then display the name and address onlyof all customers
  1. Display the details of all customers whose first name that starts with the letter “J”
  1. Display the details of all customers who live in Victoria. Note that all Victorian postcodes are in the 3000’s and no other states use the 3000’s.
  1. Delete John P Smith from the database
  1. Add a 2nd table to your database.
  • 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.
  • 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.
  • 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.
  1. Display all bookings grouped by customer. Display full booking details, but don’t show any customer details.
  1. 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.
  1. Display the names of customers who have not yet made a booking.

Task 2b

  1. Create all the tables you have drawn up in your ER Diagram and build the relationships between 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.
  1. 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.
  1. Display the names of all customers who have rented inflatables
  1. Display the names of all customers who have rented chairs orinflatables
  1. Display a count of the number of booking days of each customer
  1. Display the total amount of money received from each customer. That is, display one one value per customer.

Task 3

  1. Ms Pop is curious to know why a computer expert like you would draw a diagram before using database software. Write 200 to 250 words explaining the purpose of creating your ER Diagram before building the database
  1. Ms Pop is thinking about accepting credit card payments from customers and keeping a record of the payments in her database. She is concerned about storing personal details such as credit card numbers and customer addresses. Write 150 to 200 words naming the main legal issue at play and the techniques you could use to help secure her database.

Cite This Work

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

My Assignment Help. (2020). Database Fundamentals. Retrieved from https://myassignmenthelp.com/free-samples/itda1001-database-fundamentals/case-study-of-party-hire.html.

My Assignment Help (2020) Database Fundamentals [Online]. Available from: https://myassignmenthelp.com/free-samples/itda1001-database-fundamentals/case-study-of-party-hire.html
[Accessed 05 August 2021].

My Assignment Help. 'Database Fundamentals' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/itda1001-database-fundamentals/case-study-of-party-hire.html> accessed 05 August 2021.

My Assignment Help. Database Fundamentals [Internet]. My Assignment Help. 2020 [cited 05 August 2021]. Available from: https://myassignmenthelp.com/free-samples/itda1001-database-fundamentals/case-study-of-party-hire.html.


Myassignmenthelp.Com is dedicated to raise the research aptitude of students.For that we provide, perfect research papers.We help in all areas of research paper drafting be it selecting good research paper topics, helping creating research paper cover page, research paper outline etc. Our PhD experts help students in knowing how to write a research paper from scratch, how to do a literature review, writing abstracts, title, methods and discussions along with conclusion.

Latest Database Samples

ITC516 Data Mining And Visualisation For Business Intelligence

Download : 0 | Pages : 4

Answers 1. The relevant output from XL Miner is indicated below.                                     i) The most pivotal three rules that the above output refers to are outlined below. Rule 1- If the event of purchase of brushes happens, there would be the purchase of nail polish also. The associated confidence with this rule is 100% which implies tha...

Read More arrow

ICT50515 Database Design And Development

Download : 1 | Pages : 3

Answer      ERD Diagram                             Business rules In any database, business rules are required to impose constraints on various database aspects such as field elements (Paton 2012). The rules aim at eliminating disruption or corruption of the database. Business rules define the relationships, constraints, and attributes which are used in da...

Read More arrow

ECBS5091 Ethics Of Big Data

Download : 1 | Pages : 4

Answers: Answer to Question 1: The development in technologies of Big Data has passed the limits of understanding by individual actions and their effects in the digital world. However, there are many ethical challenges faced from big data. The network of information accessed by big data forms a digital image of the information that is being accessed. This is termed as datafication in terms of technologies. This however makes it very inefficie...

Read More arrow Tags: Australia Dallas Law Patient Protection and Affordable Care Act University of Dallas 

ICT704 Non Relational Database Systems

Download : 0 | Pages : 5

Answer: Comic Crusaders are one of the largest comic books retailer having presence in United States (US) and United Kingdom (UK) who wish to have online presence in the current market. For each book they wish to store the customer’s feedback. Only those customers can provide the feedback who register their name with Comic Crusaders. MongoDB database is being used to store the details like comics, publishers and reviews & ratings.&nb...

Read More arrow

INFO6001 Database Management 1

Download : 0 | Pages : 4

Answer: Part A A brief discussion on the solution and the in modelling the problem and any issues encountered The modelling process began with indentifying the entities and their attributes. An entity was either classified as regular or weak entity. An attribute on the other hand was either grouped as key attribute, simple attribute, composite attribute, single valued attributes, multi-valued attributes, stored attribute or a derived at...

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

5% Cashback

On APP - grab it while it lasts!

Download app now

*Offer eligible for first 3 orders ordered through app!

callback request mobile
Have any Query?