Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Sampling

Authors: Ray Whittington, Dan M Guy, D R Carmichael

5th Edition

047137590X, 9780471375906

More Books

Students also viewed these Accounting questions

Question

Cite ways to overcome fear of failure.

Answered: 1 week ago

Question

Write short notes on Interviews.

Answered: 1 week ago

Question

Define induction and what are its objectives ?

Answered: 1 week ago

Question

Discuss the techniques of job analysis.

Answered: 1 week ago

Question

A greater tendency to create winwin situations.

Answered: 1 week ago