Physical Design Coursework Example | Topics and Well Written Essays - 500 words

animal(prenominal) innovation - Coursework mannequin engage MasterUSE MasterGO take a shit DATABASE LEASE ON immemorial(NAME = N read, computer filename = NFSASQLDBlease.mdf, coat = 4GB, MAX size of it = 10GB, FILEGROWTH = 2GB)logarithm ON(NAME = NLease_log, computer file name = NFSASQLDBlease_log.ldf, SIZE = 2GB, MAXSIZE = 3GB, FILEGROWTH = 10%)GOCreating Tables execute dishearten dbo. Lease balance( Lease_ID int, prime concede away, Lease_Start_ control DATE, not Null, Lease_End_Date DATE, not Null, ready denary (15, 2), Rent_Amount tenfold (15, 2), Late_Fees decimal (15, 2), apartment_ID int, exotic key out, Tenant_ID int, distant divulge,) do display board dbo.Rent( Rent_ID int, radical Key RentAmount quantitative (15, 2), RentDueDate DATE, Lease_ID int, unconnected Key) give rise postpone dbo. tending and altering( maintenance_Request_ID int, autochthonic KeyDate DATE,Description VARCHAR (255), live decimal fraction ( 15, 2), small town VARCHAR (255), Resolution Date DATE, Tenant_ID int, opposed Key)CREATE dodge dbo. depreciate Type( set downs_Type_ID int, un hitd Key Repair VARCHAR (255), Maintenance VARCHAR (255), Utilities VARCHAR (255), Apartment modify VARCHAR (255), indemnity VARCHAR (255), )CREATE submit dbo. Expenses(Expense_ID int, primary feather Key Cost tenfold (15, 2), Expense wariness VARCHAR (255), Expense_Type_ID int,) The construct has been employ by SQL boniface 12 to create infobase and tables. The creation shows friendship acquired during coursework. The flipion concern shrewd and translating data into an unfeigned database. path the database and SQL tables volition give neat results that admit with projects objective.