6. Consider the following two tables TableA aid atext 1 ab 3 TableB bid aid 111...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
6. Consider the following two tables TableA aid atext 1 ab 3 TableB bid aid 111 1 123 2 a) (10 points) Assume that aid is the primary key of Table A. Could aid in TableB be used as foreign key, referencing aid in Table A? If not, what changes would be necessary to allow introducing this constraint? b) (5 points) Could bid be made the primary key of TableB? What constraints would have to hold? Do they hold? c) (10 points) If there were a record with bid 222 and aid null in TableB, would this affect questions a) or b)? d) (10 points) What is the result of an inner join of TableA and TableB? e) (10 points) What type of join would represent all records from both tables? Show the result of that type of join. 6. Consider the following two tables TableA aid atext 1 ab 3 TableB bid aid 111 1 123 2 a) (10 points) Assume that aid is the primary key of Table A. Could aid in TableB be used as foreign key, referencing aid in Table A? If not, what changes would be necessary to allow introducing this constraint? b) (5 points) Could bid be made the primary key of TableB? What constraints would have to hold? Do they hold? c) (10 points) If there were a record with bid 222 and aid null in TableB, would this affect questions a) or b)? d) (10 points) What is the result of an inner join of TableA and TableB? e) (10 points) What type of join would represent all records from both tables? Show the result of that type of join.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these programming questions
-
"The point factor method may appear to be a very objective approach to valuing jobs, but like other job evaluation methods, it relies heavily on _ _ _ _ _ _ _ _ _ _ _ _ _ . " You Answered compensable...
-
answer all questions as instructed below. attend all questions. 4 Computer Vision (a) Explain why such a tiny number of 2D Gabor wavelets as shown in this sequence are so efficient at representing...
-
answer the question clearly You are building a flight-control system for which a convincing safety case must be made. Would you assign the tasks of safety requirements engineering, test case...
-
4. In cells B4:B15, type a yearly salary for each staff member. Format these values as Currency with no decimal places. 5. Calculate the new salary with a 10% increase in column C. 6. Calculate the...
-
Explain why materials with high m values, such as hot glass and silly putty, when stretched slowly, undergo large elongations before failure. Consider events taking place in the necked region of the...
-
The PMBOKRGuide states: Project Risk has its origins in the uncertainty present in all projects. It defines known risks as those that have been identified and analyzed, making it possible to plan...
-
\( \qquad \) refers to a company pulling revenues into the distribution channel fraudulently. a. Constructive intent b. Channel stuffing c. Gaming strategy d. Big bath e. Double play
-
A company manufactures three products: A, B, and C. The company currently has an order for three units of product A, 7 units of product B, and 4 units of product C. There is no inventory for any of...
-
missing answers on this sheet 5. On the balance sheet, the omission would cause: assets to be overstated by retained earnings to be overstated by On the income statement, the omission would cause:...
-
Other information: Intercompany sales: On January 1, Year 10: Salt had on hand $30,000 of inventory purchased from Pillar. Pillar had on hand $90,000 of inventory purchased from Salt. Both companies...
-
What is the director's role in building and supporting a diverse and inclusive community? Give examples of skills that you need in order to build and support a diverse and inclusive community in your...
-
Investment Mix Shares (%) Cash (%) Standard deviation (%) Growth 85 15 11.2 Balanced 70 30 9.6 Conservative 30 70 7.1 Cash 0 100 4.3 (a) If shares are expected to generate a return of 9% over the...
-
The stock of Big Joe\'s has a beta of 1 . 3 6 and an expected return of 1 1 . 9 0 percent. The risk - free rate of return is 4 . 4 percent. What is the expected return on the market?
-
Ailsa Foroutanzad\'s Eco - Power Ventures is considering investing in a project that captures and converts methane from organic waste into electricity. Below are the projected cash flows for the...
-
Calit Bintang Sdn Bhd is involved in freshwater pearl products. Producing the products will involve processes in three separate production departments which are supported by two service departments....
-
Briefly explain how the flow of costs in a job-order costing system follows the flow of the physical production (i.e., from raw materials purchases to sales and cost of goods sold). Make sure to...
-
A portfolio has been constructed by combining 2 assets in equal proportions. The Expected Returns in different economic scenarios are given in the table below Economic scenario Probability Assets A...
-
Why is inventory management important for merchandising and manufacturing firms and what are the main tradeoffs for firms in managing their inventory?
-
A computer that is in screensaver mode uses the same amount of power as one in regular mode. Computers that are in sleep mode, however, use much less power, say 6 watts per hour. Reflect on computer...
-
Prepare a 1-minute statement of what you have learned from this exercise that you could use for a job interview to illustrate your ability to innovate the use of technology in business.
-
Using the knowledge of this chapter and the intuition of the members of your team, summarize threats that cloud services present to such ISVs.
-
List some tax advantages of retirement investing.
-
Go to the Web site of Yahoo! Finance (http://finance.yahoo.com). Enter the ticker symbol for Home Depot (HD) and Lowes (LOW). For each firm, click on Profile and note the ratio for Profit Margin (the...
-
Describe why you should itemize deductions as opposed to taking the standard deduction.
Study smarter with the SolutionInn App