Question: What is a view? Discuss the difference between a view and a base relation.

What is a view? Discuss the difference between a view and a base relation.

Step by Step Solution

★★★★★

3.47 Rating (170 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

View is the dynamic result of one or more relational operations operating on the base relati... View full answer

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

Document Format (1 attachment)

Word file Icon

672-CS-DB (1227).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Q:

If you have studied COBOL, discuss the difference between numeric characters and numbers in the context of a COBOL program. Does COBOL distinguish clearly between the two? If so, in what ways?

Q:

Briefly discuss the difference between acting morally and acting legally. Give an example of acting legally and yet immorally.

Q:

What is semistructured data? Discuss the difference between structured, semistructured, and structured data. Give examples to illustrate your answer.

Q:

QUESTION 1 a ) Describe with the aid of a diagram the difference between external, internal and conceptual schemas. b ) Define the following terms: ( i ) Meta - data ( ii ) Data redundancy c )...

Q:

QUESTION 2 [25 Marks] Discuss the differences between the candidate keys and the primary key of a relation. (4 Marks) Describe the meant by a foreign key. How do foreign keys of relations relate to...

Q:

In case study 1 (page 3) Question A. why is the cost of sales for group 1/2*12000 and not 1/2*15000? why is the inventory 1/2*12000 also? not 1/2*15000? Question B. why is the example using 2100? Is...

Q:

In case study 1 (page 3) Question A. why is the cost of sales for group 1/2*12000 and not 1/2*15000? why is the inventory 1/2*12000 also? not 1/2*15000? Question B. why is the example using 2100? Is...

Q:

In case study 1 (page 3) Question A. why is the cost of sales for group 1/2*12000 and not 1/2*15000? why is the inventory 1/2*12000 also? not 1/2*15000? Question B. why is the example using 2100? Is...

Q:

answer questions 4,5,6 hello , the questions 4,5,6 are the questuons using the information i provided .. only write out whatever info is found . also question 6 to write out a memo stating a clear...

Q:

please answer question 1,2,3,4,5 DA2 Risk For Students(2) (1) QSearch Sheet AutoSave FF Review View DComments Home Insert Draw Page Layout Formulas Data Share _ 4 AY Insert vA A General Calibri...

Q:

Solve the differential equation using the Fourier transform technique. d*y dx4 - y = 8(x - a);

Q:

Immediately upon receipt of cash, a responsible employee should a. Record the amount in the cash receipts journal. b. Prepare a remittance listing. c. Update the subsidiary accounts receivable...

Q:

Eddie, an entrepreneur, raises funds by selling shares in his new firm to an old college buddy. This is an example of Group of answer choices indirect finance. financial intermediation....

Q:

Enter www.marchofdimes.com/, the website for the March of Dimes, a nonprofit founded in 1938 by President Franklin D. Roosevelt to conquer polio (he was a polio victim himself). FDRs portrait appears...

Q:

Show that it is possible to ensure that a dependency-preserving decomposition into 3NF is a loss less-join decomposition by guaranteeing that at least one schema contains a candidate key for the...

Q:

List the three design goals for relational databases, and explain why each is desirable.

Q:

Give a loss less-join decomposition into BCNF of schema R of Exercise 7.2.

Q:

Question 3 of 6 A bank in London, Ontario charges 3.00% commission to buy and sell currencies. Assume that the current exchange rate is US$1 = C$1.3045. a. How many Canadian dollars will you receive...

Q:

OCK, Ltd. is a manufacturer and retailer of popular snacks. The company is expecting $80,000 in sales for the coming year, along with $30,000 in variable costs, $15,000 in fixed costs and $10,000 in...

Q:

Could someone please help me with this? I need to sketch these trees, not code them. This homework is NOT a programming homework. The submission MUST be in PDF format. You are recommended to use...