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

DISRUPTIVE MARKETING PLAN: BRAND PROPOSAL PAPER ASSIGNMENT INSTRUCTIONSProduct/Service Topic IdentificationEach student must choose an existing consumer

DISRUPTIVE MARKETING PLAN: BRAND PROPOSAL PAPER ASSIGNMENT INSTRUCTIONSProduct/Service Topic IdentificationEach student must choose an existing consumer product/service to analyze for the Disruptive Marketing Plan.You will submit a proposal in 750–1000 words in regards to your idea using the provided template. Threereferences, including one Journal of Marketing reference, are required.Important: Written

Public managers need to be able to position their organizations to achieve desired program outcomes by using fundamental strategic management techniques.

Public managers need to be able to position their organizations to achieve desired program outcomes by using fundamental strategic management techniques. Managers may be charged with diagnosing complex situations and resolving them in ways that enhance organizational performance. Throughout this course, you have learned strategic perspectives on the management and

PROMPT 1 How can businesses strategically leverage social media platforms to enhance brand visibility, foster audience engagement, and drive growth?

PROMPT 1 How can businesses strategically leverage social media platforms to enhance brand visibility, foster audience engagement, and drive growth? Discuss key tactics including platform selection, content optimization, audience interaction, paid advertising, and performance analytics. Support your response with at least four credible references. MUST BE AT LEAST 500 WORDS

Module Two Project Proposal Guidelines and Rubric instructions attached HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course,

Module Two Project Proposal Guidelines and Rubric instructions attached HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course, we are exploring how the humanities teach us Module Two Project Proposal Guidelines and Rubricinstructions attached  HUM 102 Module Two Project Proposal Guidelines and RubricOverview In this course, we