Answered You can hire a professional tutor to get the answer.

QUESTION

Need an argumentative essay on Physical Design. Needs to be 2 pages. Please no plagiarism.USE [Master]USE [Master]GOCREATE DATABASE [LEASE] ON PRIMARY&nbsp.(NAME = N'Lease', FILENAME = N'\\FSA\SQLDB\l

Need an argumentative essay on Physical Design. Needs to be 2 pages. Please no plagiarism.

USE [Master]USE [Master]GOCREATE DATABASE [LEASE] ON PRIMARY&nbsp.(NAME = N'Lease', FILENAME = N'\\FSA\SQLDB\lease.mdf’,&nbsp.&nbsp. SIZE = 4GB, MAXSIZE = 10GB, FILEGROWTH = 2GB)&nbsp.LOG ON&nbsp.(NAME = N'Lease_log', FILENAME = N'\\FSA\SQLDB\lease_log.ldf’,&nbsp.&nbsp. SIZE = 2GB, MAXSIZE = 3GB, FILEGROWTH = 10%)GOCreating TablesCREATE TABLE dbo. Lease Agreement&nbsp.(&nbsp. &nbsp. &nbsp. &nbsp. Lease_ID int, &nbsp. &nbsp. &nbsp.Primary Key,&nbsp. &nbsp. &nbsp. &nbsp. Lease_Start_Date DATE, Not Null,&nbsp. &nbsp. &nbsp. &nbsp. Lease_End_Date &nbsp. DATE, Not Null,&nbsp. &nbsp. &nbsp. &nbsp. Deposit DECIMAL (15, 2),&nbsp. &nbsp. &nbsp. &nbsp. Rent_Amount DECIMAL (15, 2),&nbsp. &nbsp. &nbsp. &nbsp. Late_Fees DECIMAL (15, 2),&nbsp. &nbsp. &nbsp. &nbsp. Apartment_ID int, Foreign Key,&nbsp. &nbsp. &nbsp. &nbsp. Tenant_ID &nbsp.int, Foreign Key,).CREATE TABLE dbo.Rent(&nbsp. &nbsp. Rent_ID int, Primary Key&nbsp. &nbsp. &nbsp. &nbsp. RentAmount DECIMAL (15, 2),&nbsp. &nbsp. &nbsp. RentDueDate DATE,&nbsp. Lease_ID int, Foreign Key).CREATE TABLE dbo. Maintenance and Repair(&nbsp.Maintenance_Request_ID int, Primary KeyDate DATE,Description VARCHAR (255),Cost DECIMAL (15, 2),Resolution VARCHAR (255), Resolution Date DATE, Tenant_ID int, Foreign Key).CREATE TABLE dbo. Expense Type(&nbsp. &nbsp. &nbsp. Expenses_Type_ID int, Primary Key&nbsp. &nbsp. &nbsp. Repair VARCHAR (255), &nbsp. &nbsp. &nbsp. Maintenance VARCHAR (255), &nbsp.&nbsp. &nbsp. &nbsp. Utilities VARCHAR (255), &nbsp.&nbsp. &nbsp. &nbsp. Apartment Cleaning VARCHAR (255), &nbsp.&nbsp. &nbsp. &nbsp. Insurance VARCHAR (255), ).CREATE TABLE dbo. Expenses(Expense_ID int, Primary Key&nbsp. &nbsp. &nbsp. &nbsp. &nbsp. Cost DECIMAL (15, 2), Expense Management VARCHAR (255),&nbsp. &nbsp. &nbsp. &nbsp. &nbsp. &nbsp. &nbsp. &nbsp. &nbsp.Expense_Type_ID int,). The design has been implemented by SQL Server 12 to create database and tables. The design shows knowledge acquired during coursework. The project involved designing and translating data into an actual database. Running the database and SQL tables will give proper results that comply with project’s objective. &nbsp.&nbsp.

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question