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

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)

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple

Module 1 – SLPEquilibrium, Supply and DemandAssignment OverviewProfessional Application with Excel Throughout the MBA program, you will have multiple opportunities to work with Excel using discipline-specific tools. Beyond learning to analyze data, it is crucial to apply findings for practical situations. Combining data, economic theory, and research provides hands-on practical

HRM 3302-22.02.00-5A25-S1, Human Resource Management Unit IV Journal Assignment Instructions Review the performance methods and forms discussed in the

HRM 3302-22.02.00-5A25-S1, Human Resource Management Unit IV Journal Assignment Instructions Review the performance methods and forms discussed in the textbook in Chapter 8 beginning with the How Do We Use Appraisal Methods and Forms? section. This includes the Critical-Incidents Method, Management by Objectives (MBO), Narrative Method or Form, Graphic Rating Scale

REAL WORLD APPLICATION: PLANNING AND DECISION-MAKING ASSIGNMENTINSTRUCTIONSINSTRUCTIONSSelect a technique/concept from the reading regarding Planning and

REAL WORLD APPLICATION: PLANNING AND DECISION-MAKING ASSIGNMENTINSTRUCTIONSINSTRUCTIONSSelect a technique/concept from the reading regarding Planning and Decision-Making (Cost-Volume-Profit) anddevelop a real-world application paper. Select a company that you work for now or have workedfor in the past, or a company in your community of which you have sufficient knowledge. Showhow the

You will create a 10-minute video presentation of your Final MBA Concentration: Corporate Innovation Stratasys Ltd., and post it to the Unit 8 Discussion

You will create a 10-minute video presentation of your Final MBA Concentration: Corporate Innovation Stratasys Ltd., and post it to the Unit 8 Discussion Capstone Project Presentation forum. You will comment on at least two fellow students’ presentations. Instructions: Please complete a 10-minute video presentation of your Final Capstone project