Learning Outcomes:1) Create and maintain a database Server2) Implement Database

Learning Outcomes:1) Create and maintain a database Server2) Implement Database security policiesAssignment ObjectiveThe 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 followingi. 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 relationshipvi. 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 tablevii. 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.Note:-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.(https://www.udemy.com/course/oracle-applications-multi-org-access-control-moac/)*** Here is my ID number: 20s20010*** In-Text Citations and References using Harvard style. (If needed)
Requirements: As mentioned

Learning Goal: I’m working on a databases question and need support to help me l

Learning Goal: I’m working on a databases question and need support to help me learn.
Review Discussion: Storytelling and Success Stories then focus on Moritz’s work on the OECD Better life index download the executive summary and the index data.
In a one-page summary, note a few particular places around the world and compare and contrast the statistics. Also, note briefly how this graphic tells the story.

Learning Goal: I’m working on a databases discussion question and need an explan

Learning Goal: I’m working on a databases discussion question and need an explanation and answer to help me learn.
1) Give examples of systems in which it may make sense to use traditional file processing instead of a database approach.
2) If you were designing a Web-based system to make airline reservations and to sell airline tickets, which DBMS Architecture would you choose from Section 2.5? Why? Why would the other architectures not be a good choice?