Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 409 Weeks Ago, 1 Day Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Management Posted 22 Nov 2017 My Price 6.00

databases schema.

Consider the following databases schema.

Student(Ssn, Name, Major)

Course(CourseNo, Name, Description, Department, Credits)

Offered(CourseNo, Semester, Year, InstructorId, Location)

Instructor(InstructorId, Name, Department)

Enroll(Ssn, CourseNo, Semester, Year, Grade)

 

Write SQL expression for the following questions about the security aspects of above database.

(Note : You are owner of above database and You grants below task to ‘studentXX’ user and ‘ProfShekhar’ user using grant/revoke statements and creating view whenever necessary.)

1. Student can view all the information in the course and instructor tables except for InstructorId.

2. Student can also view the courseno, semester, year, location and instructor name(not instructorid) of all courses that are being offered.

3. Instructor, ‘ProfShekhar’ can view enrollment info(ssn, courseno, semester, year, grade) of students who are in his classes but only change the grade.

Answers

Maurice Tutor
(5)
Status NEW Posted 22 Nov 2017 10:11 PM My Price 6.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on-----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be-----------

Not Rated(0)