Posted: April 20th, 2022

IT 650 Principles of Database Design

IT 650 Principles of Database Design

Submit the preliminary design of the database for the ultimate challenge. Devise a conceptual mannequin that can greatest handle the case examine situation you chose for the ultimate challenge. Your mannequin ought to embody all crucial entities, relationships, attributes, and enterprise guidelines. Primarily based on the conceptual mannequin, illustrate a logical mannequin on your DBMS that precisely represents all crucial elements of the DBMS to deal with the answer. Create a bodily database design that builds on the nonphysical (conceptual and logical) fashions you crafted. This design contains the conceptual and logical fashions of the database, in addition to the bodily design of the database.

Particularly, the next essential components have to be addressed:

 Assessment and Design

A. Conceptual Mannequin: Primarily based on the enterprise drawback or problem, devise a conceptual mannequin that might greatest handle the issue. Your mannequin ought to embody all crucial entities, relationships, attributes, and enterprise guidelines.

B. Logical Mannequin: Primarily based on the conceptual mannequin, illustrate a logical mannequin on your DBMS that precisely represents all crucial elements of the DBMS to deal with the answer.

C. Bodily Design: Create a bodily database design that builds on the nonphysical (conceptual and logical) fashions you crafted.

Tips for Submission: Your paper have to be submitted as a 6- to 12-page Microsoft Phrase doc utilizing applicable modeling language and/or diagrams. It ought to use double spacing, 12-point Instances New Roman font, and one-inch margins. It ought to embody not less than three sources, which ought to be cited in APA format.Wild Wooden Flats

Wild Wooden Flats owns 20 completely different residence complexes in Washington, Oregon, California, and Idaho. Every residence advanced incorporates anyplace from 10 to 60 separate residences, of various sizes. All residences are leased with a 6 month or yearlong lease.

WooD APArTmenTS

As a follow-up in your preliminary interview with the challenge coordinator, Wild Wooden Flats has agreed to indicate you some

samples of varied kinds and experiences. The primary instance is of a spreadsheet to maintain observe of leases at one residence advanced.

residence quantity

lease quantity

lessee title

Begin Date

finish Date

Lease quantity ($)

Deposit($)

Present

201

#201050109

CharlesSummers

5/1/2013

5/1/2014

1,500.00

three,500.00

1

110

#110060109

Marilyn Newton

6/1/2013

12/1/2013

1,200.00

2,900.00

1

306

#306060109

Janice Lewis

6/1/2013

6/1/2014

1,250.00

three,00zero.00

1

102

#102060109

Larry Thomas

6/1/2013

6/1/2014

1,250.00

three,00zero.00

1

209

#209060109

Mark Patterson

6/1/2013

12/1/2013

1,450.00

three,400.00

1

The second instance is of a spreadsheet used to trace hire funds.

Date

title

residence

lease quantity

quantity paid($)

late

7/1/2013

Martin Scheller

203

#203011208

1,200.00

7/1/2013

Roberta Louise

311

#311060108

1,400.00

7/1/2013

Sue Tam

111

1,400.00

7/1/2013

Laura Henderson

207

#207020209

1,350.00

7/1/2013

Thomas Jones

110

#110010109

1,200.00

7/2/2013

ShannonHall

205

#205010109

1,350.00

7/2/2013

Bob Newton

104

#104030209

1,250.00

7/9/2013

Dennis Smith

209

1,400.00

X

The third is an instance of monitoring upkeep requests and responses.

residence

quantity

Date

drawback

Sort

Decision

Decision

Date

B expense

($)

T expense

($)

303

7/5/2013

Left burner out on vary

electrical

Electrician rewired

7/10/2013

150.00

–

201

7/5/2013

Water wastage from

overflowing bathtub

ground

Changed flooring new tile

7/21/2013

200.00

350.00

101

7/6/2013

Dishwasher backingup

plumbing

Filter clogged;cleared it

7/6/2013

35.00

–

207

7/15/2013

Gap in plaster

partitions

Patched gap

7/17/2013

–

250.00

113

7/15/2013

Fridge failed

utilities

New fridge

7/20/2013

690.00

–

Lastly, right here is an instance of the report that every residence supervisor should flip in to the principle workplace quarterly.

Wild Wooden residences

Quarterly Report

Constructing #

#12

handle

1321 EastLake, Seattle, WA. 98123

Quarter

Spring

12 months

2013

Complete residences

At the moment occupied

%

no.Altering Tenants

45

40

89%

13

Revenues

Complete Lease Income bills

utilities

175,500.00

2,450.00

Upkeep

11,298.00

Repairs

9,790.00

Insurance coverage

5,340.00

newTenant Cleansing

10,400.00

Wages

19,200.00

Complete bills

58,478.00

unrecovered Rents

three,200.00

Complete revenue/loss

113,822.00

FIgure 2-11 Wild Wooden Quarterly Report
Job Shadow Report

I adopted the residence supervisor for the Eastlake Flats, Joe Kindel, for four hours on March 1, 2013. It was the day the rents have been due. Joe’s residence can also be his workplace. The very first thing he did after he opened up and let me in was to select up a locked

field that was chained to the ground simply outdoors his residence door. “The tenants can drop of their rents right here,” he advised me.

Joe took the field inside, unlocked it, and pulled out the checks whereas his pc began up. When it was prepared, he started coming into the renter’s names, residence numbers, and

fee quantities right into a spreadsheet. Whereas he was working, a tenant got here in and handed him a examine. Joe thanked the ten- ant and added the examine to the pile. When he had completed, he checked his checklist in opposition to an inventory of tenants. He advised me that three had not paid their hire but.

He referred to as every of the three. The primary didn’t reply, so he left a message. “I’m not too fearful about him,” Joe advised me. “He isn’t at all times on time, however he at all times pays inside the 5-day grace interval.”

I requested in regards to the grace interval. Joe answered, “The corporate permits a renter to be as much as 5 days late with no penalty. For those who pay after that there’s a $100.00 penalty tacked on to the hire.”

He referred to as the second renter. She was at dwelling and requested if he may wait till the 10th. Joe stated OK after which defined to me, “She’s an older lady and depending on Social Safety and retirement checks. I give her just a little extra leeway. The corporate lets me as a result of she has lived right here ceaselessly and has at all times been a very good tenant. This final one although is simply no good.” He picked up the cellphone and referred to as. He bought no reply, and there was no answering machine. Joe advised me that he was about able to evict this final tenant. He’s habitually late, and he’s really 2 months behind in his hire. Joe tells me how troublesome it’s to truly evict somebody.

Whereas he’s telling me tales about previous evictions, the cellphone rang. A lady in residence 211 advised him that her range wasn’t working. Joe opened a second spreadsheet and entered some

of the small print. He additionally wrote some notes on a pad of paper. He reassured the lady that he would take care of it rapidly and promised to come back by within the afternoon.

After four hours, I thanked Joe for his time and left him to his lunch

Necessities: 7 web page

I’ll add connect samples performed earlier than

Order | Check Discount

Tags: Write my dissertation in a week, Write my dissertation Ireland, Write my dissertation literature review, Write my dissertation proposal, Write my essay 4 me