MEC Collage Database Administration Task Work proposal for this assignment which must include: 1. Understanding of deliverables – a detail description of

MEC Collage Database Administration Task Work proposal for this assignment which must include:

1. Understanding of deliverables – a detail description of deliverables.

2. General overview of proposed plan – initial understanding of solution for the task-2 and task-3.

3. Resources identified.

The Assignment include task 2 and task 3:

Task-2: In the college database lab, consider any two computer systems as clients, and a third computer system as a server. Establish client/server connectivity between the two clients and the server. Create any database table (e.g. Tbl_Student_YourID(ID, Name, Module)) on server; insert records from both the clients to save in the table (Tbl_Student_YourID).

Your solution must include brief explanation of the steps in establishing the client/server connectivity and the screenshots of the steps and SQL commands.

Task-3: Consider you are working as a Database Administrator (DBA) in a certain large organization. Protecting data is one of your major tasks in the day-to-day operations. As a DBA, discuss various steps you would take to ensure proper planning of the database instance redo logs.

Your solution must include the relevant SQL commands and screenshots. The solution must be written in a maximum of 3 pages.

Note:

– only need a work proposal for this assignment (2 to 3 Pages)

– Kindly make sure of, zero similarity in turn it in