1) Create and maintain a database Server
2) Implement Database security policies
The objective is to enable the student to work on a relational database server and involve in creating, securing and maintaining of objects needed for databases and implement database security policies. Hence, student’s ability to think and engage with the topic is tested.
Task 1 –Assume that you are working as a database administrator for some organization (e.g. bank, airlines, hypermarket etc.). Provide the solutions for the following
i. Create tablespace by name organizationname_yourID with at least one optional feature.
ii. Create three users by name Mohamed_yourID, Adam_yourID and Ali_yourID and link the thus created users to the above tablespace. (Passwords of each of the users can be same as Username).
iii. Grant the appropriate privileges all the users created in (ii) above,
iv. Through the Login credentials of the user Mohamed_YourID, create the two tables- Use overall at least four datatypes including a Date datatype and four different constraints.
v. Through the Login credentials of the user Adam_YourID, create the two tables – having primary key and foreign key relationship
vi. Through the Login credentials of the user Adam_YourID, Alter the any one of the table by adding two new columns with constraints and display the altered table
vii. Through the Login credentials of the user Adam_YourID, Create any two synonyms for any of the two tables thus created.
viii. Through the Login credentials of the user Adam_YourID, Create an index on multiple columns of a table and display the index through appropriate query.
ix. Create one sequence of your choice that will be helpful for your organization.
x. Insert at least 2 rows to the table for which sequence is created.
xi. Insert at least 2 rows with appropriate values on any two tables having primary key foreign key relationship.
xii. Create and invoke an appropriate Trigger when row is inserted in one the tables created.
-Please ensure that the names of all objects such as tables, views, synonyms, must have your student ID at the end like Order_17F1234 and also names of primary/foreign key columns must have your student ID at the end such as Order_ID_171234). Also, the rows must be uniquely inserted (no two student rows should match!)
-If the user names are not same as mentioned in the task, marks will be deducted accordingly.
Task 2 – Register yourself for the given course below. After completing the course, write a reflective report on the contents learned from the completed course in about 300 to 400 words. Also, attach the proof of completion of the said course. The proof can be an email intimating your success in the course by the Udemy OR the copy of Certificate issued by the Udemy.