DATABASE SECURITY

Answer

Tables

Student table

Faculty table

Offering table

Enrollment table

2)

a)

b)

c)

Student and Faculty users

d)

For Student user ‘ELLIOT@localhost’

For Faculty user ‘MARTIN@localhost’

3)

A,b)

c)

4)

a)

b)

5)

a)

b)

6)

a)

c)

d)