W2 Lab1 - o Wmeatscom/suitinaransamei. e e f h m 4 Database...

Info icon This preview shows pages 1–2. 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
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: -- o Wmeatscom/suitinaransamei.sepxnieiaiyismeenetaeeaneiiinaisgrsmemigwar e: e f h m 4 Database Concepts E, [5: 23 Week 7 e Creating 430 stair naiatis. Mindanao ni. I n e we raglan. ewes new WW W e e e e e _ . . 1° . . s v . . flFlnd' . . li' a “WW 1‘ A A A: % mecca: mecca: AaBbci Aastc . IA Task 1 - ReVIew requirements and Paste y n 1 u r lie at, x‘ Ar Wvév "Navmal nuaspaei Heading) Headingz : Ema; % Mm b . I eiipeasra r. ran. r. rsrsarsn We r.l ram 1 usmess ru es Step 1: Log in to PC1. Action: Click Administrator, type password in the password field, and press Enter. Result: The desktop if Pc1 is displayed. Stakelmlders Requirements Owners . Mdatabmmt gflyammznamg mg 1) Open a Word document and list requirements in the following format: and expenditures in each cftheirbuilding Tne data must betirnel y and accurate summer Muir-mitts Managers Enternewtanants,leasesanddepuslts . Trackaccupancyandvacancles . Enterrentpayments . Trackslatepayments Track rnaintenance requests and repairs Tenants Trackthelrleaseagreement . Treukthelrrentpayments neccrdtheir rnaintenance requests 2) Yake a screenshat of the list database requirements for each stakeholder Involved in 1he database. Adieu: 1) Open a Word document and list business rules for the database in the following format: Business Ruleslerwild Wood Apartments Page tart l Wum: as la EngllxnluK] l mllalfi é: a is n ' 2 (‘3 taluzlzuta I ITT llTTenlIliwl 1mm: A tee HME warm in m g, in V 0h23m 44m 1 my: ( ) [Vixen Reference: Review View page layout Malling: A v runner a (allbvllfiaflyi v 11 v A e Aa' % AaBbcht AaBbCEDt AaBbCi AaBch , 6‘ .i. Wm y n I g wk xx x, Nowé. "Navmal "NDXDHU Heading) Headingz : $12; % Em, rant r. 2) Yake a screenshat of the list database requirements for each stakeholder Involved in 1he database. Action: 1) Open a Word document and list business rules for the database in the following format: Stakelmlderx Requirements owners - Thedatabasernustgeneratecntenants,rerits, and expenditures in each cftheirbuilding Tne data must betirnel y and accurate Business Ruleslerwild Wood Apartments Managers Enternewtenants,leasesanddepaslts . TrackOccupancyandvacancles . Enterrentpayments . Tracksiatepayments Track maintenance requests and repairs Tenants Track theirlease agreement. . Trackthelrrentpayments neccrdtheir rnaintenance requests amine“ imam" wimwflndApznmgnu 2) Yake a screenshat of the list of business rules for the database. 1. nentsare duetnefirstnftne month. 2 There is a five day grace period 3 Rentspaldaftertheflvedayperlndareassessedasmfl penalty nepcrts are duetc the office quarterly Step 4: Based on your business rules, requirements, and review of the scenario, define the entities and attributes of the database. Identify at least four entities and each entlty's attributes for the database. Action: Page tart l Ward: In} lay EngllxnIUK] Malena Mlalfi Hint: Take a look at each ofthe forms and make a list ofall the nouns in them. Then set up some preliminary entities and attributes. ITT mTectnsul III-finite a 1648 en s 9 ' “3 iaiaeiauis I tueririr ereirieriri m g . 0h23m 44ml...] 5 m: Open a Word document and define the entities and attributes of the database in the following format: Adownload this module pg Weekz ciaa iant D 9 www practiceslabsoom/authentlcated/lragmentaspxllrlendlyname:Week 2 7 Creating Entity Diagrams Using visiot: 0 page layout File name [71:27! Refuenu: Malling: Renew View j; ~A‘ x Ar % v aaaacaot AaBbCi AaBch , 39:35.; Task 2 - Create entity relationship page 9 n 1 g a ah x, x‘ wags , Naspaai neaainai neaainaz : Ems; E‘Mm d. (llpbaam pl rant pl paragraph r.| Style: pl tditina l Iagram ( ) . Recnrdthelrmalntenancerequests tar Step 1: Open Visio. Adio : 1) From start menu select All Programs, Microsoft Office and open Microsoft visio. Result: Microsoft vi o is opened. HuxinexxRulexlnrWildendApanmentx 1 Fientsare dnetnetirstattne month 2 Thereisa flVE daygrace period 3 Fientspaid attertnetiye dayperiadareassessedasmn penalty 4 Repunsare dnetatneatticennarterly Entity teasetcrrm Attribute Primary Key Monthly rent tease» Relatinnxhip Apartment» Building» Fnreign Key FientAmaants Step 2: Create a database model d gram. Action: 1) From the File tab, click New. Under Template Categories. click Software and Database Rental Payment Expenses AmountFaid Apartment» Date 2) Selectthe Database Model Diagram template. Repair cares Tenant tease» T “m 3) Selectthe us Units option in the right pane and click Create. Result: Qaarterlynepart Manager Address Building» Apartment» The database model diagram is created. Step 3: Enlarge the size. Action.- 1) From the View tab. select the Zoom icon. 2) in the Zoom dialog, select 100% and click OK. Result: Page rarr l Wald: 15H lay EngllXMUK] l Mlalfi is 46 A The size is expanded to 100%. ” (‘3 taluzlzma I Step 4: Create entities. tie rir,it premier in ( 0n22rn 44m [...1 any: ITT llTYecmiul III-finite 9 www practiceslabsoom/authentlcated/lragmentaspxllrlendlyname:Week 2 7 Creating Entity Diagrams Using visiot: f II 0 M Result: Relationships are created Step 6: Set the display options. Adio .- 1) From the Database tap, select the Display Options icon. 2) In the Database Document Options, click on the Relationship tab and select Crow‘s Feet and Click OK. Result: The Display Options are set. Step 7: Set the relationship's cardinality. raia in onestosmany relationships, the best choice is either Zero or more or One or more. For onestosone relationships, the pest choice is either Zero or one or Exactly one. Result: pt raiaigay x Twist :2: m1" at aa Kay Adio - i i ’ri’ :2:;::‘:;,,. 1) Donpleclick the relationship. 3 i i 22:31:”: 2) in the Database Properties Window, under Categories, click Miscellaneous i i i is... n l l R 3) Under Cardinality, choose the cardinality that best fits the relationship. For raiiaia Minter drag a: The relationship cardinality is set. WWW pt Manaeray vmhbm arainian Pmbbm Kimman are Step 8: Set the database driver. Action: 1) From the Database tap, select the Database Drivers icon 2) in the Database Drivers dialog, select Microsoft SQL Sewer. 3) Click OK Result: A is E19 ” “3 ulna/2:115 I L-“EWE W‘UW‘“ ml 4, The database driver is set. 0n4sin 24ml...l Ema: Ste - 9: Take Screenshot of the ERD. A download this module g9 ...
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