Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

15. [5 Marks] Describe the advantages of database systems over file nystems. 16. [11 Marks] A university provides dormitory housing for approximately half of its

image text in transcribed 15. [5 Marks] Describe the advantages of database systems over file nystems. 16. [11 Marks] A university provides dormitory housing for approximately half of its stadents. Students who choose not to live on campas, or who do not get assigned dormitory space, muat find housing in the surrounding community. Housing listings are for both university-owned housing and for housing owned by private parties. The current listing system revolves around multiple copien of three binders of housing listings. These are separate binden for undergraduate listings, graduate listings, and faculty/staff listings. Within each binder are copies of listings available to n particular group. Listinge either are generated by the college housing office from their own housing units, or from private landlords who call the housing office to list housing vacancios. In addition, atudents or other groups of people who hinve rooms available in a residence may list the room. Each listing contains the following information: type of housing (aparment, bouse, condo, ete.), number of bedrooms, number of bathrooms, other rooms, handieap featurs, other fentures, rent, security deposit, utilitics, date of rvailability, lenso term, landlort name and contact information, restrictions on rental (gender, etg). Each property may be listed in any or all of the binders, to allow the listing party to direct their listing to their target andiense. When the college rents a property, the listing is removed from all binder it appears in. Private landlosds are asked to call in when a property is rented to facilitate the removal of that listing from the bindens. People uning the binders who find housing listings that already lave been rented are nsked to report those so they can be removed. The binders are reviewed at the end of cach month by the housing office staff, and private listinis older than 2 months are removed. a. [3 Marks] Create a DFD contexi disgram. b. [5 Marks] Create level O DFD. Make sure you balance the dingram before you

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Essential SQLAlchemy Mapping Python To Databases

Authors: Myers, Jason Myers

2nd Edition

1491916567, 9781491916568

More Books

Students also viewed these Databases questions

Question

=+c. How much tax revenue does Collegetown earn from this tax?

Answered: 1 week ago