Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

9. A company called FastCabs displays some details of client bookings for taxis. Assume single taxi but a taxi can be assigned to one or

image text in transcribed

9. A company called FastCabs displays some details of client bookings for taxis. Assume single taxi but a taxi can be assigned to one or more dn abs provides a taxi service to clients. The table shown in Figure that a taxi driver is assigned to a ore drivers. Job Job ID Date/Time driverID driver taxilD clientiD cientName jobPic ickupAdres Name Joe T1 C1 Anne Woo 1 Storrie Rd. Bull 10:00 Paisley 2 | 29/07/14 | D1 | Joe 2 29/07/14 D1 T1?C1 |Anne Woo !!Storrie Rd. 10:00 Paisley Bull 3 30/07/14 D2 Tom T2 C1 Anne Woo 3 High St Paisley 11:00 Wins 2106/14 D3Jim T3 C2 Mark Tin 1A Lady Lane, 5 2/08/14 D4 6 25/08/14 D2 D3 im Paisely 13:00 Jones Steven T1 3ohn Scal2 Red Rd StevenT C3 Paisley 13:00 Karen Bow |17 High St, Tom T2CA Paisely 10:00 Figure 1. Table displaying sample data for FastCabs (a) Provide examples of how insertion, deletion, and modification anomalies could on this table. (5 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Hands-On Database

Authors: Steve Conger

2nd Edition

0133024415, 978-0133024418

More Books

Students also viewed these Databases questions