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, 23.06.2019 04:20

4. a1. vince owns a television repair shop that is insured undera commercial package policy. the policy includes thebuilding and personal property coverage form and thecauses-of-loss broad form. the declarations page indicatesthat coverage applies to both the building and the namedinsured's business property. explain whether or not thefollowing losses would be covered under his policy.a. a fire occurs on the premises, and the building isbadly damaged.b. a burglar steals some money and securities from anunlocked safe.c. a business computer is damaged by vandals whobreak into the shop after business hours.d. a tornado touches down near the store. several tel-evision sets of customers in the shop for repair aredamaged in the storm.til

Answers: 2

Answer

Computers and Technology, 23.06.2019 09:00

Which best compares appointments and events in outlook 2010appointments have a subject man, and events do notappointments have a specific date or range of dates, and events do notappointments have a start and end time of day, and events do notappointments have a location option, and events do not

Answers: 2

Answer

Computers and Technology, 23.06.2019 23:30

Worth 50 points answer them bc i am not sure if i am wrong

Answers: 1

Answer

Computers and Technology, 24.06.2019 01:30

How would you cite different books by the same author on the works cited page? moore, jack h. folk songs and ballads. salem: poetry press, 1999. print. moore, jack h. ballads in poetry – a critical review. dallas: garden books, 1962. print. moore, jack h. folk songs and ballads. salem: poetry press, 1999. print. –––. ballads in poetry – a critical review. dallas: garden books, 1962. print. moore, jack h. ballads in poetry – a critical review. dallas: garden books, 1962. print. moore, jack h. folk songs and ballads. salem: poetry press, 1999. print. moore, jack h. ballads in poetry – a critical review. dallas: garden books, 1962. print. –––. folk songs and ballads. salem: poetry press, 1999. print.

Answers: 2

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