Question: Create two different Views using below relations, then Alter one of the Views and Drop the other one. After that discuss why Views are used

  1. Create two different "Views" using below relations, then Alter one of the Views and Drop the other one. After that discuss why Views are used by giving examples using relations from the tables below.

Student Relation

Student_ID Student_Name Dept_Name
0000 AAAAA Computer Science
1111 BBBBB Computer Science
2222 CCCCC Business Administration
3333 DDDDD Education
4444 EEEEE Physics
5555 FFFFF History

Student_Courses Relation

Student_ID Course_ID Section Year Grade
0000 CS 2203 2 2020 A
0000 CS 1101 1 2019 A
1111 CS 1101 5 2019 B
1111 CS 1102 1 2019 B
1111 CS 2204 1 2020 A
1111 CS 2401 1 2020 A
2222 BUS 1101 3 2019 C
2222 BUS 2201 1 2020 B
2222 BUS 3302 1 2020 B
3333 EDUC 5010 1 2019 A
3333 EDUC 5210 1 2020 B
4444 PHY 1101 4 2019 A
4444 PHY 2202 1 2020 C
4444 PHY 3304 1 2020 A

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!

Q:

KYC's stock price can go up by 15 percent every year, or down by 10 percent. Both outcomes are equally likely. The risk free rate is 5 percent, and the current stock price of KYC is 100. (a) Price a...

Q:

Discussion 7 questions make sure to answer all parts of questions detailed Read the Nasdaq article. Select one of the companies and state why you would be willing to invest in the IPO as part of your...

Q:

All of the following can be obtained from the value of the specific heat of a metal EXCEPT. A. The approximate density of a metal. B. The amount of heat that will be given off when 10 g of a metal...

Q:

Your Learning Journal entry must be a reflective statement that considers the following questions: Create two different Views using below relations, then Alter one of the Views and Drop the other...

Q:

Article Enhancing the ability to think strategically: learning model A Management Learning 41(2) 167-185 The Author(s) 2010 Reprints and permissions: http://www. sagepub.co.uk/journalsPermission.nav...

Q:

e eBook Collection Media & Culture Bedford/St. Martin's - ISBN 9781457628313 Bedford/St. Martin's - ISBN 9781457628313 CHAPTER 1 MASS COMMUNICATION___3 6 Culture and the Evolution of Mass...

Q:

Below is given an example design for a supermarket chain database design. For reference, both an ER-diagram and relational model description are included. Your task is to write SQL instructions to...

Q:

Part 1: Describe the structure of the group you have chosen (Coworkers, Work Setting). Also describe your role in the group. Part 2: Using both a credible resource (like a textbook) and your personal...

Q:

ROBE Math 1530 - all sections Summer 2015 About the Summer 2015 Math 1530 Capstone project In the regular Fall and Spring semesters, the end-of-semester Math 1530 Capstone Project uses data collected...

Q:

Theory X and Theory Y Attitudes Source: Lussier, R. N. & Achuia, C.F. (2010). Leadership: Theory, Application, & Skill Development. Mason, OH: South-Western Cengage Learning . Instructions: For each...

Q:

- OD 3 Activity Using Tinkercad Login into your Tinkercad account. Create a new Circuit. 1) Connect three of 1.5V battery as shown in Figure 3.1. Connect a multimeter and measure the voltage across...

Q:

Consider the following grouped sample data: Values Frequency 5 to under 10 15 10 to under 15 . 9 15 to under 20 21 20 to under 25 24 25 to under 30 .. 6 a. Calculate the approximate mean of these...

Q:

Evaluate each of the following. (a) -21+7 (c) -8+(-2) 15 (e) - -5 (b) 16+(-2) (d) -14 -18 (f) -3

Q:

A Capitalized cost was computed to be 2M. The structure includes some additional expenses of 100,000 at the beginning of the year for the next 15 years, a renewal cost of 200,0000 would occur in...

Q:

For each of the transactions below, record whether it would result in an increase or decrease in assets and/or liabilities. An organization: 1. Purchases supplies With cash. 2. Purchases supplies on...

Q:

For each of the transactions below, record whether it would result in an increase or decrease in assets and/or liabilities. An organization: 1. Purchases supplies with cash. 2. Purchases supplies on...

Q:

Air flows steadily through an engine at constant temperature, 127 deg C. Assuming that the Kinetic and Potential energies are negligible and if the exit pressure is one-fourth of the initial...

Q:

In order to finance his university studies Nedan ran a business buying and selling organic health products via mail order. However, he now has to concentrate on his final examinations so he decides...

Q:

Luther got a cut and shave at the new barber shop that opened up in town. He gave his service person a generous tip. This tip is reflective of whach stage of the consamer purchase dectsion...

Q:

Do you believe that Bernard Madoff worked alone, or do you think he had help in creating and sustaining his Ponzi scheme? Would this represent a conflict of interest? The fraud perpetrated by Bernard...

Q:

How can the provisions of the SarbanesOxley Act help minimize the likelihood of auditors failing to identify accounting irregularities? Arthur Andersen LLP was founded in Chicago in 1913 by Arthur...

Q:

Are subprime loans an unethical financial instrument, or are they ethical but misused in a way that created ethical issues? Not too long ago, Countrywide Financial seemed to have everything going for...

Q:

One of the fust Internet-based groceries home delivery businesses was Homegrocer.com. In 1998, Mike Donald, president of Concord Sales, one of the largest food brokers in B.C., and two partners...

Q:

Go to the Web site of Airbus A38G, the biggest passenger plane ever built (525 passengers or more on 2 floors, with a range of 15,000 km, and a wingspan of 80 metres), http://www.airbus....

Q:

The fixed cost of running a gift store (wages, rent, etc.) in a particular mall is $250,000 per year. The gross margin (i.e., sales - cost of goods sold or alternatively revenue - variable cost) is...