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,

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!