CIS 365 : Database Concepts - ER Diagramming - Software Interfaces - Engineering Assignment Help

Assignment Task :

For the following business rules, use Gliffy to draw the EERDs using the Crows Foot model. Resolve any M:N relationships. Take a screenshot of the final ERD and paste in a Word doc (cropping out gridlines and software interfaces). Label your diagram with the question number only – one per page. Save this file as IS6.pdf and submit to Canvas before the end of the day today.

1. (3) The bank offers 3 kinds of accounts. Checking accounts incur a service charge, savings accounts earn a savings interest rate, and loan accounts are charged a loan interest rate and a payment. Regardless of the account, an account number is assigned as well as the date the account was opened, and the balance of the account. Draw the EERD for the bank accounts. 

2. (3) Each office has several furniture pieces; the ones that are of interest to the company are the tables, desks and filing cabinets. All furniture is assigned an ID and a description. For tables, we keep track of the number of legs; for desks we keep track of the number of sections; for filing cabinets we keep track of the number of drawers. Sometimes staff will use a table as a desk. Draw the EERD for the office furniture. 

3. (4) At the hospital, at any given time a patient is either an in-patient or an out-patient. All in-patients are assigned a bed, and the hospital also keeps track of when that patient is discharged. The rooms in the hospital may have several beds. The beds are rarely 100% filled. The hospital keeps track of each room location (floor or ICU). If the patient is an out-patient, the hospital keeps track of the date when that patient needs to check back. Regardless of whether the patient is an in- or out-patient, the hospital keeps track of the date they were admitted. Each patient has a primary physician and each physician has a specialty. Physicians treat any number of patients, but are required to take a month-long vacation each year. Draw the EERD to depict this situation.

This Engineering Assignment has been solved by our Engineering  Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.