Good Assignment on DCIT 214 Information Modeling

Students enrolled in DCIT 214 Information Modeling can use a programming homework service to help complete challenging assignments on database design and SQL queries. Programming homework services employ tutors skilled in entity-relationship diagramming and normalization who can provide examples and explanations when information modeling assignments involve complex data structures.Qn. 1

Assuming suitable entity types and reference modes are understood, which of the following sentences fit our standard pattern for expressing exactly one elementary fact?

  1. Adam likes Eve. [Elementary facts]
  2. Bob does not like John.
  3. Tom visited Los Angeles and New York. (can be split into 2 facts)
  4. Tom visited Los Angeles or New York.
  5. If Tom visited Los Angeles then he visited New York.
  6. Sue is funny. [Elementary facts]
  7. All people are funny.
  8. Some people in New York have toured Australia.
  9. Brisbane and Sydney are in Australia.
  10. Brisbane and Sydney are in the same country.
  11. Who does Adam like? (not a fact, just a question)

For an elementary fact to exist, a given object must play a given property (role), or at least one object takes part in a relationship (Halpin & Morgan, 2010). Elementary facts should not be those that can be fragmented into reduced sub-units of facts “with the same objects”; thus, use neither logical quantifiers [some, all, etc.] nor logical connectives [if, or, not, and, etc.] (Halpin & Morgan, 2010). Sentences (2-5) and (7-10) all contain these quantifiers and connectives. Similarly, sentence (11) does not qualify to be a fact. Thus, only sentences (1) and (6) are elementary facts.

Qn. 2

Indicate at least two different meanings for each of the following sentences, by including names for object types and reference modes.

The sentences below are ambiguous and thus subject to misinterpretation (Halpin & Morgan, 2010). Therefore, the object or entity types that start in capital letters need to be added to eradicate referential ambiguity, as shown below.     

  1. Pluto is owned by Mickey.

Planet (.name) ‘Pluto’ is owned by Galaxy (.name) ‘Mickey’.

Animal (.name) ‘Pluto’ is owned by Person (.name) ‘Mickey’.

  • Dallas is smaller than Sydney.

Person (.name) ‘Dallas’ is smaller than Person (.name) ‘Sydney’.

City (.name) ‘Dallas’ is smaller than City (.name) ‘Sydney’.

  • Arnold can lift 300.

Person (.name) ‘Arnold’ can lift Weight (.nr) 300.

Person (.name) ‘Arnold’ can lift Quantity of Pounds (lb:) 300.    

Perform step 1 of the CSDP for the following output reports. In verbalizing the facts, you may restrict yourself to the top row of the table unless another row reveals a different kind of fact.

AthleteHeight (cm)
Jones EM166
Pie QT166
Smith JA175
Athlete (.name) ‘Jones EM’ has height of Length (cm:) 166.
AthleteHeight (cm)
Jones EM400
Pie QT450
Smith JA550
Athlete (.name) ‘Jones EM’ has height of Length (cm:) 400.
PersonHeight (cm)Year
Jones EM1661955
Pie QT1601970
Smith JA1751955
Person (.name) ‘Jones EM’ has height of Length (cm:) 166 in Year (CE) 1955.
PersonHeight (cm)Year
Jones EM1601970
 Person (.name) ‘Jones EM’ has height of Length (cm:) 160 in Year (CE) 1970.
Advisory panelInternal memberExternal member
Logic programmingColmerauerRobinson
Advisory Panel (.name) ‘Databases’ has Internal Member (.name) ‘Codd’.
Advisory Panel (.name) ‘Databases’ has External Member (.name) ‘Ienshtein’.
Student NrCourseRating
Student (.nr) ‘1001’ has rating (score:) 7 in Course (.name) ‘CS112’.
Ann, BillColin, David, Eve
David, FionaGus
Parents (.name) ‘Ann, Bill’ have Child (.name) ‘Colin’.
Parents (.name) ‘Ann, Bill’ have Child (.name) ‘David’.
Parents (.name) ‘Ann, Bill’ have Child (.name) ‘Eve’
Hades Oz
Country (.name) ‘Wundrland’ has Friends (.name) ‘Oz’.
Country (.name) ‘Wundrland’ has Enemies (.name) ‘Hades’.
AppleAustraliaJune, July, August
 AmericaOct, Dec, Jan
 IrelandOct, Dec
MangoAustraliaNov, Dec, Jan, Feb
PineappleAmericaJune, July
 AustraliaOct, Nov, Dec, Jan
Country (.name) ‘Australia’ produces Fruit (.name) ‘Apple’ in Month (.name) ‘June’.
Country (.name) ‘Australia’ produces Fruit (.name) ‘Apple’ in Month (.name) ‘July’.
Country (.name) ‘Australia’ produces Fruit (.name) ‘Apple’ in Month (.name) ‘August’.


Halpin, T., & Morgan, T. (2010). Information modeling and relational databases. Morgan Kaufmann.

Our Services