Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The task In this part, you will: 1. Design an ORM conceptual schema for a business domain based on sample reports required for that domain.

image text in transcribed

The task In this part, you will: 1. Design an ORM conceptual schema for a business domain based on sample reports required for that domain. 2. Map a different ORM schema to a relational database schema. Part A tasks Note the following points to prepare your answers: 1. Population is significant and no further explanation is required from the domain expert. In other words, carry out your CSDP steps 1 to 6 for the given data only. 2. We strongly recommend that you carry out your CSDP steps starting from Step 1 and ending in Step 6 to prepare your final ORM diagram. But you do not require to submit results of these steps. 3. You are required to submit only your final ORM diagram obtained after performing Step 6. Task 1 Following is a report of Marriage Information of some prime ministers. Specify an ORM conceptual schema for this UOD My 68 Prime Minister McEwen) McEwen ) McMahon W Menzies RG Page ECG Hawke RJL Fraser JM Watson JC Watson JC Spouse McLeod AM Byrne M Hopkins SR Leckie PM Blunt E Masterson H Beggs T Low AJ Lane A Marriage Year PM age at Marriage No of Children 1921 21 1968 1965 57 1920 26 1906 1956 1956 1989 1925 blunt t 26 26 26 The task In this part, you will: 1. Design an ORM conceptual schema for a business domain based on sample reports required for that domain. 2. Map a different ORM schema to a relational database schema. Part A tasks Note the following points to prepare your answers: 1. Population is significant and no further explanation is required from the domain expert. In other words, carry out your CSDP steps 1 to 6 for the given data only. 2. We strongly recommend that you carry out your CSDP steps starting from Step 1 and ending in Step 6 to prepare your final ORM diagram. But you do not require to submit results of these steps. 3. You are required to submit only your final ORM diagram obtained after performing Step 6. Task 1 Following is a report of Marriage Information of some prime ministers. Specify an ORM conceptual schema for this UOD My 68 Prime Minister McEwen) McEwen ) McMahon W Menzies RG Page ECG Hawke RJL Fraser JM Watson JC Watson JC Spouse McLeod AM Byrne M Hopkins SR Leckie PM Blunt E Masterson H Beggs T Low AJ Lane A Marriage Year PM age at Marriage No of Children 1921 21 1968 1965 57 1920 26 1906 1956 1956 1989 1925 blunt t 26 26 26

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_2

Step: 3

blur-text-image_3

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

Auditing Assurance Services And Ethics In Australia

Authors: Alvin Arens

10th Edition

1488609136, 978-1488609138

More Books

Students also viewed these Accounting questions