Q #4) What are the different design schemas in Data Modelling? Explain with the example ?Īnswer: There are two different kinds of schemas in data modeling
For Example, a data attribute of the provider will be provider identification number, few data attributes of the membership will be subscriber ID, member ID, one of the data attribute of claim will claim ID, each healthcare product or plan will be having a unique product ID and so on. These entities were subscriber, member, healthcare provider, claim, bill, enrollment, group, eligibility, plan/product, commission, capitation, etc.īelow is the conceptual Data Model showing how the project looked like on a high-levelĮach of the data entities has its own data attributes. We had different entities that were linked together. The facets database in my project was created with SQL server 2012. Note: Facets is an end to end solution to manage all the information for health care industry.
So, before you step into the interview discussion, you should have a very clear picture of how data modeling fits into the assignments you have worked upon.Īnswer: I have worked on a project for a health insurance provider company where we have interfaces build in Informatica that transforms and process the data fetched from Facets database and sends out useful information to vendors. Note: This was the very first question in one of my Data Modelling interviews. Q #3) Throw some light on your experience in Data Modelling with respect to projects you have worked on till date? This view actually elaborates how the model will be actually implemented in the database. Physical Data Model will be showing primary keys, foreign keys, table names, column names and column data types.Figure 2 shown inside question#4 in this article depicts a logical model. Logical Model will be showing up entity names, entity relationships, attributes, primary keys and foreign keys in each entity.Figure 1 shown in the later part of this article depicts a conceptual model. Conceptual Model will be just portraying entity names and entity relationships.The conceptual model shows a very basic high level of design while the physical data model shows a very detailed view of design. The level of complexity and detail increases from conceptual to logical to a physical data model. Q #2) Explain your understanding of different data models?Īnswer: There are three types of data models – conceptual, logical and physical. Generally, the data models are created in data analysis & design phase of software development life cycle. We first create the conceptual model, then the logical model and finally move to the physical model. It is the initial step towards database design. Q #1) What do you understand by Data Modelling?Īnswer: Data Modelling is the diagrammatic representation showing how the entities are related to each other. Most Frequently Asked Data Modeling Interview Questions
0 kommentar(er)
