Question: Introduction to Database System Design please finish 1, 3, 4 Part3: Exercise on Partl and Part 2- Write queries for following statements: [30 points] 1.

Introduction to Database System Design

please finish 1, 3, 4

Part3: Exercise on Partl and Part 2- Write queries for following statements: [30 points] 1. c. Assume you are given two relations, student(name, rollno) and marks(rollno, exam, mark) Show names of all students who have got marks in at least two exams. 2. Create a view CSinstructors, showing all information about instructors from the Comp. Sci. department 3. Grant permission to one of your friends to view all data in your student relation. Also make sure that you are granting your friend to pass the permission to others. 4.(i) create a role CS_staff (ii) Allow CS_staff to only see/read data from the view CSinstructors created in exercise 2. (iii) Add user Matt (you created before in part 2) as CS_staff. (iv) Login as Matt and show he can only execute select queries on CSinstructors

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!

\fThis is an electronic version of the print textbook. Due to electronic rights restrictions, some third party content may be suppressed. Editorial review has deemed that any suppressed content does...

1 Exercise 3: Lift and Airfoils The first part of this week's assignment is to choose and research a reciprocating engine powered (i.e. propeller type) aircraft. You will further use your selected...

I only need for the economics and financial performance part to be done as per the table in the assignment question attachment. 600-800 words. I have completed the rest of the assignment already. The...

ACCT2060- Accounting for Organisations and Society Marking Rubric for Individual assignment Semester 1 2016 High distinction 10 Distinction 7.5 Credit 6.5 Pass 5 Below standards 2.5 Title page, and...

ACC 205 week 1 Discussion 2 Accounting Equation Discussion 2 Accounts ACC205 Principles of Accounting I Course Guide This course is an introduction to the principles and procedures of general...

I need help with Section 4 part A please look at the case study Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student identification (student to complete) Please complete the...

i need help from section 3 part A I have already posted this and you asked me to post under advanced option Assignment Tier 1 Financial Planning (Tier1FPPA_AS_v1A3) Page 2 of 92 Student...

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

I have to do an accounting assignment. I have attached the instructions, the questions, and pdf's containing the information requested for the questions. Company Estimates & Opinions Sanmina Corp...

Haluk Demirkan Project Scheduling Assignment - MS Project The following questions below are to be answered using Microsoft Project (or any other project management software package). In order to turn...

Explain what Schein (2004) meant by espoused values and basic underlying assumptions. 2. Give evidence of each of these dimensions of culture explaining your choices.

Caswell Enterprises had the following end-of-year stock prices over the last five years and paid no cash dividends: Time Caswell 1 ........$10 2 ........ 15 3 ........ 12 4 ........ 9 5 ........ 10...

Al receives a bank loan to expand is auto dealership. This is an example of Group of answer choices indirect finance. a secondary market transaction. direct finance. securitization .

Question 2(20m) Usine the liquid drop model (semi-empirical mass formula - seMr) a. Predict the atomic mass of the 'fo in units of amu. b. Not knowing the actual mass M(816O), would you expect the...

Imagine that the U.S. Congress, recognizing the importance of being well dressed, started giving preferential tax treatment to clothing insurance. Under this new type of insurance, you would pay the...

Find some information on an index fund (such as the Vanguard Total Stock Market Index, ticker symbol VTSMX). How has this fund performed compared with other stock mutual funds over the past 5 or 10...

According to an old myth, Native Americans sold the island of Manhattan about 400 years ago for $24. If they had invested this amount at an interest rate of 7 percent per year, how much would they...