Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need Code please I don't need the steps I need the code DBMS Administration Project A company X has hired you to manage its

I need Code please I don't need the steps I need the code DBMS Administration Project 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 Database configuration Create the database [Database Name] that contains the following: Two Filegroups [Filegroup 1 ] and [Filegroup 2]. [Filegroup 1] is the primary filegroup. Two schemas called [Schema 1] and [Schema 2] 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% 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 2], [Data File 1] , [Data File 2] , [Data File 3] and [Log File Name]. Create at least four tables with all the possible constraints Note: you should rename the [Table 1], [Table 2], [Table 3], [Table 4], [Shema 1], [Schema 2], [Filegroup 1] and [Filegroup 2]. Backup and Restore Create a full database backup for the database in the following backup sets C:\Backups\[file_name].bak. Insert some data into the database and perform a differential backup in the same backup sets. Insert some data into the database and perform a transaction-log backup in the same backup sets. Change the Backup database option to be compressed to reduce the size and time taken to recover the database. You want to automate your backup overhead by scheduling your backups in the following structure: Weekly Full- Backup Daily Differential Backup Hourly Transaction-log backup. 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 4] 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 [user 1], [user 2], [user 3] and [user 4].

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Using Entity Relationship Diagrams

Authors: Sikha Saha Bagui, Richard Walsh Earp

3rd Edition

103201718X, 978-1032017181

More Books

Students also viewed these Databases questions