Which type of database is this? 2. What type database software would you use for this database? 3. Finally, make a context-level data flow diagram and a Diagram 0 data flow diagr

1. which type of database is this?
2. What type database software would you use for this database?
3. Finally, make a context-level data flow diagram and a Diagram 0 data flow diagram.
Field Name Data Type Data Format Field Size Description Example
1 Patient ID Text NNNNNNNNN 9 Unique 9-digit number represented as text 000947968
2 Patient Name Text Alpha 50 Full name of the patient Jimmy Hoffa
3 Date of Exm Date mm/dd/yyyy 10 Date of the radiology exam 01/26/2023
4 Exm Type Text Alpha 25 Type of radiology exam X-ray
5 Radiologist ID Text NNNNNNNN 8 Unique 8-digit number of the radiologist performing the exam 35436971
6 Ordering Physician Text Alpha 50 Name of the physician who ordered the exam Dr. Emmett Brown
7 Imaging Results Text Alpha 1000 Description of the imaging results Normal study
8 Patient Location Text Alpha 25 Inpatient or Outpatient Inpatient
9 Patient Location Boolean 1 Y or N for Admitted or Discharged Y
10 Exam Cost Currency #####.## 8 Cost of the radiology exam expressed in dollars 250.00