Database Administration

 

• The word final containing group members details, answers to the descriptive questions and screen shots of the programming tasks should then be

Tasks

Task-1 Suppose you are given the task to create roles and assign users to them for Sohar college. Write a detailed description with examples on the roles, their privileges and users.
Task-2 Create the following tables in SQL and populate them with the data of all group members for this semester. You need to show both the SQL queries and the populated tables. Please make sure to apply various constraints that are applicable.
STUDENT
Student_ID Name Age Address

COURSE
Course_Code Course_Name Units Instructor

STUDENT-COURSE

Student_ID Course_Code

 

 

Task-3 Install Oracle on your computer (You need not to reinstall if you have already installed it. In that case, just provide the screen shot of running Oracle )

 

Task-4 Login to Oracle with system/123

Task-5 Create the following users

User Name Password
User 1 uID1 First Name
User 2 uID2 First Name
User 3 uID3 First Name
User 4 uID4 First Name

*where ID1 is the student ID for the first student of the group, ID2 is the student ID for second student and so on

Task-6 Create the following three roles and give them permissions according to the description
Category1 can only retrieve data from STUDENTS table
Category2 can insert and delete data from STUDENTS and COURSES tables
Category3 have all privileges for both STUDENTS and COURSES table
Task-7 Assign the created roles as follows
Category1 to User 1
Category2 to User 2
Category3 to User 3 and User 4
Note: User 1, User 2, User 3 and User 4 have to be the same as that of task 5

 

 

Sample Solution

Paper On Poems The three sources I decided for three papers depend on ladies. They are all change and change. My two decisions, Anne Hart’s “Friday has made a huge difference”, and Dr. Sharon’s “Ladies and World War II” all worry ladies’ previous ceremonies. The third decision of Kathleen McFarland, “The sun is consuming gas (losing companions)” is tied in with developing young ladies. My best option was a short story by Anne Hart ‘Everything changed on Friday’. The subject of this article is verse Hamðismál. That sonnet is about the aftereffect of activities for Svanhildr’s killed lady and her family to render retribution on her demise. It will present the sonnets that caused her homicide, the substance of the episode and the occasions that happened after her demise. The initial two areas can be thought of as the presentation of the story the peruser is attempting to peruse. It passes on the genuine conduct that has occurred. – … He realizes that the way that Poseidon went to get him was daring, the way that he kept on cruising the ocean. At the point when he at long last came back to the place of Isaac, he and his child Telemachus needed to battle a gathering of occupied individuals. Regardless of his underrepresentation, he despite everything battled with them without leniency. Odysseus end up being valiant, however there are a few different clarifications and he likewise indicated an extraordinary awareness of other’s expectations. The fundamental character must be liable for busy Odyssey, 24 epic sonnets are generally credited to old Greek writer Homer. This sonnet is the tale of O King of Itaca King Odysseus. He attempted to return home 10 years after the Trojan War finished (the development of this sonnet was just the most recent a month and a half). At the point when he returned, he had just reliable canines and medical attendants to remember it. With the assistance of his child Telemachus, Odysseus will drive away the difficult quest for his devoted spouse Penelope and revamp her servant in his realm with a portion of her commonality with supporters did. Odysseus of “Odyssey” is the saint of an epic called “Odyssey”. In this sonnet Odysseus has some misfortune to get back, a few divine beings will support him, and a few people upset him; his country venture is a consistent fight. In this sonnet, we see that men have been broken and revamped, and that his convictions have been jeopardized by the persistent negativity Athena’s assistance, he will travel You may surrender. – The initial four books of Odyssey’s Telemacos Odyssey are now and then called “telemacy”. This is really another part that you can undoubtedly erase, you can begin a story from Odysseus without breaking the plot. Through movement and investigation they manage Telemacos’ battle and development.

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.