W4 Lab1 - *ir Table Name Column Name Data Type Allow Hey...

Info icon This preview shows pages 1–11. Sign up to view the full content.

View Full Document Right Arrow Icon
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 2
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 6
Image of page 7

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 8
Image of page 9

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 10
Image of page 11
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: *ir Table Name' Column Name Data Type Allow Hey Field Mulls (PrimaryfFureign) (Yestn) Building BuildingNumber “[1; ND Primary — Wui'dm Cit W No Buildingstate warcharflj ND Buildin i ND .fligartmenthiumber ND Primary —— No Foreign _eaSEStartDate _EaseEndDate Slate - _Easel‘i.riunthlyfient decimal 1|],2j —— No WWW No Frirnerir maintenanceHeguestDate Date ND —— No Foreign — ‘u’laintenanceHesalutiDnDate ND VlaintenanceHesulutiDnType nyarcharfififlj MaintenanceResalutiDnfic’ciDn warcharflififij - ‘i.r1aintenanceResulutiDnExgense decimalilflflj —— No Foreign FientPayment HentPaymentKey ND Primary QantPaymentDate Date HentPaymentgflmuunt decimalilflflj - _EaseNumber “a; Foreign W No Frirnerir TenantLastName nyarcharEEEEj ND — Wm n..ir..e.r..e.n..e..r.i256:i No Microsoft SQL Server Management Studio File Edit View Debug Table Designer Tools Window Community Help alNeruerv LT: L3 L3 al A) Eli, I: dbo.B ' I: z n I: x U / U1 .1: ,_ U'I -g 'x [Tulane-Building v L5 CONCORDISQLSERVERGQL Ser' _l BulldlngNumber Int l— 3-5 4} — L] Databases _| BulldlngAdclress nyarchar(256) '— __(-1d‘entit ) + :yster: DatabaESeI-frzflfls _| BunldingCity nyarchar(256) I— (Name) y Building + + Regjflggfvefgsqsmw _| BuildinoState nvarchar(2) l— Database Name WilchoodApartmentDBl + L, ReportSeryer$SQLSER\-'E _DI BuildinoZiD int l— Description + [a chlWooclApartrnent _l '— SChema dbD — [4 chlWooclApartmentDBl Server Name concord'tsolseryer + L] Database Diagrams - Table Designer — L] Tables Identity Column + L] System Tables Indexable Ves + 3‘ dbD-BUildinQ LockEscalatIon Table + L] Views + Regular Data Space PRIMARY + L: Synonyms Replicatecl No + L] Programmability Row GUID Column + L] 55mm Bmker Textflmage Filegrot PRIMARY + L] Storage + L] Security + L] Security + L] Server Objects + L] Replication Co umn Properties | + L] Management - (General) A (Name) BuildingZip Allow Nulls No Data Type int Default Value or Bincllng - Table Designer . -I (General) (Name) Item(s) Saved icrosoft SQL Server Management Studio File Edit VIEW Debug Table DeSIgner Tools Wlndow Community Help gnaweuew o 03 o; a 4 e; it "1' "E" EDNEDRD\SQLS...bo.Apartment| CONCORDISQLSE...-dbo.BuiIding | v X [Thu dim-Apartment v — Ll} CONCORDISQLSERVERGQL Ser' J ApartmentNumber int l— gt} a L] Databases fl BuildingNumber int 1' ‘ . + .__'| System Databases J 7 (Ident'tn + [d AdventureWorksLTZDDB (Name) Apartment + [4 ReportSewerfiQLSERVE Database Name WildWoodApartmentDB + [4 ReportServer$SQLSERVE Descrlptlon + [d WildWoodApartment SCtha Elba 7 l4 WildWoodApartmentDBl Server Name concordisqlserver + .__'| Database Diagrams - Table Designer — L] Tables Identlty Column + L3 555th Tables Indexable Yes + :1 dPD-EUilding Lock Escalation Table T :1 dbU'F‘partment + Regular Data Space PRIMARY + l—J V‘ews Replicated No + L3 Synonym; _ Row GUID Column + L3 Programmabmty Textflmage Fllegrot PRIMARY + L] Serwce Broker + |__'| Storage + L] Security + L] Security + .__'| Server Objects Co umn Properties | + L] Replication Eh: A + L] Management 8—55 '1: ‘ a (General) A (Name) BuildingNumber Allow Nulls No Data Type lnt DeFault Value or Blnding - Table Designer 4Coflatioo—4databasefietaulb—Ll (General) (Name) _'I Item(s) Saved .- l| I’u—nlllli'"? Ir..ln|a . ,. 13:34 _ comcoeoxsoLS... dho.Tahle_1"‘ CONCORDISQLS. . .bofipar _l Column Name I Data Type FlllIZIW Nulls _| LeaseNumber int I— _| LeaseStartDate date I— _| LeaseEndDate date I— _| LeaseMonthlyRent decimallfillilJ 2} I— LeaseDeposit decimallfilfl, 2) I— r '— EDHEDRDESflL...nanceRequest CONCORDISQLSE...1 - dbo.Leas Column Name I Fillth Nulls _| MaintenanceReouestKey int I— _| MaintenanceReouestDate date _rl '— MaintenanceReouestF‘roblem nyarcharIIMFiX) I— '— Data Type LeaseNumber int EDHEDRDH5QL5E...nceResulutipn CDNCDRDISQL. . .nanteRequest Cplumn Name I Data Type _}I MaintenanteResplutianey Int I— _I MaintenanteResplutianate I:late IIIIIIIIIIIIII IIIIIIIIIIIII I, _I MaintenanteResplutipnType nyarcharIIEDII I— _I MaintenanteResplutipnActipn nyarcharIIZSE-II I- _I MaintenanteResplutianxpense I:leI:imalI:1DJ 2} I— _I MaintenanteRequestKey int I- EDHEDRDESQLE....RentPayment CDNCDRDISQLSE. . .nteRe _I Cplumn Name I Data Type _}I RentF‘aymentKey int I— —l Rentpaymenmate date .............. ............. ., _| RentF‘aymentFumpunt tletimallfillilJ 2) I- _| LeaseNumber int I— '33'l2'l'3'2t Ei='=iF'l'I'f'Ef EDHEDRDRSQLS... — dbu.Tenant CDNCDRDISQLS. . . .RentF'ay Cpnnett‘r i: T _ _l lCplLImn Name I Data Type E L's CDNCDRDISQLSERHER{SQLSeryer1D.5 ll TenantKey int _____________ _____________ El L] Databases _I TenantLastName nyarcharIIEEEflI I- l—J SVStEm Databases _I TenantFirstName nyarcharIIEEE-II I- [J AdyentureWprksLTEDDEi _I I. [J RepertSeryer$SQLSER'-.I'ER [J RepertSeryer$SQLSERVERTempD [J WildepdApartment El LJ WildepdApartmentDBI L] Database Diagrams El L] Tables L] System Tables :I dbp.EiuilI:ling :I clbp..fi.partment :I clbp.Lease :I dbp.MaintenanceRequest :I dbp.MaintenanceResplutiI :I clbp.RentPayment :I clbp.Tenant EHEEHHE SQLQuerleql -...istratur (54))* CONCORDISQLSE...1 - dbe.Lease CONCORDISQL...nanceRequest EXEC sp_he 1p 'Building'l Results I Messages 5 user table 2D14-1D-UE18:23:52.?33 TrimTrailingBlanks FixedLenNulllnSeurce Collatien ' ' Z ' NULL 2 I Buildingfiddress nvarehar no 512 nd [nr’a] [n.r'a] Latin1_EeneraI_C|_.-’-‘-.S 3 I BuildingCity nvarehar no 512 no [Na] [Na] Latin1_|3eneral_Cl_AS 4 I BuildingState nvarehar ne 4 nd [nfa] [n.r'a] Latin1_General_Cl_AS 5 I BuildingZip int ne 4 10 0 nd [nr’a] [n.r'a] NULL 1 PRIMARY inde>r_ke_l,ls clustered, unique, primary key located on PRIMARY BuildingNumber censtrainLlype censlrainLname delete_aelicun update_action status_enal:uled status_fer_replicalien censtrainLkeys 1 PRIMARY KEY[elustered] PK_Building [nfa] [nr'a] BuildingNumber Table is referenced by foreign key 1 WildM-“eedfipartmentDm.dbeApartment: FK_A|:Iartment 13 Query executed successfully. CONCORDISQLSERVER (10.50 5P1) CONCORDlAdministrator WildWeodApartmentDBl I 00:00:00 I 12 rows SQLQuerylsql -...istrator (5420* CONCORD'LSQLSE. . .1 - dbe.Lease CONCORD'LSQL. . .nanceRequest EXEC Sp_he lp 'Apartmentl' Results Messagesl usel table 2014-10-0818:33:4S.58? TIimTIaiIingBlanks FixedLenNulllnSeurce Cellatien NULL NULL NULL stalus_for_replication constrainLkeys FK_Apartment_Building Nefiletien NeAetien Enabled |s_FeI_Rep|ieatien BuildingNumber REFERENCES Wilmee [Na] [Na] [Na] [Na] ApartmentN umber _’| Table is refeleneed by feleign key ‘I WildWeedApaltmentDE‘l.dbe.Lease: FK_Lease_.-’-‘lpartment @ Query executed successfully. CONCORDESQLSERVER (10.50 SP1) CONCORDlAdministrator WildWoodApartmentDBl I 00:00:00 I 11 rows SQLQuerylsql —...istrator (54))"‘ CONCORD'I,SQLSE...1 - dbo.Lease CONCORD'LSQL“.nanceRequest X EXEC Sp_help 'Lease' j : Flesults l Messagesl TrimTrailingBIanks FiitedLenNulllnSource Collation easeNumber 4 2_| ' Léé'éééiéiiiiéiiém no 3 10 o no [Na] [Na] NULL 3_| LeaseE ndDate date no 3 1|] 0 no [na’a] [n.u’a] NULL 4_l LeaseM onthlyH ent decimal no 8 ‘ID 2 no [na’a] [n.u’a] NULL 5_l LeaseDeoosit decimal no 3 ‘ID 2 no [na’a] [n.u’a] NULL B_l floartmentNumber int no 4 ‘lEI 0 no [na’a] [n.u’a] NULL Not For Fleplication N9.?s3?mitts9!HE9F1_E'Efirisd-.3NULL NULL NULL .l indei-r_ke_l..ls _ _ status_for_replication constraint_keys FDFIEIGN KEY FK_Lease_.-’-‘ipartment No Action No Action Enabled ls_For_Fle|:ulication ApartmentNumber 2_| .. REFERENCES Wilwooflpartme 3_| PRIMARY K... F'K_Lease [na’a] [n.r'a] [nr'a] [n.u’a] LeaseNumber Table is referenced by foreign key 1 WildWood-fiipartmentDBl.dbo.MaintenanceFlequest: FK M Lia Query executed successfully. CONCORDISQLSERVER (10.50 SP1) CONCORDtAdministrator WildWoodApartmentDBl I 00:00:00 I 1 rows CONCORDISQLSE...1 - dbo.Lease CONCORDISQL...nanceRequest = X he 11: 'HaintenanceRequest' : Flewlls l Messagesl user table 2014-10-05 1841:2301? FixedLenN ulll n8 ource Collation TrimTrailingBlanks 1_l%___Mair1Enema???999E?FEE... W M 4 10 0 no We] NULL 2 I MaintenanceFlequestDate date no 3 10 0 no [Na] [Na] NULL 3 I MaintenanceFlequestF'roblem nvarohar no -1 no [Na] [Na] Latin1_General 4 NU LL _*| constraint_name delete_action update_action status_enal:uled status_fol_leplication constrainLkeys FK_MaintenanceFl equest_Lease No Action No Action Enabled |s_FoI_Fleplication LeaseNumber " REFERENCES 3 PRIMARY KEY [clusteled] F'K_MaintenanoeFlequest [nfa] [nx'a] [nfa] [n.r'a] MaintenanceFlE _’l Table is referenced by foreign key 'I WildWoodApartmentDEl.dbo.MaintenanoeFlesolution: F. a Query executed successfully. CONCORDISQLSERVER (10.50 SP1) CONCORDlAdministrator WildWoodRpartmentDBl I 00:00:00 I 13 rows SQLQuerylsql —...istrator (54))* CONCORDISQLSE...1 — dbo.Lease CONCORDISQL...nanI:eRequest = X ‘ EXEC sp_help 'HaintenanceResolution' : RESUHS l Messagesl Createchatetime ‘l MaintenanoeResolution dbo user table 2014-10-0513:45;54.1DD Computed Length Preo TiimTiailingBlanks FiHedLenNulllnSouioe Collation MaintenanoeResolutionKey int no 4 10 El no [na’a] NULL 2_|‘"iii§iiiiéiiéiiééfiéééifiiiEiiEi'éié“ date no 3 10 a no we] [nr'a] NULL 3_| MaintenanceResolutionType nvarchar no 100 no [na’a] [nr'a] Latin'l_Gene 4_l MaintenanoeResolutionfiotion nvarohal no 512 no [nfa] [m'a] Latin‘l_GenE 5_l MaintenanoeResolutionExpense decimal no 3 ‘ID 2 no [na’a] [ne’a] NULL MaintenanceRequestKey int he 4 10 El no [na’a] [nr'a] NULL fl Not For Replication N9..if???PEPE.E?!HTFI.E'EI?FI?°'- NULL NULL NULL status_for_replioation oonstrainl Maintene REFERE [n.r'a] Maintene fl |s_For_R eplieation 3 I PRIMARY K... PK_M aintenanoeR esolution [m'a] [m'a] [n.u’a] 9 Query executed successfully. CONCORDESQLSERVER (10.50 SP1) CONCORD'LAdministrator WildWoodApartmentDBl I 00:00:00 I 14 rows SQLQuerylsql —...istrator (54))* CONCORDISQLSE. . .1 — dbe.Lease EXEC Sp_help 'RentPay‘ment'l CONCORDISQL. . .nanceRequest : Results | Messagesl 1 |§"flgplfiamsntuuj dbe user table 2014-1n-ne1a:43:32_350 TIimTrailingBlanks FlHBElLBI’IN ulllnSeuIce Cellatien RentF'aymentKey ' no 4 1n n no [na’a] [na’a] NULL 2_|"HERE'S}HEEEESEE” ' no 3 1n n he [Ma] [Ma] NULL 3_| RentF'aymentAmdunt decimal nd El 10 2 no [Ma] [Ma] NULL 4 LeaseNumber int he 4 10 III no [Ma] [Ma] NULL NULL NULL NULL 1 indea-Lname inde>:_desc:Iipti0n inde>:_ke_I.Js ‘l PK_RentF'a}Ime clusteled, unique, primary key located on PRIMARY RentF'aymentKey constrainLtype constlainLname delete_aetidn update_aeticun status_enal:uled status_fdl_leplieatidn censtlainLkeys ‘l FOREIGN KEY FK_RentF'a_I.Jment_Lease No Action Nohction Enabled ls_FOI_Replicatien LeaseNumbel 2 I REFERENCES WildWc 3 IPRIMflRYKEYEIustered] PK_RentF'a_I,Iment [ne’a] [na’a] [na’a] [n.u’a] RentF'aymentKey _’| Q Query executed successfully. CONCORD'LSQLSERVER (10.50 SP1) CONCORDIAdministratdr WildeddApartmentDBl I IZID:DEI:EIIJ I 12 rows SQLQuerylsql —...istratc|r (54))* EXEC Sp_help 'Tenant' CONCORDISQLSE. . .1 - clbe.Lease CONCORD'LSQL. . .nanceRequest Results | Messagesl Createchlatetime be user table 2014-10-05 18:51:2?.300 - Column_name Computed Length Pree TrimTIailingBlanks FiHeclLenNulllnSeuIce Cellatien 1 TenantKey j int no 4 10 n no [nx'a] [nJa] NULL 2 I TenantLastName nvarehal no 512 no [nx'a] [na’a] Latin1_Genera|_C|_.-’-‘AS 3 ITenantFilstName nvarehal no 512 no [n.u’a] [na’a] Latin1_Genera|_C|_.-’-‘AS Not For Replication NULL NULL NULL 1 incleH_ke_I..Is 1 PK_Tenant clustelecl, unique, primaly key located on F'Fthf-‘AFW TenantKey censtlaint_name clelete_ac:tien upclate_ac:tien status_enab|ec| status_fer_lep|icatien eenstrainLkeys E PK_Tenant [na’a] [n.u’a] [ne’a] TenantKey @ Query executed successfully. CONCORD'LSQLSERVER (10.50 SP1) CONCORDtAdministrater WildWeeclApartmentDBl I 00:00:00 I 9 rows ...
View Full Document

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern