Question: make a database with this structure on SQL Server Management I don't understand how to set the relations between the tables. The following is a

make a database with this structure on SQL Server Management

I don't understand how to set the relations between the tables.

The following is a diagram representing the tables in the Company database and how the tables are related. employee fname minit address salary supersn dependent 7x dependent_name relationship Instructions CHU works on + CSSn pne department dname dnumber mgrssn mgrstartdate 8 project chame pnumber plocation drum dept locations 7 dnumber 7 dlocation

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Other than hospitals, the United States has a large number of ___________ centers that provide free, primary care on a "safety-net" basis

A borrower would like to borrower $66,000 to finance a property for 30 years at 16.1% interest. The lender indicates that loan fees (origination and discount points) equal to 3.9% of the loan amount...

Q.1.Consider the ER diagram shown below for part of a BANK database. Map the ER diagram into a RELATIONAL SCHEMA. Specify all primary keys and foreign keys. Q.2.Use the relational schema shown below...

The author explores the dangerous world of undercover police work. Having read this chapter, do you believe this type of police work has the capability of corrupting police officers? If so why, and...

Was the gas rationing in New Jersey the fairest response to the gasoline crisis? Who got the available gasoline? Who would have gotten it in the absence of price controls?

Use the data for Spear Corporation in E6-30B to answer the following. Requirements 1. Compute cost of goods sold and ending inventory using each of the following methods: a. Specific identification,...

If a reversal design was used, was the intervention discontinued for a sufficient period of time? Was the intervention then reinstated with the same desired results?

Guitar Universe, Inc., is a popular source of musical instruments for professional and amateur musicians. The companys accountants make necessary adjusting entire monthly, and they make all closing...

A $130,000 mortgage at 2.5% compounded semi-annually with a 20 year amortization requires monthly payments. How much will the amortization period be shortened by if a prepayment of $12,000 is made at...

1. The total payroll tax expense incurred by the employer on salaries and wages paid during the quarter ended December 31 was.....................$ 2. The total payroll tax expense incurred by the...

4 times the difference of f squared and g , increased by the sum of f squared and 2 g

An employer in Seattle, Washington has started a new "healthy lifestyle" initiative for employees and indpendent contractors. The desired achievement for each group is a mean score of 25 on a...

Bintang Jaya Bhd operates two (2) production departments, Machining, and Assembly and two (2) service departments, Canteen and Store. Machining department is highly dependent on the use of machines,...

Henrik is stopped behind another vehicle at an intersection. The light turns green, and he waits 3-4 seconds before accelerating. Why should he do this?It puts adequate following distance between...

You & a group of your co-workers go for after-work drinks on Fridays. Although the time together usually starts off positive and fun, it usually disintegrates into a trash talk session about your...

STORY: https://www.psychologytoday.com/us/blog/twofold/202109/twins-separated-birth-growing-continents-apart Part 1: After you have read their story, describe about how environmental and genetic...

A. List price B. Merchandise inventory C. EOM D. Single-step income statement E. FOB F. Acid-test ratio G. Inventory shrinkage H. Selling expenses I. Multiple-step income statement J. General and...

Consider the activities undertaken by a medical clinic in your area. Required 1. Do you consider a job order cost accounting system appropriate for the clinic? 2. Identify as many factors as possible...

Inc. prepared the following cash budget for the fourth quarter. Required Fill in the missing amounts, assuming that Topper desires to maintain a $15,000 minimum monthly cash balance. Any required...

Browning Design Works generated $300,000 in operating income on sales revenue of $2,000,000. The company had $2,200,000 in assets on January 1 and $2,800,000 in assets on December 31. Required a....

Phelps Gold manufactures award medals. In August, Phelps produced 5,000 medals, 100 more than expected. During the month, the company purchased 1,100 ounces of gold for $875,000. The standard price...

=+58. Explain why it is possible for all the measurements in a given sample to lie within the specification limits and for the same data to yield a nonzero estimate of the proportion of the process...

=+b. Check the chart in part (a) for any out-of-control points. If there are any, eliminate them from the data and reconstruct the s chart. Repeat this process, if necessary, until there are no...

=+56. A manufacturer of dustless chalk monitors the consistency of chalk by running an s chart on the density of chalk in subgroups of size 8. The most recent 24 such subgroups had the accompanying...