Easy DonelT (EDI) Lab Services has several technicians who work with equipment. A technician is uniquely identified by a technician id and has a name and a phone number, and email address. Technicians request equipment for use and an equipment may be requested at least once. Moreover, a technician can request multiple times the use of an equipment. An equipment is uniquely identified by an equipment id and has name, status, and cost. EDI tracks assign and return dates when an equipment is assigned to technicians.Use the Information shared about the “Part B-Entities and Attributes”, and “Part B-Business Rules” provided to meet the following: a. Present well-crafted paraphrased definition for Entities types, Attributes and their types, ERD b. Develop in the ERD tool, the Initial ERD and then insert (screenshot) of a correct, legible, labeled Diagram. c. Develop and present correct, legible, labeled, and formatted one set of Major and Expanded (Relationship) Matrixes. Include two additional attributes not mentioned in the Business Case for each entity d. Develop in the ERD tool and then insert (screenshot) of a correct, legible, labeled, and formatted Full Key-Base Model. e. Describe in well-crafted detailed sentences and paragraphs, that are easy to ready and follow, your (process) that lead to the development of (b-d) f. You must submit as part of your solution, the file used to develop the ERDPart B – Entities and Attributes a) Each program has a unique ID, a name, an account code type used, and a program head. b) Equipment has a model number, manufacturer name, and serial number that uniquely identifies it, purchase date, and cost. c) A Biomed is uniquely identified by an employee ID, has a name, an office name, hourly rate, and a phone number. d) To support the relationship between Biomed and Equipment when Preventative Maintenance (PM) are done they track. description to describe the type of service done, submission date, completion date, a status used to set priority for the service, hours worked to complete the service, and total parts cost.Part B – Business Rules 1 . Each program may request zero or more (Optional) equipment and each equipment is requested (Mandatory) at least once by a program (Assumption: equipment are not exclusive to a program.) (Binary/N:M) 2. Each program is assigned (Mandatory) one or more Biomeds and each Biomed is assigned (Mandatory) to one and only one program (Assumption: Biomeds are exclusive to a program) (Binary/1:N) 3. A Biomed may completes Preventative Maintenance (PM) on one or more (Optional) Equipment and each Equipment has (Mandatory) one or more PM done by a Biomed. (Assumption: No restriction on the number of tickets that can be filed by a Biomed) (Binary/N:M)
Please complete all the tabs of this excel with no AI thank you!
Please complete all the tabs of this excel with no AI thank you!