(Solved) : Information System Needed Manage Data Certain Countries Four Mentioned Report Extracts Sh Q36203777 . . .
An information system is needed to manage data about certaincountries, four of which are mentioned below. The report extractsshown in the following tables provide samples of the data ofinterest. For each report, a domain expert is asked to verbalize inplain English how he/she understands the information intended to beconveyed by the top row of data. This verbalization is providedbelow the relevant report.
Specify an ORM conceptual schema for this UoD, using one or moreschema diagrams. Table 1 and Table 2 may be modelled eitherseparately, with one ORM schema diagram for each, or in combinationwith one schema diagram covering both reports. Table 3 may becomfortably modelled with a single schema diagram.
Include all relevant fact types (unary or binary), uniquenessconstraints (internal or external), mandatory role constraints(simple or disjunctive), value constraints, set-comparisonconstraints between single roles, and subtyping. If a fact type orsubtype is derived, include it on the diagram and provide itsderivation rule. Derivation rules may be specified informally usingany notation that conveys the intended meaning.
Table 1 Extract of details from a report about countries(the full report includes some other countries).
Country
Republic?
President
Prime Minister
Capital
Driving
side
Code
Name
AU
Australia
No
—
Scott Morrison
Canberra
left
PG
Papua New Guinea
No
—
Peter O’Neill
Port Moresby
left
ID
Indonesia
Yes
Joko Widodo
Jakarta
left
SG
Singapore
Yes
Halimah Yacob
Lee Hsieng Loong
Singapore
left
Note: The data sample above is significant for the UoD,except for the final column, e.g. in some countries of interestpeople drive on the right.
Domain expert’s understanding of the top row ofdata:
The country with countrycode ‘AU’ andname ‘Australia’ is not a republic. Its prime minister is ScottMorrison, and its capital is Canberra. People drive on the left inAustralia.
Table 2 Extract from a second report showing furtherdetails about countries.
Country
Year became republic
Year became independent
Largest City
Latitude (o)
Longitude (o)
Australia
—
1901
Sydney
-33.865
151.209444
Papua New Guinea
—
1975
Port Moresby
-9.5
147.116667
Indonesia
1950
—
Jakarta
-6.175
106.828333
Singapore
1965
—
Singapore
1.283333
103.833333
Note:Latitude and longitude are specified in Decimal formatrather than DMS (degree, minute, second) format. Forexample, Sydney’s coordinates in DMS format are33o51’54” S and 151o12’34” E.
Domain expert’s understanding of the top row ofdata:
Australia became independent in 1901,and Sydney (its largest city) has latitude -33.865 degrees andlongitude 151.209444 degrees.
Table 3 Extract of details on population-related datafor various countries.
Country
Population
Area
(km2)
Population density
(/km2)
Australia
25,088,636
7,692,024
3
Papua New Guinea
8,586,525
462,840
19
Indonesia
269,536,482
1,904,569
142
Singapore
5,868,104
710
7804
Note: Population densityfigures are rounded to the nearest integer (assume the informationsystem includes a round function).
Domain expert’s understanding of the top row ofdata:
Australia has a population of 25,088,636, an area of 7,692,024 square kilometres and a populationdensity of 3.
Expert Answer
Answer to Information System Needed Manage Data Certain Countries Four Mentioned Report Extracts Sh Q36203777 . . .
OR