Tables, Keys, and Constraints

 

Start the VM for assignment three. Inside the VM, click Start, type SSMS (to open SQL Server Management Studio), and connect to the instance. Select Databases, then select the AdventureWorksDW2017 database for this assignment.

In this assignment, students will create database tables and implement keys and restraints.

The human resources department has requested that you create a table that can be used to store birthdays in the database. This table will be used to support a newsletter that is distributed internally to report on office events.

Please note that when SQL queries are run, results are generated in the form of data. This data should be exported and saved to a Microsoft Excel file for a visual check of accuracy.

Create a Microsoft Word document that includes the SQL query code used to explore the database tables and complete the following criteria. Make sure to provide a screenshot for each.

Create BusinessEntityID column as an integer. Include a DoB (Date of Birth) column and a date format.
Add a constraint to make BusinessEntityID a primary key.
Insert one record for BusinessEntityID 1 and include 1990/01/01 as the birthday.
Once added, query your new table showing the new record.

 

 

Sample Solution

 

A few people get irritated over hiccuping again and again. There are even individuals who have constant hiccuping. Truth be told, “how to dispose of hiccups” is one of the most-looked through inquiries on the web. All things considered, there are numerous things you can do. So as to dispose of hiccups, you can finish breathing and stance methods, use pressure focuses to further your potential benefit, eat and drink certain things, and utilize some exceptional cures. These arrangements will be talked about in the accompanying passages.

Right off the bat, there are many breathing and posing procedures you can use to dispose of hiccups. The vast majority of the procedures are anything but difficult to do. As per Healthline, there are six physical techniques for vanquishing your next hiccup: rehearsing moderate breathing, holding your breath in for some time, breathing into a paper pack, embracing your knees for two minutes while plunking down, compacting your chest by inclining or twisting forward, and finishing the Valsava move. As expressed by Healthline, “To do this move, attempt to breathe out while squeezing your nose and keeping your mouth shut” (“How to Get Rid of Hiccups: 26 Remedies That Can Actually Help”). You can’t do every one of these procedures at the same time, yet you can attempt them individually and see which ones work best for you.

Likewise, you can attempt to utilize your body’s weight focuses to further your potential benefit to scatter hiccups. In spite of the fact that weight focuses appear to be an exclusive science, standard western medication suggests utilizing them. As per Medical News Today, these three methods that manage these focuses can help: “[1] Pull on the tongue – hold the finish of the tongue in the fingers and pull. [2] Press on the stomach delicately. [3] Place delicate weight on each side of the nose while gulping” (Nordqvist, Christian). Despite the fact that these strategies may appear to be bizarre from the outset, they have a specific measure of adequacy that warrants their proposal.

Another normal method to dispose of hiccups is to expend certain nourishments and fluids. There are a lot of things we can eat and drink to pursue away a dreadful scene of hiccuping. As referenced by Healthline, it is acceptable to “drink ice water, gradually drink a glass of warm water ceaselessly to inhale, drink water through a fabric or paper towel, suck on an ice 3D square, swish ice water, eat a spoonful of nectar or nutty spread, eat some sugar, suck on a lemon, put a drop of vinegar on your tongue” (“How to Get Rid of Hiccups: 26 Remedies That Can Actually Help”) and that’s just the beginning. By and by, try out which nourishment and drink methods work best, rather than attempting numerous simultaneously.

And afterward, there are some abnormal procedures that have been prescribed by researchers and different masters. One of these hypotheses expresses that hiccups can be eased by having a climax (Peleg, R.). Another examination referenced that a rectal back rub can help in disposing of hiccups (Odeh, M, et al). Other elective techniques incorporate tapping or scouring the rear of one’s neck, jabbing the rear of the throat with a Q-tip, and diverting yourself with something captivating (“How to Get Rid of Hiccups: 26 Remedies That Can Actually Help”). The last one is even a respected convention in specific nations.

Hiccups can be an irritation, particularly on the off chance that they transform into an interminable condition. Fortunately, there are numerous moves we can make to clear up this issue: you can finish breathing and stance procedures, utilize pressure focuses, eat and drink specific substances, and utilize some elective cures. It is ideal to discover what works best for you out of the numerous decisions talked about in this exposition, as each body is unique.

Works Cited

“The most effective method to Get Rid of Hiccups: 26 Remedies That Can Actually Help.” Healthline, Healthline Media, www.healthline.com/wellbeing/how-to-dispose of-hiccups#other-cures.

Nordqvist, Christian. “Hiccups: How to Get Rid of Hiccups.” Medical News Today, MediLexicon International, 20 June 2017, www.medicalnewstoday.com/articles/9896.php.

 

This question has been answered.

Get Answer