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

CASE STUDY: BIOPHARMA INC. ASSIGNMENT INSTRUCTIONS OVERVIEW This week we identify and discuss the various factors that influence facility location,

CASE STUDY: BIOPHARMA INC. ASSIGNMENT INSTRUCTIONS OVERVIEW This week we identify and discuss the various factors that influence facility location, capacity,and market allocation when designing a supply chain network. Also, there is a focus on thesources of risk for global supply chains, risk mitigation strategies, the methodologies used toevaluate network

Discussion Thread: Place For this module’s discussion, you will select peer-review journal articles on one of the 4Ps – Place. Keyword search terms might

Discussion Thread: Place For this module’s discussion, you will select peer-review journal articles on one of the 4Ps – Place. Keyword search terms might include one of the following:  marketing channel strategy, distribution, retailers, internet, or supply chain. Once you have selected your peer-reviewed journal articles, post a synopsis of the

MARKETING PAPER: MYOPIA ASSIGNMENT INSTRUCTIONSYou will write 1000 words minimum on the classic Theodore Levitt 1960 paper calledMarketing Myopia.

MARKETING PAPER: MYOPIA ASSIGNMENT INSTRUCTIONSYou will write 1000 words minimum on the classic Theodore Levitt 1960 paper calledMarketing Myopia. ‘Marketing myopia’ is a term coined by Theodore Levitt. A business suffersfrom marketing myopia when a company views marketing strictly from the standpoint of sellinga specific product rather than from the

Module 4 – CaseEconomic Justice and Organizational StrategyAssignment Overview Economic Justice Economic Justice is a global issue. The struggle for

Module 4 – CaseEconomic Justice and Organizational StrategyAssignment Overview Economic Justice Economic Justice is a global issue. The struggle for Economic Justice in modern America is not a new movement. Paradigm-shifting events in 2020 pushed companies and organizations to address inequities and assess their track records while devising a different

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics.

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics. Cross-functional teams, whether virtual or in-person, require a leader adept at understanding varied departmental perspectives, bridging knowledge gaps, and facilitating effective collaboration across specialties.  **Complete SLP 2 before Case 2** Case

Module 2 – SLPFostering CollaborationAssignment OverviewCross-Functional Teams Collaborative cross-functional teams thrive under leadership styles that

Module 2 – SLPFostering CollaborationAssignment OverviewCross-Functional Teams Collaborative cross-functional teams thrive under leadership styles that prioritize open communication, mutual respect, and shared decision-making. **Complete SLP 2 before Case 2** Session Long Project 2 Resources Servant Leadership (2023)Understanding The Role Of Team Dynamics To Make A Healthy Work Environment (2023)Leadership and teamwork dynamics:

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics.

Module 2 – CaseFostering CollaborationAssignment OverviewA Manager’s Role in Collaboration Leadership styles play a role in shaping team dynamics. Cross-functional teams, whether virtual or in-person, require a leader adept at understanding varied departmental perspectives, bridging knowledge gaps, and facilitating effective collaboration across specialties.  **Complete SLP 2 before Case 2** Case

Reply of at least 250 words by 11:59 p.m. (ET). Each reply must demonstrate asubstantive discussion.  Chopra Text: Chapter 1 Discussion Question Chapter

Reply of at least 250 words by 11:59 p.m. (ET). Each reply must demonstrate asubstantive discussion.  Chopra Text: Chapter 1 Discussion Question Chapter 1 Discussion: Understanding the Supply Chain According to Chopra (2019), a supply chain is a network of parties which include manufacturers, suppliers, transporters, warehouses, retailers, and customers,