subject

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.

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 17:20
What do you need to know & understand about global expansion.
Answers: 2
question
Computers and Technology, 22.06.2019 21:00
Simon says is a memory game where "simon" outputs a sequence of 10 characters (r, g, b, y) and the user must repeat the sequence. create a for loop that compares the two strings starting from index 0. for each match, add one point to userscore. upon a mismatch, exit the loop using a break statement. assume simonpattern and userpattern are always the same length. ex: the following patterns yield a userscore of 4: simonpattern: rrgbryybgy userpattern: rrgbbrybgy
Answers: 2
question
Computers and Technology, 23.06.2019 23:30
What can you prevent issues related to downloading content form the internet
Answers: 1
question
Computers and Technology, 24.06.2019 09:00
Technician a says that a new replacement part is always good. technician b says that sometimes recent repair work will be the cause of a complaint. who is correct? a. both technicians a and b b. technician a c. technician b d. neither technician a nor b
Answers: 3
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
question
Mathematics, 21.10.2020 04:01
question
Mathematics, 21.10.2020 04:01
question
Chemistry, 21.10.2020 04:01
question
Mathematics, 21.10.2020 04:01
question
Mathematics, 21.10.2020 04:01