Question: Task 1: (25 marks) Conceptual Model (ER Model) In task 1, your group has to design a conceptual model (ER Model) for the given admission

Task 1: (25 marks) Conceptual Model (ER Model) In task 1, your group has to design a conceptual model (ER Model) for the given admission data. The aim is that you design the database which you will then implement in MS Access and explain it in brief; including the reasoning for your choices of entities. (Hint: Check your legacy file/available data. Think how the attributes in the admission file can be grouped. Which data do and/or do not change with the business event? Which existing attribute identifies records uniquely?) Furthermore explain for the client the terms master data, transaction data, normalisation, referential integrity, the primary key in your own words and provide examples from your HEALTH data (legacy file)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
