Create er diagrams for the given scenarios

Assignment Help Computer Engineering

Reference no: EM133548716

Question: Create (E)ER diagrams for the following scenarios. (E)ER implies that superclass-subclass relationship may or may not be represented in the model and is dependent on the scenario. Make sure that you have read the mini-world descriptions carefully. Your diagrams should reflect all the entities, relationships, and attributes mentioned in the text descriptions. If you make any assumptions, please specify them in your answers. You may need to add a primary key if one hasn't already been specified in the mini-world description.

USE Crow's foot notation to create the ER diagram. But do not use a combination of both.

SimplyBlue is a health insurance company that wish to collect data in a database about their insurance claims. They keep track of their in-network physicians including their name, physician ID, and the hospital name. Physicians can treat one or more customers. On the other hand, customers can get treated by one or many physicians. As for the customers, SimplyBlue wishes to collect information such as their customer ID, name, address, and policy number. When a customer files a claim with respect to a treatment, it contains the customer ID, physician ID, date of service, medical codes, and total charges. Each customer can get treated by a same physician multiple times, so a separate treatmentRecordNo is also maintained in addition to customer ID and physician ID.

Reference no: EM133548716

Questions Cloud

What is your opinion on the relative clarity : What is your opinion on the relative clarity, elegance, and efficiency of the two algorithms (using the definition and using the formula) to compute F(20)

Discuss the parts of the social ecology theory : Discuss the parts of the Social Ecology Theory and its relationship with the Broken Windows what it means for improving a neighborhood

Design the fsm as a moore fsm : Design the FSM as a Moore FSM. Use one-hot encoding and a minimum number of states. Show all of your work, including your final schematic

What were some of the presumptions in the educational system : what were some of the presumptions in the educational system that the authors referenced, and how might these sorts of presumptions relate

Create er diagrams for the given scenarios : Create (E) ER diagrams for the following scenarios. (E)ER implies that superclass-subclass relationship may or may not be represented in the model

How individuals may progress toward a life of criminality : how individuals may progress toward a life of criminality. In the following sections, we will examine these two theories in the context of different case

How would an ict manager foster the growth : How would an ICT Manager foster the growth of both operational and thought leaders within the unit to meet the demands of upcoming high-impact projects

What theoretical perspective in international relations : States constantly face challenges to their sovereignty, whether from multinational corporations, separatist groups within their borders, or transnational

Security concerns surrounding wireless networks : How does and administrator or even an individual user go about ensuring the security of their wireless network? List a minimum of two methods/techniques

User Account

All Pages