Computers and Technology, 17.06.2020 16:57 sweetgigi4387

1. Add an index for the customer’s last name 2. Add an index on the number of days it took to ship the order. If shipdate is unavailable, use January 1, 2020 for the calculations.
3. There seems to be some confusion in data entry about book titles due to similar titles. For example, Golden Son by Pierce Brown vs. The Golden Son by Shilpi Somaya Gowda. Add a unique constraint for the book title. Can you add a unique constraint to a column containing duplicate data? If you run into problems, please provide queries that allow you to fix the inconsistencies. If you need to update or delete any data in BOOKS feel free to do so! You may need to change one of the book titles (hint: the one by Shilpi Somaya Gowda), use UPDATE. One of the "Database Implementation" records seem to have no link to an author, use DELETE.
Do you think it may be a good idea to replace FK constraint in ORDERI ITEMS to FK with ON DELETE CASCADE option?
4. Make sure that all book records have a title, publisher, cost, and retail, and that all publishers have contact and phone.
5. Add a constraint so that all retail prices have to be between $2 and $200.

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 23:00

Suppose s, t, and w are strings that have already been created inside main. write a statement or statements, to be added to main, that will determine if the lengths of the three strings are in order by length, smallest to largest. that is, your code should determine if s is strictly shorter than t, and if t is strictly shorter than w. if these conditions hold your code should print (the boolean value) true. if not, your code should print false. (strictly means: no ties) example: if s, t, and w are "cat", "hats", and "skies" your code should print true - their lengths are 3-4-5; but if s, t, and w are "cats" "shirt", and "trust", then print false - their lengths are 4-5-5 enter your code in the box below

Answers: 2

Answer

Computers and Technology, 23.06.2019 02:30

Three out of five seniors remain undecided about a college major at the end of their senior year.

Answers: 3

Answer

Computers and Technology, 23.06.2019 09:30

Light travels at a speed of 186,000 miles a second. the distance light travels in a year is 5,865,690,000,000 miles/year 5,865,695,000,000 miles/year 58,656,950,000,000 miles/year 6,789,000,0000 miles/year

Answers: 1

Answer

Computers and Technology, 23.06.2019 18:00

Apunishment or the threat of punishment used to enforce conformity. select the best answer from the choices provided t f

Answers: 1

Answer

You know the right answer?

1. Add an index for the customer’s last name 2. Add an index on the number of days it took to ship...

Questions