How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask jatechexpert Your Own Question

jatechexpert
jatechexpert, Computer Software Engineer
Category: Programming
Satisfied Customers: 1433
Experience:  Master of Computer Application plus 5+ year experience in Software development
51205519
Type Your Programming Question Here...
jatechexpert is online now
A new question is answered every 9 seconds

Database Design 2. Given the following business scenario,

Resolved Question:

Database Design
2. Given the following business scenario, create a Crow's Foot ERD using a specialization hierarchy if appropriate. Tiny Hospital keeps information on patients and hospital rooms. The system assigns each patient a patient ID number. In addition, the patient's name and date of birth are recorded. Some patients are resident patients (they spend at least one night in the hospital) and others are outpatients (they are treated and released). Resident patients are assigned to a room. Each room is identified by a room number. The system also stores the room type (private or semiprivate) and room fee. Over time, each room will have many patients who stay in it. Each resident patient will stay in only one room. Every room must have had a patient, and every resident patient must have a room.



7. The FlyRight Aircraft Maintenance (FRAM) division of the FlyRight Company (FRC) performs all maintenance for FRC's aircraft. Produce a data model segment that reflects the following business rules:

• All mechanics are FRC employees. Not all employees are mechanics.

• Some mechanics are specialized in engine (EN) maintenance. Some mechanics are specialized in airframe (AF) maintenance. Some mechanics are specialized in avionics (AV) maintenance. (Avionics are the electronic components of an aircraft that are used in communication and navigation.) All mechanics take periodic refresher courses to stay current in their areas of expertise. FRC tracks all courses taken by each mechanic-date, course type, certification (YIN), and performance.

• FRC keeps a history of the employment of all mechanics. The history includes the date hired, date promoted, date terminated, and so on. (Note: The "and so on" component is, of course, not a real-world requirement. Instead, it has been used here to limit the number of attributes you will show in your design.)
Given those requirements, create the Crow's Foot ERD segment.
Submitted: 5 years ago.
Category: Programming
Expert:  jatechexpert replied 5 years ago.

hi

 

thanks for using justAnswer.com

 

i will help you to do this

 

when you need this

 

thanking you

with regards

Customer: replied 5 years ago.

to day

 

Expert:  jatechexpert replied 5 years ago.

hi

 

oh. within how many hours

Customer: replied 5 years ago.

I need this midnight to day

Expert:  jatechexpert replied 5 years ago.

hi

ok

Expert:  jatechexpert replied 5 years ago.

hi

 

here is the answer in the below link. hope this helps you

 

http://wikisend.com/download/549240/CowERD.doc]CowERD.doc

 

with regards

jatechexpert and 5 other Programming Specialists are ready to help you