Question: Question 2: Consider two tables: Faculty and Course as shown below: Stid StudentName Subject Marks S234 Usman OOP 60 Semester WANN 2nd S235 Tahir OOP

Question 2: Consider two tables: Faculty and Course as shown below:

Question 2: Consider two tables: Faculty and Course as shown below: Stid StudentName Subject Marks S234 Usman OOP 60 Semester WANN 2nd S235 Tahir OOP 70 2nd S236 Ayesha PF 30 1st S237 Samad PF 20 P.T.O (1/2) crCode TeacherName Stid WWW WANN C3456 Muhammad Waqar S234 C3457 Talal Ahmed C3458 Ali Hassan S236 C3459 Naqash Ali S237 a. Apply inner, outer, right and left joins on above tables and display the result. b. Differentiate among Entity integrity, Referential integrity, Null and Domain Constraint. How we can achieve them in sql. Write spl queries which can assure above mentioned constraints? (CL03) (20)

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!

plz do it on paper Semester Question 2: Consider two tables: Faculty and Course as shown below: Sud StudentName Subject Marks S234 Usman OOP 60 S235 Tahir OOP 70 2nd 20 S236 Ayesha PF 30 1 S237 Samad...

do it on paper Question 2: Consider two tables: Faculty and Course as shown below: factd facName. dept salary rank F234 Usman CSE 21000 lecturer F235 Tahir CSE 23000 Asso Prof F226 Ayesha ENG 27000...

Question 1 Migration plays an important role in economic development and as a strategy for poverty reduction. Burkina Faso, whose conditions for agriculture are far from favorable, has a long history...

Material Requirement Planning (MRP) is process of forecasting number of Parts required to cover demand. Stock Keeping Units (SKUs) are entities which are made up of one or more parts. Each SKU and...

QUESTION 2 Consider two hosts, A and B connected by a single link of rate Rbps. Host A sends a packet of size L to Host B. At time tedtrans, the last bit of the packet is QUESTION 3 Consider two...

QUESTION 1 Consider two classes of business statistics. Suppose that average test score for the first class is 80 and the average test score for the second class is 78. What is the point estimate for...

Which of the following incorrectly describes the put call parity? It is strictly applied only on European call and put with the same strike and expiration date It connects the put and call premiums...

QUESTION 1 Consider two classes of business statistics. Suppose that average test score for the first class is 81 and the average test score for the second class is 78.4. What is the point estimate...

Question 1. In a CAPM world, is the following scenario possible? Explain why or why not. Question 1. In a CAPM world, is the following scenario possible? Explain why or why not. Portfolio Expected...

Question 1: Consider a line consisting of two machines in series. The first machine on average, te(1) = 8 minutes to complete a job. The second machine takes te( 2)=5 minutes. Both machines have...

Alpha helices and beta-sheets are the major secondary structure in protein meanwhile among beta-turn type 1 and 2 beta turns are the most common motifs which is the location of the hydrogen bond in a...

Answer the following questions for each of the compounds: a. How many signals are in the 13C NMR spectrum? b. Which signal is at the lowest frequency? 1. CH3CH2CH2Br 2. (CH3)2C==CH2 3. CH3CH2OCH3 4....

11.11 The thrust of an engine (y) is a function of exhaust temperature (x) in F when other important variables are held constant. Consider the following data. y x y x 4300 1760 4010 1665 4650 1652...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Explain why the following statements are false. a. The aggregate-demand curve slopes downward because it is the horizontal sum of the demand curves for individual goods. b. The long-run...

Suppose that the economy is currently in a recession. If policymakers take no action, how will the economy change over time? Explain in words and using an aggregate-demand/ aggregate-supply diagram.

Suppose the U.S. economy begins in long-run equilibrium. Concerns about global climate change cause the government to significantly restrict the production of electricity from fossil fuels. Because...