Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started