ScreenShots are REQUIRED please. "It's a project".

Using MYSQL.

Choose the topic you find easier, and name randomly the company and users.

THANKS.

what's dba ?

You should provide A, professional written, describing your topic. . Select one of the following topic: Topic 1: Database mirroring Topic 2: Database replication Topic 3: Security of distributed databases A team (max 2 students) can take one topic among the above three topics and provide all the existing solutions. CSIT435 DBMS Administration Project - Part II A company X has hired you to manage its database. Choose a subject and propose a database for the company X Perform the following tasks under Microsoft SQL Server 2012 (If not specified, you can write TSQL scripts or show the SSMS snapshots). Database configuration 1. Create the database (Database Name) that contains the following: a. Two Filegroups [Filegroup 1 ] and [Filegroup 2). [Filegroup 1) is the primary filegroup. b. Two schemas called (Schema 1) and (Schema 2] c. Data files: One Data file [Data File 1) on the Primary Filegroup and two other files [Data File 2] and [Data File 3) on the [File Group 2] Filegroup with the following properties: Path: D: [Database Name] Initial Size: 50MB Maximum size: Unlimited File Growth: 10% d. Log File: Path: D: [Database Name)\[Log File Name] Initial size: 15MB Maximum size: Unlimited File Growth: 5MB Note: you should rename the Database Name), (Filegroup 1), (Filegroup 2), (Shema 1), (Schema 21. [Data File 1). [Data File 21. [Data File 3] and [Log File Name). 2. Create at least four tables with all the possible constraints Table Schema Filegroup [Table 11 Schema 1] [Filegroup 1] [Table 21 Schema 1) [Filegroup 1) [Table 31 Schema 21 [Filegroup 2] [Table 41 [Schema 21 [Filegroup 21 Note: you should rename the [Table 1], [Table 2), [Table 3). [Table 4), (Shema 1]. [Schema 21, [Filegroup 1) and (Filegroup 2). Backup and Restore 1. Create a full database backup for the database in the following backup sets "C:\Backups\file_name] bak". a. Insert some data into the database and perform a differential backup in the same backup sets. b. Insert some data into the database and perform a transaction-log backup in the same backup sets. c. Change the Backup database option to be compressed to reduce the size and time taken to recover the database. 2. You want to automate your backup overhead by scheduling your backups in the following structure: a. Weekly Full-Backup b. Daily Differential Backup c Hourly Transaction-log backup. 3. Write in details the necessary steps to restore the database in case of failure. Security The two users [user 1) and (user 2) are hired to manage the data of the first schema Schema 1). They can insert, update and delete data of [Schema 1). . The user user 3) that can only insert and update data of (Schema 1) but is denied to delete any data The user user 41 can only perform select queries on both schemas tables. Create the necessary roles that facilitate the database security management in addition to the users (user 1), (user 2), (user 3) and (user 4). Note: you should rename the fuser 11. user 2). [user 3) and (user 4)